Doris 4.1.2 临时分区bug

Viewed 13

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

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

0 Answers