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

Hive command line hung

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

Highlighted

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