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.