3 ms·
clickhouse-local is very handy for these tasks: $ echo "2a00:1450:400e:80c::200e 2606:4700::6810:85e5 2a03:2880:f145:82:face:b00c:0:25de 2603:1
by zX41ZdbW 1y ago
clickhouse-local is very handy for these tasks:
$ echo "2a00:1450:400e:80c::200e
2606:4700::6810:85e5
2a03:2880:f145:82:face:b00c:0:25de
2603:1030:c02:8::14
2603:1030:20e:3::23c
2603:1030:b:3::152
2603:1020:201:10::10f
2603:1010:3:3::5b" | ch --structure 'ip IPv6' --query "SELECT ip FROM table ORDER BY ip"
2603:1010:3:3::5b
2603:1020:201:10::10f
2603:1030:b:3::152
2603:1030:20e:3::23c
2603:1030:c02:8::14
2606:4700::6810:85e5
2a00:1450:400e:80c::200e
2a03:2880:f145:82:face:b00c:0:25de