Hive round floor ceil 用法

round  四舍五入

floor 取左值

ceil 取右值

hive> select round(1.2356);
OK
1.0
Time taken: 0.871 seconds, Fetched: 1 row(s)
hive> select round(1.6356);
OK
2.0
Time taken: 0.163 seconds, Fetched: 1 row(s)
hive> select floor(1.2356);
OK
1
Time taken: 0.407 seconds, Fetched: 1 row(s)
hive> select floor(1.6356);
OK
1
Time taken: 2.447 seconds, Fetched: 1 row(s)
hive> select ceil(1.2356);
OK
2
Time taken: 0.207 seconds, Fetched: 1 row(s)
hive> select ceil(1.6356);
OK
2
Time taken: 0.189 seconds, Fetched: 1 row(s)
hive> 

end