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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0.0-incubating
• Component/s: Core
• Assignee: Hubert Zhang
• Reporter: Hubert Zhang
• Created: 30/Aug/16 03:20
• Updated: 18/Feb/17 05:27
• Resolved: 22/Dec/16 06:50

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.

Issue Links

• links to: GitHub Pull Request #881
• links to: GitHub Pull Request #884
• links to: GitHub Pull Request #886
• links to: GitHub Pull Request #887

Sub-Tasks

• Add test case of bucket number may not be consistent with parent table.: Closed