EXPLAIN for a CTAS query  fails if the table already exists in the system
-------------------------------------------------------------------------

                 Key: HIVE-1680
                 URL: https://issues.apache.org/jira/browse/HIVE-1680
             Project: Hadoop Hive
          Issue Type: Bug
          Components: CLI
            Reporter: Shrikrishna Lawande
            Priority: Minor


EXPLAIN for a CTAS query (create table as select) would throw an error "FAILED: 
Error in semantic analysis: org.apache.hadoop.hive.ql.parse.SemanticException: 
Table already exists: temp" if the table already exists in the system

The semantic analyzer should not  validate the tables name in the create table 
statement for 'EXPLAIN' queries.

To repro :


create table test (col1 int, col2 int);

 create table test1 as select * from test;


 explain create table test1 as select * from test;;
FAILED: Error in semantic analysis: 
org.apache.hadoop.hive.ql.parse.SemanticException: Table already exists: test1


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to