HUMANIZE_SIZE (Lakehouse v1)
Returns the readable size with a suffix(KiB, MiB, etc).
Analyze Syntax
Section titled “Analyze Syntax”func.humanize_size(x);Analyze Examples
Section titled “Analyze Examples”func.humanize_size(1024 * 1024)┌────────────────────────────────────────┐│ func.func.humanize_size((1024 * 1024)) │├────────────────────────────────────────┤│ 1 MiB │└────────────────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”HUMANIZE_SIZE(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_SIZE(1024 * 1024)┌─────────────────────────┐│ HUMANIZE_SIZE((1024 * 1024)) │├─────────────────────────┤│ 1 MiB │└─────────────────────────┘