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

["Lei Chang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lei Chang reopened HAWQ-361:
----------------------------

> 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
>             Fix For: 2.0.0
>
>
> {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)