Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive launch problems in CDH5.7 QS VM

avatar
Explorer

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.

1 ACCEPTED SOLUTION

avatar
Explorer

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.

View solution in original post

5 REPLIES 5

avatar
Explorer

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.

avatar
Contributor

@KiranM How did you reset the hive password?

avatar
Explorer

Hi,

 

First connect to MySQL session with root:

$mysql -u root -pcloudera

 

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

 

Good luck.

avatar
New Contributor

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.

 

 

 

 

 

avatar
Explorer

MySQL considres differently based on hostname.

 

Try this:

 

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