HUMANIZE_NUMBER (Lakehouse v1)
Returns a readable number.
Analyze Syntax
Section titled “Analyze Syntax”func.humanize_number(x);Analyze Examples
Section titled “Analyze Examples”func.humanize_number(1000 * 1000)┌─────────────────────────────────────┐│ func.humanize_number((1000 * 1000)) │├─────────────────────────────────────┤│ 1 million │└─────────────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”HUMANIZE_NUMBER(x);Arguments
Section titled “Arguments”| Arguments | Description |
|---|---|
| x | The numerical size. |
Return Type
Section titled “Return Type”String.
SQL Examples
Section titled “SQL Examples”SELECT HUMANIZE_NUMBER(1000 * 1000)┌─────────────────────────┐│ HUMANIZE_NUMBER((1000 * 1000)) │├─────────────────────────┤│ 1 million │└─────────────────────────┘