question Re: Hive launch problems in CDH5.7 QS VM in Archives of Support Questions (Read Only)

Hive launch problems in CDH5.7 QS VM

KiranM — Fri, 16 Sep 2022 10:37:32 GMT

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.

Re: Hive launch problems in CDH5.7 QS VM

KiranM — Thu, 01 Sep 2016 03:06:30 GMT

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.

Re: Hive launch problems in CDH5.7 QS VM

anotherrohit — Tue, 13 Sep 2016 18:23:30 GMT

@KiranM How did you reset the hive password?

Re: Hive launch problems in CDH5.7 QS VM

KiranM — Tue, 13 Sep 2016 18:33:12 GMT

Hi,

First connect to MySQL session with root:

$mysql -u root -pcloudera

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

Good luck.

Re: Hive launch problems in CDH5.7 QS VM

Farazhcl — Mon, 03 Oct 2016 17:42:08 GMT

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.

Re: Hive launch problems in CDH5.7 QS VM

KiranM — Sat, 08 Oct 2016 22:03:21 GMT

MySQL considres differently based on hostname.

Try this:

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