[
https://issues.apache.org/jira/browse/HAWQ-229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15111925#comment-15111925
]
ASF GitHub Bot commented on HAWQ-229:
-------------------------------------
Github user huor commented on the pull request:
https://github.com/apache/incubator-hawq/pull/287#issuecomment-173809201
The fix looks good. +1
> External table can be altered, which make errors.
> -------------------------------------------------
>
> Key: HAWQ-229
> URL: https://issues.apache.org/jira/browse/HAWQ-229
> Project: Apache HAWQ
> Issue Type: Bug
> Components: External Tables
> Reporter: Dong Li
> Assignee: Lei Chang
>
> We can't use "alter external table" to alter an external table, but we can
> use "alter table" to alter an external table.
> {code}
> mytest=# create external web table e4 (c1 int, c2 int) execute 'echo 1, 1' ON
> 2 format 'CSV';
> CREATE EXTERNAL TABLE
> mytest=# select * from e4;
> c1 | c2
> ----+----
> 1 | 1
> 1 | 1
> (2 rows)
> mytest=# alter table e4 drop column c2;
> WARNING: "e4" is an external table. ALTER TABLE for external tables is
> deprecated.
> HINT: Use ALTER EXTERNAL TABLE instead
> ALTER TABLE
> mytest=# select * from e4;
> ERROR: extra data after last expected column (seg0 localhost:40000
> pid=57645)
> DETAIL: External table e4, line 1 of execute:echo 1, 1: "1, 1"
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
