keyuquan opened a new issue #4793:
URL: https://github.com/apache/incubator-doris/issues/4793
**Describe the bug**
A clear and concise description of what the bug is.
**To Reproduce**
drop table if exists app_day_group_kpi;
CREATE TABLE app_day_group_kpi (
data_date date COMMENT "时间",
......
) ENGINE=OLAP
UNIQUE KEY(data_date, site_code,group_username)
PARTITION BY RANGE(data_date)
(PARTITION p202007 VALUES [('0000-01-01'), ('2020-08-01')),
PARTITION p202008 VALUES [('2020-08-01'), ('2020-09-01')),
PARTITION p202009 VALUES [('2020-09-01'), ('2020-10-01')),
PARTITION p202010 VALUES [('2020-10-01'), ('2020-11-01')),
PARTITION p202011 VALUES [('2020-11-01'), ('2020-12-01')),
PARTITION p202012 VALUES [('2020-12-01'), ('2021-01-01')),
PARTITION p202101 VALUES [('2021-01-01'), ('2021-02-01')))
DISTRIBUTED BY HASH(site_code) BUCKETS 3
PROPERTIES (
"replication_num" = "1",
"colocate_with" = "site_code",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "month",
"dynamic_partition.start" = "-120",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "3",
"in_memory" = "false",
"storage_type" = "COLUMN",
"storage_format" = "DEFAULT"
);
mysql> INSERT INTO app_day_group_kpi VALUES
('2020-09-20','VN','VNL_tinh09',15,180,542,3,'VN','XSMB',1,1,10000,0,0,0,10000,'2020-10-22
23:59:59');
Query OK, 1 row affected (0.04 sec)
{'label':'insert_b3bafe21dd64f72-8d7447b2fbb766d2', 'status':'VISIBLE',
'txnId':'155888'}
mysql> INSERT INTO app_day_group_kpi VALUES
('2020-11-20','VN','VNL_tinh09',15,180,542,3,'VN','XSMB',1,1,10000,0,0,0,10000,'2020-10-22
23:59:59');
Query OK, 1 row affected (0.04 sec)
{'label':'insert_7547d23318fd4eda-b6482b6135c9e543', 'status':'VISIBLE',
'txnId':'155890'}
mysql> INSERT INTO app_day_group_kpi VALUES
('2020-10-20','VN','VNL_tinh09',15,180,542,3,'VN','XSMB',1,1,10000,0,0,0,10000,'2020-10-22
23:59:59');
ERROR 1064 (HY000): errCode = 2, detailMessage = all partitions have no load
data
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
