样例数据:184.153.243.168 和 3097097128
1、ipv4转十进制整数
select
CAST(
split('184.153.243.168', '\\.') [0] * 256 * 256 * 256 +
split('184.153.243.168', '\\.') [1] * 256 * 256 +
split('184.153.243.168', '\\.') [2] * 256 +
split('184.153.243.168', '\\.') [3]
AS bigint)
2、十进制整数转ipv4
select
concat_ws('.'
,conv(substr(hex(cast('3097097128' as bigint)),1,2),16,10)
,conv(substr(hex(cast('3097097128' as bigint)),3,2),16,10)
,conv(substr(hex(cast('3097097128' as bigint)),5,2),16,10)
,conv(substr(hex(cast('3097097128' as bigint)),7,2),16,10)
);