[
https://issues.apache.org/jira/browse/HAWQ-1032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15453989#comment-15453989
]
Hubert Zhang commented on HAWQ-1032:
------------------------------------
not partition number, but bucket number of sub partition is not consistent with
bucket number of root partition.
In the above case, the bucket number of root partition is 12, while the new
added partition's bucket number is 16.
The query will failed if bucket numbers of every partitions are not the same
> Bucket number of newly added partition is not consistent with parent table.
> ---------------------------------------------------------------------------
>
> Key: HAWQ-1032
> URL: https://issues.apache.org/jira/browse/HAWQ-1032
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Core
> Reporter: Hubert Zhang
> Assignee: Hubert Zhang
> Fix For: 2.0.1.0-incubating
>
>
> Failure Case
> {code}
> set deafult_hash_table_bucket_number = 12;
> CREATE TABLE sales3 (id int, date date, amt decimal(10,2))
> DISTRIBUTED BY (id)
> PARTITION BY RANGE (date)
> ( START (date '2008-01-01') INCLUSIVE
> END (date '2009-01-01') EXCLUSIVE
> EVERY (INTERVAL '1 day') );
> set deafult_hash_table_bucket_number = 16;
> ALTER TABLE sales3 ADD PARTITION START
> (date '2009-03-01') INCLUSIVE END
> (date '2009-04-01') EXCLUSIVE;
> {code}
> The newly added partition with buckcet number 16 is not consistent with
> parent partition.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
