[ https://issues.apache.org/jira/browse/HAWQ-360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15123184#comment-15123184 ]
ASF GitHub Bot commented on HAWQ-360: ------------------------------------- Github user wangzw commented on the pull request: https://github.com/apache/incubator-hawq/pull/304#issuecomment-176639257 I have merged it to master. Well done @realdawn ! > Data loss when alter partition table by add two column in one time. > ------------------------------------------------------------------- > > Key: HAWQ-360 > URL: https://issues.apache.org/jira/browse/HAWQ-360 > Project: Apache HAWQ > Issue Type: Bug > Components: DDL > Reporter: Dong Li > Assignee: Ming LI > 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)