[
https://issues.apache.org/jira/browse/HAWQ-1032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lili Ma updated HAWQ-1032:
--------------------------
Description:
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 default_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.
was:
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.
> 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 default_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)
