hive 数字如果想存储为String,数字太长会存储为科学计数法,如果不想这样,可以用printf
select cast(34343424.5534324 as string) from table;
结果3.43434245534324E7
select printf("%.2f",34343424.5534324 as string) from table;
结果34343424.55
如果数字本身没有小数,想结果中保留2位小数,则需要先将数字乘以1.0,再做上面的处理