建表命令
CREATE DATABASE IF NOT EXISTS data_db;
CREATE TABLE IF NOT EXISTS data_db.log
(
type INT,
day DATE NOT NULL,
timestamp BIGINT NOT NULL,
sip IPV6,
dip IPV6
)
DUPLICATE KEY (`type`, `day`, `timestamp`)
AUTO PARTITION BY RANGE(date_trunc(`day`, 'day')) ()
DISTRIBUTED BY HASH(`type`) BUCKETS 8
PROPERTIES (
"replication_num" = "1",
"compression" = "LZ4",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.start" = "-3600",
"dynamic_partition.end" = "7",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "8",
"dynamic_partition.hot_partition_num" = "0",
"bloom_filter_columns" = "sip,dip"
);
插入数据
INSERT INTO data_db.log VALUES (1, '2025-08-05', 1754386200, '::ffff:10.20.136.244', '::ffff:192.168.1.1');
select 查询支持 IPv4-mapped IPv6地址
delete 删除不支持 IPv4-mapped IPv6地址
请了解此功能的大佬帮忙看看是什么问题。