how to format int number output with thousand separator in hive sql

Question

Do you know how to format the output of a number in hive with thousand separator? For example:

data:146452664

output:146,452,664

I use this in Teradata, but don't know how to achieve in Hive.

cast(cast(cast(number as integer) as format'ZZZ,ZZZ,ZZZ,ZZ9') as char(11)) 

Answer 1

Use the format_number() function.

select format_number(146452664,0)

The first argument is the number and second is the number of decimal places to round.If D is 0, the result has no decimal point.