You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Hubert Zhang (JIRA)" <ji...@apache.org> on 2016/09/01 01:40:20 UTC
[jira] [Commented] (HAWQ-1032) Bucket number of newly added
partition is not consistent with parent table.
[ 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)