David Wayne Birdsall created TRAFODION-3153:
-----------------------------------------------
Summary: CREATE EXTERNAL TABLE doesn't report error if Hive table
already exists
Key: TRAFODION-3153
URL: https://issues.apache.org/jira/browse/TRAFODION-3153
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.3
Reporter: David Wayne Birdsall
Assignee: David Wayne Birdsall
The following session demonstrates the problem. The second CREATE EXTERNAL
TABLE statement should fail and report that the object already exists, but
instead it reports success.
{quote}
>>drop external table if exists hive.hive.test1;
--- SQL operation complete.
>>
>>create external table hive.hive.test1
+>( a date, b char(20) )
+>row format delimited fields terminated by '|'
+>location '/user/trafodion/hive/exttables/test1';
--- SQL operation complete.
>>
>>select count(*) from hive.hive.test1;
(EXPR)
--------------------
0
--- 1 row(s) selected.
>>
>>-- should fail with error 1387, but reports success
>>create external table hive.hive.test1
+>( a date, b char(20) )
+>row format delimited fields terminated by '|'
+>location '/user/trafodion/hive/exttables/test1';
--- SQL operation complete.
>>exit;
End of MXCI Session
{quote}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
