Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error dropping incorrectly created table

Highlighted

Error dropping incorrectly created table

New Contributor

Hello,

I am getting errors when I attempt to delete a hive table - the table was created with a location statement that was incorrect and is blank.

 

 

drop table tsar2;
INFO : Compiling command(queryId=hive_20191203141017_996a4e7c-2069-4a64-a01f-91d97bce371f): drop table tsar2
INFO : Semantic Analysis Completed (retrial = false)
INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO : Completed compiling command(queryId=hive_20191203141017_996a4e7c-2069-4a64-a01f-91d97bce371f); Time taken: 0.024 seconds
INFO : Executing command(queryId=hive_20191203141017_996a4e7c-2069-4a64-a01f-91d97bce371f): drop table tsar2
INFO : Starting task [Stage-0:DDL] in serial mode
ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.NullPointerException)
INFO : Completed executing command(queryId=hive_20191203141017_996a4e7c-2069-4a64-a01f-91d97bce371f); Time taken: 0.231 seconds
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.NullPointerException) (state=08S01,code=1)

Don't have an account?
Coming from Hortonworks? Activate your account here