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 2020/03/20 10:06:54 UTC
[GitHub] [incubator-doris] kangpinghuang opened a new issue #3163: delete
result is invalid when there is no predicate
kangpinghuang opened a new issue #3163: delete result is invalid when there is no predicate
URL: https://github.com/apache/incubator-doris/issues/3163
**Describe the bug**
the result is invalid when there is no predicate for count(*) agaist a table with delete.
**To Reproduce**
CREATE DATABASE test_sys_bloom_filter_c_test_delete_on_bf_column_db;
CREATE TABLE test_sys_bloom_filter_c_test_delete_on_bf_column_db.test_sys_bloom_filter_c_test_delete_on_bf_column_tb ( tinyint_key TINYINT NOT NULL, smallint_key SMALLINT NOT NULL, int_key INT NOT NULL, bigint_key BIGINT NOT NULL, char_50_key CHAR(50) NOT NULL, character_key VARCHAR(500) NOT NULL, char_key CHAR NOT NULL, character_most_key VARCHAR(65533) NOT NULL, decimal_key DECIMAL(20, 6) NOT NULL, decimal_most_key DECIMAL(27, 9) NOT NULL, date_key DATE NOT NULL, datetime_key DATETIME NOT NULL, tinyint_value TINYINT SUM NOT NULL, smallint_value SMALLINT SUM NOT NULL, int_value int SUM NOT NULL, bigint_value BIGINT SUM NOT NULL, char_50_value CHAR(50) REPLACE NOT NULL, character_value VARCHAR(500) REPLACE NOT NULL, char_value CHAR REPLACE NOT NULL, character_most_value VARCHAR(65533) REPLACE NOT NULL, decimal_value DECIMAL(20, 6) SUM NOT NULL, decimal_most_value DECIMAL(27, 9) SUM NOT NULL, date_value_replace DATE REPLACE NOT NULL, date_value_max DATE REPLACE NOT NULL, date_value_min DATE REPLACE NOT NULL, datetime_value_replace DATETIME REPLACE NOT NULL, datetime_value_max DATETIME REPLACE NOT NULL, datetime_value_min DATETIME REPLACE NOT NULL, float_value FLOAT SUM NOT NULL, double_value DOUBLE SUM NOT NULL ) AGGREGATE KEY(tinyint_key,smallint_key,int_key,bigint_key,char_50_key,character_key,char_key,character_most_key,decimal_key,decimal_most_key,date_key,datetime_key) PARTITION BY RANGE(tinyint_key) ( PARTITION p_0 VALUES LESS THAN ("0"), PARTITION p_1 VALUES LESS THAN MAXVALUE ) DISTRIBUTED BY HASH(tinyint_key) BUCKETS 10 PROPERTIES ( "bloom_filter_columns"="smallint_key,int_key,bigint_key,char_50_key,character_key,char_key,character_most_key,decimal_key,decimal_most_key,date_key,datetime_key,char_50_value,character_value,char_value,character_most_value,date_value_replace,date_value_max,date_value_min,datetime_value_replace,datetime_value_max,datetime_value_min" );
LOAD LABEL test_sys_bloom_filter_c_test_delete_on_bf_column_db.label_17_01_30_35_279380_79953931 (DATA INFILE("hdfs://host:port/user/palo/test/data/sys/all_type.txt") INTO TABLE `test_sys_bloom_filter_c_test_delete_on_bf_column_tb`) WITH BROKER "hdfs" ("username"="xxx", "password"="xxx") PROPERTIES( "max_filter_ratio"="0.05" );
DELETE FROM test_sys_bloom_filter_c_test_delete_on_bf_column_db.test_sys_bloom_filter_c_test_delete_on_bf_column_tb PARTITION p_1 WHERE bigint_key <= "2";
select count(*) from test_sys_bloom_filter_c_test_delete_on_bf_column_tb where bigint_key > 2;
823
select count(*) from test_sys_bloom_filter_c_test_delete_on_bf_column_tb;
5
----------------------------------------------------------------
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] imay closed issue #3163: delete result is invalid
when there is no predicate
Posted by GitBox <gi...@apache.org>.
imay closed issue #3163: delete result is invalid when there is no predicate
URL: https://github.com/apache/incubator-doris/issues/3163
----------------------------------------------------------------
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