[HAWQ-1032] Bucket number of newly added partition is not consistent with parent table. - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 2.1.0.0-incubating
Component/s: Core
Labels:
None

Description

Failure Case

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;

The newly added partition with buckcet number 16 is not consistent with parent partition.