Support Questions

Find answers, ask questions, and share your expertise

FAILED: SemanticException Unable to fetch table hive

avatar
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

avatar

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

avatar

@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