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
Attachments
Issue Links
- links to