You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2019/12/21 03:52:17 UTC

[GitHub] [incubator-doris] kangpinghuang opened a new issue #2524: compaction failed because of line check

kangpinghuang opened a new issue #2524: compaction failed because of line check
URL: https://github.com/apache/incubator-doris/issues/2524
 
 
   **Describe the bug**
   CREATE DATABASE test_sys_partition_multi_col_test_partition_delete_db
   CREATE TABLE test_sys_partition_multi_col_test_partition_delete_db.test_sys_partition_multi_col_test_partition_delete_tb ( k1 TINYINT NULL, k2 SMALLINT NULL, k3 INT NULL, k4 BIGINT NULL, k5 DATETIME NULL, v1 DATE REPLACE NULL, v2 CHAR REPLACE NULL, v3 VARCHAR(4096) REPLACE NULL, v4 FLOAT SUM NULL, v5 DOUBLE SUM NULL, v6 DECIMAL(20,7) SUM NULL ) AGGREGATE KEY(k1,k2,k3,k4,k5) PARTITION BY RANGE(k2,k1) ( PARTITION partition_a VALUES LESS THAN ("-127","-127"), PARTITION partition_b VALUES LESS THAN ("-1","-1"), PARTITION partition_c VALUES LESS THAN ("10"), PARTITION partition_d VALUES LESS THAN ("10","2"), PARTITION partition_e VALUES LESS THAN ("126","126"), PARTITION partition_f VALUES LESS THAN ("500") ) DISTRIBUTED BY HASH(k3) BUCKETS 177
   LOAD LABEL test_sys_partition_multi_col_test_partition_delete_db.label_20_17_28_36_244231_720328323 (DATA INFILE("hdfs://szwg-palo-be00.szwg01.baidu.com:54310/user/palo/test/data/sys/partition/partition_type") INTO TABLE `test_sys_partition_multi_col_test_partition_delete_tb`) WITH BROKER "hdfs" ("username"="root", "password"="3trqDWfl")
   DESC test_sys_partition_multi_col_test_partition_delete_db.test_sys_partition_multi_col_test_partition_delete_tb
   LOAD LABEL test_sys_partition_multi_col_test_partition_delete_db.label_20_17_28_38_869276_1684798219 (DATA INFILE("hdfs://szwg-palo-be00.szwg01.baidu.com:54310/user/palo/test/data/sys/partition/partition_type") INTO TABLE `test_sys_partition_multi_col_test_partition_delete_tb`) WITH BROKER "hdfs" ("username"="root", "password"="3trqDWfl")
   DESC test_sys_partition_multi_col_test_partition_delete_db.test_sys_partition_multi_col_test_partition_delete_tb
   DELETE FROM test_sys_partition_multi_col_test_partition_delete_db.test_sys_partition_multi_col_test_partition_delete_tb PARTITION partition_d WHERE k2 = "10" AND k1 < "10"
   LOAD LABEL test_sys_partition_multi_col_test_partition_delete_db.label_20_17_28_58_399290_644129280 (DATA INFILE("hdfs://szwg-palo-be00.szwg01.baidu.com:54310/user/palo/test/data/sys/partition/partition_type") INTO TABLE `test_sys_partition_multi_col_test_partition_delete_tb` (`k1`, `k2`, `k3`, `k4`, `k5`, `v1`, `v2`, `v3`, `v4`, `v5`, `v6`)) WITH BROKER "hdfs" ("username"="root", "password"="3trqDWfl")
   
   if delete with two column conditions, rows_del_filtered will be counted twice, which will lead to line check failure.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [incubator-doris] kangpinghuang closed issue #2524: compaction failed because of line check

Posted by GitBox <gi...@apache.org>.
kangpinghuang closed issue #2524: compaction failed because of line check
URL: https://github.com/apache/incubator-doris/issues/2524
 
 
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org