hive-函数format_number

format_number(number x, int d)

Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, 
the result has no decimal point or fractional part.

select format_number(100000,2)

10,000.00