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.

FAILED: SemanticException Unable to fetch table hive

Highlighted

FAILED: SemanticException Unable to fetch table hive

New Contributor

Hi Guys,

I just ran DESCRIBE "mytable"

I am getting error "FAILED: SemanticException Unable to fetch"

But when I ran same command on auqadata studio its giving metadata information of the table.

But same command failing on hive CL1 . Can you please provide the solution .

2 REPLIES 2

Re: FAILED: SemanticException Unable to fetch table hive

Master Collaborator

Can you check if the location for data that is set in the table is incorrect?

Re: FAILED: SemanticException Unable to fetch table hive

@godavari m

Can you ensure hive metastore is running OK.

Enable debug for hive cli to get more information why its failing

hive --hiveconf hive.root.logger=DEBUG, DRFA --hiveconf hive.log.file=/tmp/debug_hive.log

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