hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kaustubh Deshpande <>
Subject Failed to create table in Hive (AlreadyExistsException)
Date Fri, 23 Jun 2017 07:28:48 GMT


   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

   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
   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 '

   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
   for copying data.

   Please help me to find root cause of this error.




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.

View raw message