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