question Hive CLI not working (unresponsive) in Support Questions

Hive CLI not working (unresponsive)

shihab_pri — Wed, 29 Jun 2016 17:48:27 GMT

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

Re: Hive CLI not working (unresponsive)

vpoornalingam — Wed, 29 Jun 2016 17:53:08 GMT

@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

Re: Hive CLI not working (unresponsive)

tsaito — Wed, 29 Jun 2016 22:17:01 GMT

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.

Re: Hive CLI not working (unresponsive)

shihab_pri — Fri, 01 Jul 2016 16:18:08 GMT

Hi @Takahiko Saito @@vpoornalingam

There where multiple instances of Metastores running .When Ambari crashed we tried to start the service manually and created one extra instance and it was consuming the port number .Manually stopped the other instance and rstarted Hive every thing came back to normal .

Thanks for the support