UNHEX (Lakehouse v2)
Converts a hexadecimal string to a character string.
Analyze Syntax
Section titled “Analyze Syntax”func.unhex(<hex_str>)Analyze Examples
Section titled “Analyze Examples”func.unhex('48656C6C6F')
┌─────────┐│ 'Hello' │└─────────┘SQL Syntax
Section titled “SQL Syntax”UNHEX(<hex_str>)SQL Examples
Section titled “SQL Examples”SELECT UNHEX('48656C6C6F');
┌───────┐│ Hello │└───────┘