Does Hive Float primitive can support more than two precision after decimal point?

439 Views Asked by At

Hive support only one precision after decimal point. Can we change the precision value of float in hive? If not can we override the hive float function.

Ex: Hive support float as below
    create table test(amount float);
    amount 
    ------
    100.0
Expectation :
    create table test(amount float(10,4));
    amount
    ------
    10000.0000

But hive float does not support the precision value more than one. How can I change the precision value for float ? Any Hive UDF ? I know hive has decimal/double for more precision values. But we require float to support more precisions.

Any suggestions would be great help.

0

There are 0 best solutions below