[ https://issues.apache.org/jira/browse/HAWQ-1639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16555442#comment-16555442 ]
Radar Lei commented on HAWQ-1639: --------------------------------- Please check if you hit the limitation. [https://hawq.incubator.apache.org/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-TABLE.html] h2. Limitations HAWQ does not support using {{ALTER TABLE}} to {{ADD}} or {{DROP}} a column in an existing Parquet table. > Unexpected internal error when truncate and alter in a transaction > ------------------------------------------------------------------ > > Key: HAWQ-1639 > URL: https://issues.apache.org/jira/browse/HAWQ-1639 > Project: Apache HAWQ > Issue Type: Bug > Components: Core > Affects Versions: 2.3.0.0-incubating > Reporter: TaoJIn > Assignee: Radar Lei > Priority: Major > Fix For: backlog > > > hdb=# select version(); > > version > > > > ------------------------------------------------------------------------------------------------------------------------------------------------------------------ > -------------------------------------------------- > PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ > 2.3.0.0-incubating build dev) on x86_64-unknown-linux-gnu, compiled by GCC > gcc (GCC) 4.8.5 20150623 (R > ed Hat 4.8.5-16) compiled on May 4 2018 06:27:27 > (1 row) > > hdb=# begin; > BEGIN > hdb=# select * from test limit 2; > a > -------------------- > asdfsdgrtecvxbfgdh > asdfsdgrtecvxbfgdh > (2 rows) > > hdb=# truncate table test; > TRUNCATE TABLE > hdb=# select * from test limit 2; > a > --- > (0 rows) > > hdb=# alter table test add column b varchar(20) default ''; > ALTER TABLE > hdb=# commit; > ERROR: Unexpected internal error (appendonlywriter.c:525) > hdb=# rollback; > WARNING: there is no transaction in progress > ROLLBACK > hdb=# -- This message was sent by Atlassian JIRA (v7.6.3#76005)