Support Questions
Find answers, ask questions, and share your expertise

Hive CLI not working (unresponsive)

Solved Go to solution

Hive CLI not working (unresponsive)

Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Hive CLI not working (unresponsive)

Contributor

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

View solution in original post

3 REPLIES 3
Highlighted

Re: Hive CLI not working (unresponsive)

@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

Highlighted

Re: Hive CLI not working (unresponsive)

Rising Star

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.

Highlighted

Re: Hive CLI not working (unresponsive)

Contributor

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

View solution in original post