MAPREDUCE服务 MRS-IP Address函数

时间:2024-04-10 09:06:17

IP Address函数

contains(network, address) → boolean

当CIDR网络中包含address时返回true。

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
support.huaweicloud.com/cmpntguide-lts-mrs/mrs_01_2499123.html