Kaustubh, there is not much to do without you suppling a way to reproduce the issue and/or the relevant logs.
Dudu From: Kaustubh Deshpande [mailto:kaustubh.deshpa...@exadatum.com] Sent: Friday, June 23, 2017 10:29 AM To: user@hive.apache.org; dev-subscr...@hive.apache.org Subject: Failed to create table in Hive (AlreadyExistsException) Hi, · I am facing issue in Apache Hive v0.13.0 for creating table. · I am executing hive script in which i have DROP and CREATE TABLE statements. · CREATE TABLE statement is type of CREATE TABLE db_nm.tble_nm AS SELECT * from db_nm.other_tbl. · db_nm.tble_nm is managed HIve table · ERROR - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. AlreadyExistsException(message:Table tble_nm already exists) · I had this issue only once and didn't reoccurred but i want to find root cause of it. · In logs it has successfully dropped the table and it started creating table and executed map-reduce for copying data and at the end it given 'AlreadyExistsException'. · I tried it with excluding DROP TABLE statement then it has given 'FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: Table already exists: db_nm.tble_nm' as expected without executing map-reduce for copying data. · Please help me to find root cause of this error. Thanks, Kaustubh. DISCLAIMER: This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you should not disseminate, distribute or copy this email. Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system. Email transmission cannot be guaranteed to be secure or error-free, as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender, therefore, does not accept liability for any errors or omissions in the contents of this message which arise as a result of email transmission. If verification is required, please request a hard-copy version.
