Doris 4.1.2 临时分区bug

Viewed 42

image.png
上面是原分区

下面这个是临时分区
image.png

数据可以写进p202512 这个分区,但写不进p202601这个分区

INSERT INTO device_meter_realtime TEMPORARY PARTITION(p202601)
select *
from device_meter_realtime where data_time > '2026-01-01' and data_time < '2026-01-05';

errCode = 2, detailMessage = (172.31.17.66)[DATA_QUALITY_ERROR]Encountered un. first_error_msg: no partition for this tuple. tuple=[{"meter_sn(String)":"MT01M5530G2402000021","data_time(DateTimeV2(0))":"2026-01-01 00:05:00","meter_type(Nullable(String))":"NULL","meter_mode(Nullable(INT))":"102","line_ab_volt(Nullable(Decimal(18, 2)))":"419.90","li.... url: http://172.31.17.165:8040/api/_load_error_log?file=__shard_380/error_log_insert_stmt_7206c46d22454d99-b4db4c82354d8e86_7206c46d22454d99_b4db4c82354d8e86

后续替换为正式分区之后,写到这个分区的数据会显示成功,但是查不到,会消失。

1 Answers

这个问题本地估计不好复现。我确认一下:

  1. p202601 这个临时分区是范围是你第二张图中蓝色区域的是吧? [2026-01-01 00:00:00 - 2026-01-05 00:00:00)

  2. 将临时分区换成正式分区,数据能导入,但是看不到? 是这意思吗?如果是这种,就比较奇怪了,如果说你创建一张新的测试表导入呢,也是这个情况吗?