[TRAFODION-3153] CREATE EXTERNAL TABLE doesn't report error if Hive table already exists

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3
• Fix Version/s: 2.3
• Component/s: sql-cmp
• Assignee: Dave Birdsall
• Reporter: Dave Birdsall
• Created: 18/Jul/18 21:11
• Updated: 13/Aug/18 22:41
• Resolved: 19/Jul/18 22:01

Description

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.

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

 

Issue Links

• links to: GitHub Pull Request #1652