如何在hql上设置所选数字列的比例

import org.apache.hadoop.hive.ql.exec.UDF;
import org.apache.hadoop.io.DoubleWritable;

public class ColumnRatioUDF extends UDF {
    public DoubleWritable evaluate(double numerator, double denominator) {
        if (denominator == 0) {
            return null; // 避免除以0的情况
        }
        double ratio = numerator / denominator;
        return new DoubleWritable(ratio);
    }
}

ADD JAR /path/to/columnratio.jar;
CREATE FUNCTION column_ratio AS 'com.example.ColumnRatioUDF';

SELECT numerator, denominator, column_ratio(numerator, denominator) AS ratio
FROM my_table;