Failed to create table in Hive (AlreadyExistsException)

[Kaustubh Deshpande <ka...@exadatum.com>]

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.