ip_cidr function

Applies to: Databricks Runtime 18.2 and above

Returns the canonical representation of an IPv4 or IPv6 CIDR block.

Syntax

ip_cidr ( cidr )

Arguments

• cidr: A STRING or BINARY value representing a valid IPv4 or IPv6 CIDR block.

Returns

The same type as the input (STRING or BINARY), representing the canonical form of the CIDR block.

The function returns NULL if the input is NULL.

Error conditions

• If the input is not a valid CIDR block, the function returns INVALID_CIDR_BLOCK.

Examples

SQL

> SELECT ip_cidr('192.168.1.100/24');
  192.168.1.0/24

> SELECT ip_cidr('2001:0db8:0000:0000:0000:0000:0000:0001/32');
  2001:db8::/32

> SELECT ip_cidr('::ffff:192.0.2.128/120');
  ::ffff:192.0.2.0/120

> SELECT hex(ip_cidr(X'C0A8016418'));
  C0A8010018

> SELECT ip_cidr(NULL);
  NULL

> SELECT ip_cidr('192.168.1.5');
  Error: INVALID_CIDR_BLOCK

Related functions

• try_ip_cidr function
• ip_host function