Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using HetuEngine/ Common HetuEngine SQL Syntax/ HetuEngine SQL Functions and Operators/ IP Address Functions
Updated on 2025-03-17 GMT+08:00
View PDF

IP Address Functions

contains(network, address) → boolean

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

Example:

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

SELECT contains('2001:0db8:0:0:0:ff00:0042:8329/128', IPADDRESS '2001:0db8:0:0:0:ff00:0042:8328');