hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hongxu Ma (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1544) prompt file count doesn't match hash bucket number when reorganize table
Date Mon, 06 Nov 2017 08:33:00 GMT
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)

Mime
View raw message