Help Center/ Data Lake Insight/ HetuEngine SQL Syntax Reference/ HetuEngine SQL Syntax/ SQL Functions and Operators/ IP Address Functions
Updated on 2025-08-06 GMT+08:00
View PDF

IP Address Functions

contains(network, address) → boolean

If the CIDR network contains the address value, true is returned.

SELECT contains('10.0.0.0/8', IPADDRESS '10.255.255.255'); -- true 
SELECT contains('10.0.0.0/8', IPADDRESS '11.255.255.255'); -- false  
SELECT contains('2001:0db8:0:0:0:ff00:0042:8329/128', IPADDRESS '2001:0db8:0:0:0:ff00:0042:8329'); -- true 
SELECT contains('2001:0db8:0:0:0:ff00:0042:8329/128', IPADDRESS '2001:0db8:0:0:0:ff00:0042:8328'); -- false