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

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

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)