Support Questions

Find answers, ask questions, and share your expertise

hive server not start and command not print outout

42396-capture.png

we try to start the hive server on master01 machine as the following:

[root@master01 hive]# su hive

[hive@master01 hive]$ /usr/bin/hive --service hiveserver2

but hive command not print anything and hive server still stop

what are the option to check why hive not start?

Michael-Bronson
1 ACCEPTED SOLUTION

Super Mentor

@uri ben-ari

Please try the following command to start hiveserver2 (looks like above doc link has some issues)

# su hive -l -c 'HIVE_CONF_DIR=/etc/hive/conf.server /usr/hdp/current/hive-server2/bin/hiveserver2 -hiveconf hive.metastore.uris=" " -hiveconf hive.log.dir=/var/log/hive -hiveconf hive.log.file=hiveserver2.log 1>/var/log/hive/hiveserver2.log 2>/var/log/hive/hiveserver2.log &'

.

View solution in original post

5 REPLIES 5

Super Mentor

@uri ben-ari

May be you can try something like mentioned in the link: https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.2/bk_reference/content/starting_hdp_services....

Start HiveServer2. On the Hive Server2 host machine, execute the following commands:

su $HIVE_USER 
nohup /usr/hdp/current/hive-server2/bin/hiveserver2 -hiveconf hive.metastore.uris=/tmp/hiveserver2HD.out 2 /tmp/hiveserver2HD.log

.

Also better to remove the PID file from before starting the process.

# ls -l /var/run/hive/hive-server.pid

.

I run the command but it stuck for along time , regarding the hive-server.pid we have only the file - ls /var/run/hive/ hive.pid , bytheway hive server is running on master03 machine , but not on master01

Michael-Bronson

Super Mentor

@uri ben-ari

Please try the following command to start hiveserver2 (looks like above doc link has some issues)

# su hive -l -c 'HIVE_CONF_DIR=/etc/hive/conf.server /usr/hdp/current/hive-server2/bin/hiveserver2 -hiveconf hive.metastore.uris=" " -hiveconf hive.log.dir=/var/log/hive -hiveconf hive.log.file=hiveserver2.log 1>/var/log/hive/hiveserver2.log 2>/var/log/hive/hiveserver2.log &'

.

Super Mentor

we get many error like EmulatedXAResource@64deb58f, error code TMNOFLAGS and transaction: [DataNucleus Transaction, ID=Xid=#, enlisted resources=[]] 2017-11-01 10:35:20,363 DEBUG [main]: DataNucleus.Transaction (Log4JLogger.java:debug(58)) - Running enlist operation on resource: org.datanucleus.store.rdbms.ConnectionFactoryImpl$EmulatedXAResource@64deb58f, error code TMNOFLAGS and transaction: [DataNucleus Transaction, ID=Xid=#, enlisted resources=[]] javax.jdo.JDODataStoreException: Error executing SQL query "select "DB_ID" from "DBS"". java.sql.SQLSyntaxErrorException: Table/View 'DBS' does not exist. Caused by: ERROR 42X05: Table/View 'DBS' does not exist.

java.lang.RuntimeException: Error applying authorization policy on hive configuration: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

Michael-Bronson
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.