ipv4与十进制整数的转换

样例数据：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)
);