Hive launch problems in CDH5.7 QS VM

[#1]

Hive gives problems on my CDH5.7 Quickstart VM recently.

Hive command takes forever to launch shell. It took about 30 min to start the shell session. Even after shell is launched, it doesn't execute commands.

$ hive
2016-08-31 15:48:27,827 WARN [main] mapreduce.TableMapReduceUtil: The hbase-prefix-tree module jar containing PrefixTreeCodec is not present. Continuing without it.

Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties

................ HERE IT TAKES VERY VERY LONG TIME TO COME BACK.
WARNING: Hive CLI is deprecated and migration to Beeline is recommended.
hive> show databases;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.thrift.transport.TTransportException java.net.SocketTimeoutException: Read timed out)

hive>show tables;

................ AFTER VERY VERY LONG TIME, GIVES BELOW ERROR.

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

hive>

-----

No entries in log files (/var/log/hive/) with "DDLTask" error string, but found with "TTransportException".

Some Hive log entries (not result of these execution though):

/var/log/hive/hive-server2.log

2016-08-31 15:55:49,121 WARN [main]: hive.metastore (HiveMetaStoreClient.java:open(445)) - set_ugi() not successful, Likely cause: new client talking to old server. Continuing without it.
org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129)
at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)

I have run few Hive examples previously & saw the Hive repository metadata (table columns) in mySQL database.. Anybody had faced the similar issues?

Thanks in advance.

[#2 · Accepted solution]

The issue is because hive authentication to metastore is failing. Not sure how hive user password is reset.

I have reset hive user password to cloudera & restarted the VM. Able to launch shell & execute properly now.

[#3]

@KiranM How did you reset the hive password?

[#4]

Hi,

First connect to MySQL session with root:

$mysql -u root -pcloudera

mysql> set PASSWORD FOR 'hive'@'localhost' = PASSWORD('cloudera');

Good luck.

[#5]

password did not set got error   mysql> set PASSWORD FOR 'hive'@'localhost' = PASSWORD('cloudera');
ERROR 1133 (42000): Can't find any matching row in the user table.

[#6]

MySQL considres differently based on hostname.

Try this:

mysql> set PASSWORD FOR 'hive'@'%' = PASSWORD('cloudera');