[jira] [Updated] (HAWQ-229) External table can be altered, which make errors.

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

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

Lei Chang updated HAWQ-229:
---------------------------
    Fix Version/s: backlog

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