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

Hive command line hung

Highlighted

Hive command line hung

Hive command line is hung and gives me below warnings

WARN conf.HiveConf: HiveConf of name hive.server2.enable.impersonation does not exist

WARN conf.HiveConf: HiveConf of name hive.auto.convert.sortmerge.join.noconditionaltask does not exist

checked hive-site.xml and above parms are exist with "true".

in logs not finding any details. please help me fixing the issue

thanks,

sathish

3 REPLIES 3
Highlighted

Re: Hive command line hung

@sathish jeganathan could you please post hivecli.out after running following command

hive > hivecli.out 2>&1

Re: Hive command line hung

this is the output and it's hung. its not moving further to the cli mode

17/07/17 09:28:29 WARN conf.HiveConf: HiveConf of name hive.server2.enable.impersonation does not exist

17/07/17 09:28:29 WARN conf.HiveConf: HiveConf of name hive.auto.convert.sortmerge.join.noconditionaltask does not exist

Logging initialized using configuration in file:/etc/hive/2.5.3.0-37/0/hive-log4j.properties

this is the log from /tmp/userid/logs

2017-07-17 09:38:39,482 INFO[main]: hive.metastore (HiveMetaStoreClient.java:open(402)) - Trying to connect to metastore with URI thrift://hostname :9084

2017-07-17 09:38:39,657 INFO[main]: hive.metastore (HiveMetaStoreClient.java:open(498)) - Connected to metastore.

its getting connected to the metastore but taking too much of time to launch the CLI

thanks,

sathish

Highlighted

Re: Hive command line hung

@sathish jeganathan

can you get the output of following

hive --hiveconf hive.root.logger=DEBUG,console > hivecli.out 2>&1