[ https://issues.apache.org/jira/browse/HAWQ-1544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hongxu Ma reassigned HAWQ-1544: ------------------------------- Assignee: Hongxu Ma (was: Radar Lei) > 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: Hongxu Ma > > 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)