[ https://issues.apache.org/jira/browse/HIVE-12011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pengcheng Xiong updated HIVE-12011: ----------------------------------- Affects Version/s: 1.2.1 > unable to create temporary table using CTAS if regular table with that name > already exists > ------------------------------------------------------------------------------------------ > > Key: HIVE-12011 > URL: https://issues.apache.org/jira/browse/HIVE-12011 > Project: Hive > Issue Type: Bug > Affects Versions: 1.2.1 > Reporter: Pengcheng Xiong > Assignee: Pengcheng Xiong > Fix For: 2.0.0 > > Attachments: HIVE-12011.01.patch > > > CTAS temporary table query fails if regular table with the same name already > exists. > Steps to reproduce the issue: > {noformat} > hive> use dbtemptable; > OK > Time taken: 0.273 seconds > hive> create table a(i int); > OK > Time taken: 0.297 seconds > hive> create temporary table a(i int); > OK > Time taken: 0.165 seconds > hive> create table b(i int); > OK > Time taken: 0.212 seconds > hive> create temporary table b as select * from a; > FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: > Table already exists: dbtemptable.b > hive> create table c(i int); > OK > Time taken: 0.264 seconds > hive> create temporary table b as select * from c; > FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: > Table already exists: dbtemptable.b > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)