Doris 2.1.10 执行 Delete 删除命令时不支持 IPv4-mapped IPv6地址

Viewed 32

建表命令

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地址
image.png

delete 删除不支持 IPv4-mapped IPv6地址
image.png

请了解此功能的大佬帮忙看看是什么问题。

0 Answers