Hive CLI not working (unresponsive)

[#1]

Hi All,

Looks like only my Hive Cli is not working .I am able to access Hive through beeline works fine

.Because the CLI is hanging Ambari is showing metastore critical.We dont have an option to use beeline cz all our code is written to use hive cli .

Any inputs

[#2]

@Shihab

What is the engine used? If you do the following does it work:

hive -hiveconf hive.execution.engine=mr

Please invoke hive as follows and see where it is failing:

hive -hiveconf hive.root.logger=DEBUG,console

any errors would be thrown in the console, read through the same to identify the root cause.

Thanks & Rgds

Venkat

[#3]

Hi @Shihab

In addition to what @vpoornalingam suggested in the above, does restarting hive metastore help?

If not, you can also take a look at hive metastore log which is located in hive host to see if any error is being thrown.