[jira] [Assigned] (HAWQ-1544) prompt file count doesn't match hash bucket number when reorganize table

["Hongxu Ma (JIRA)" <ji...@apache.org>]

     [ 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)