[
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)
