Hongxu Ma created HAWQ-1544: ------------------------------- Summary: prompt file count doesn't match hash bucket number when reorganize table Key: HAWQ-1544 URL: https://issues.apache.org/jira/browse/HAWQ-1544 Project: Apache HAWQ Issue Type: Bug Components: Catalog Reporter: Hongxu Ma Assignee: Radar Lei
Reproduce: {code} postgres=# create table t_vm ( i int ) distributed randomly; CREATE TABLE postgres=# insert into t_vm select generate_series(1,10000); INSERT 0 10000 postgres=# show default_hash_table_bucket_number ; default_hash_table_bucket_number ---------------------------------- 6 (1 row) postgres=# set default_hash_table_bucket_number=8; SET postgres=# show default_hash_table_bucket_number ; default_hash_table_bucket_number ---------------------------------- 8 (1 row) postgres=# alter table t_vm set with(reorganize=true) distributed by (i) ; ALTER TABLE postgres=# select count(*) from t_vm; ERROR: file count 8 in catalog is not in proportion to the bucket number 6 of hash table with oid=16619, some data may be lost, if you still want to continue the query by considering the table as random, set GUC allow_file_count_bucket_num_mismatch to on and try again. (cdbdatalocality.c:3776) {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)