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)
