You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hawq.apache.org by "Hongxu Ma (JIRA)" <ji...@apache.org> on 2017/11/06 08:33:00 UTC
[jira] [Created] (HAWQ-1544) prompt file count doesn't match hash
bucket number when reorganize table
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)