[SPARK-8245] string function: format_number

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: SQL
• Target Version/s: 1.5.0
• Sprint: Spark 1.5 release
• Assignee: Cheng Hao
• Reporter: Reynold Xin
• Created: 09/Jun/15 07:22
• Updated: 16/Jul/15 04:47
• Resolved: 16/Jul/15 04:47

Description

format_number(number x, int d): string

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. (As of Hive 0.10.0; bug with float types fixed in Hive 0.14.0, decimal type support added in Hive 0.14.0)

Issue Links

• links to: [Github] Pull Request #7034 (chenghao-intel)