Thousand Separator with HIVE SQL - format_number()

Hi, I would like to use the format_number() function in HIVE SQL in Expression field to display integer with thousand separator. I’m not able to use Display Format option because the final output is a string. Below is my expression as a text in label field of KPI visual:

concat_ws(’ ', cast(count(distinct ([AU Risk Iinstance Id])) as string), ‘Risks’) as ‘# Risk Instances’

Desired output: 1,000 Risks

Any suggestion would help. Thank you.

@esther there’s no equivalent function in Impala or Arcadia for format_number(). There’s an outstanding request in the Impala JIRA for this so that will have to be implemented first for you to get the desired outcome here.

https://issues.apache.org/jira/browse/IMPALA-9600