[HAWQ-361] Data loss when alter partition table by add two column in one time.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Resolved
• Fix Version/s: 2.0.0.0-incubating
• Component/s: DDL
• Assignee: Lei Chang
• Reporter: Dong Li
• Created: 22/Jan/16 08:24
• Updated: 14/Jul/16 17:57
• Resolved: 14/Jul/16 17:57

Description

CREATE TABLE part_1 (a int, b int, c int)
WITH (appendonly=true, compresslevel=5)
partition by range (a)
(
     partition b start (1) end (50) every (1)
);
insert into part_1 values(1,1,1);

select * from part_1;
 a | b | c
---+---+---
 1 | 1 | 1
(1 row)

alter table part_1 add column p int default 3,add column q int default 4;

select * from part_1;
 a | b | c | p | q
---+---+---+---+---
(0 rows)

When I check hdfs file, I find the size of new hdfs files is 0, which means the data loss when alter the table and create new file for it.

Issue Links

• duplicates: HAWQ-360 Data loss when alter partition table by add two column in one time.