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

["Dong Li (JIRA)" <ji...@apache.org>]

Dong Li created HAWQ-361:
----------------------------

             Summary: Data loss when alter partition table by add two column in one time.
                 Key: HAWQ-361
                 URL: https://issues.apache.org/jira/browse/HAWQ-361
             Project: Apache HAWQ
          Issue Type: Bug
          Components: DDL
            Reporter: Dong Li
            Assignee: Lei Chang


{code}
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)
{code}

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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)