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

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HAWQ-229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15111908#comment-15111908 ] 

ASF GitHub Bot commented on HAWQ-229:
-------------------------------------

GitHub user realdawn opened a pull request:

    https://github.com/apache/incubator-hawq/pull/287

    HAWQ-229. Forbid altering external table through altering table.

    Forbid altering external table through altering table.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/realdawn/incubator-hawq HAWQ-229

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-hawq/pull/287.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #287
    
----
commit 7768353a06578fdcdf50589647fcfe68212d946c
Author: doli <do...@pivotal.io>
Date:   2016-01-22T03:57:39Z

    HAWQ-229. Forbid altering external table through altering table.

----


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