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: Error while compiling statement: FAILED: SemanticException Unable to fetch table table_name. null (state=42000,code=40000)

Highlighted

Error: Error while compiling statement: FAILED: SemanticException Unable to fetch table table_name. null (state=42000,code=40000)

New Contributor

Unable to perform any operation on that table.
The command that I tried to execute is drop table tbale_name;

3 REPLIES 3

Re: Error: Error while compiling statement: FAILED: SemanticException Unable to fetch table table_name. null (state=42000,code=40000)

Mentor

@sundeep dande

Can you be more precise? Are you dropping a Mysql; oracle, hive or hbase table? And please under which user were you executing the command,? Have you checked whether you have the correct privileges on the object(table) ie like drop,delete , update etc?

Re: Error: Error while compiling statement: FAILED: SemanticException Unable to fetch table table_name. null (state=42000,code=40000)

New Contributor

I am trying to drop a hive table and yes I have all the correct user level privileges on that table. I am getting that error only when I try to drop certain tables.

Re: Error: Error while compiling statement: FAILED: SemanticException Unable to fetch table table_name. null (state=42000,code=40000)

Rising Star

The above question and the entire response thread below was originally posted in the Community Help track. On Sat Jul 27 19:22 UTC 2019, a member of the HCC moderation staff moved it to the Data Processing track. The Community Help Track is intended for questions about using the HCC site itself, not technical questions about the Nifi Web UI.