Dong Li created HAWQ-229:
----------------------------
Summary: 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 table e4 (c1 int, c2 int) execute 'echo 1, 1' ON 2
format 'CSV';
ERROR: EXECUTE may not be used with a regular external table
HINT: Use CREATE EXTERNAL WEB TABLE instead
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)
