TRY_INET_NTOA (Lakehouse v1)
Takes an IPv4 address in network byte order and then returns the address as a dotted-quad string representation.
Analyze Syntax
Section titled “Analyze Syntax”func.try_inet_ntoa(<integer>)Analyze Examples
Section titled “Analyze Examples”func.try_inet_ntoaA(167773449)
┌───────────────────────────────┐│ func.try_inet_ntoa(167773449) │├───────────────────────────────┤│ 10.0.5.9 │└───────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”TRY_INET_NTOA( <integer> )Aliases
Section titled “Aliases”Return Type
Section titled “Return Type”String.
SQL Examples
Section titled “SQL Examples”SELECT TRY_INET_NTOA(167773449), TRY_IPV4_NUM_TO_STRING(167773449);
┌──────────────────────────────────────────────────────────────┐│ try_inet_ntoa(167773449) │ try_ipv4_num_to_string(167773449) │├──────────────────────────┼───────────────────────────────────┤│ 10.0.5.9 │ 10.0.5.9 │└──────────────────────────────────────────────────────────────┘