Error in Startup: HiveServer2

[#1]

Hi All,

On Starting up hiveserver2 service by running below command in am getting the error, Please help to fix it :).

[root@hdpmaster bin]# hive --service hiveserver2
which: no hbase in (/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin:/home/hdpuser/.local/bin:/home/hdpuser/bin:/home/hdpuser/.local/bin:/home/hdpuser/bin:/home/hdpsysuser/.local/bin:/home/hdpsysuser/bin:/usr/hadoopsw/hadoop-2.7.3/sbin:/usr/hadoopsw/hadoop-2.7.3/bin:/usr/hadoopsw/hive/bin:/usr/hadoopsw/db-derby-10.13.1.1-bin/bin)

Error in Hive.log

............................

Exception thrown when executing query : SELECT 'org.apache.hadoop.hive.metastore.model.MVersionTable' AS NUCLEUS_TYPE,A0.SCHEMA_VERSION,A0.VERSION_COMMENT,A0.VER_ID FROM VERSION A0
NestedThrowables:
java.sql.SQLSyntaxErrorException: Table/View 'VERSION' does not exist.

Caused by: java.sql.SQLSyntaxErrorException: Table/View 'VERSION' does not exist.

Thanks

[#2]

@TalendBigData

beeline is CLI for hiveserver2. so use beeline option

[#3]

I tried Beeline & got the below error.

beeline> !connect jdbc:hive2://hdpmaster:10000
Connecting to jdbc:hive2://hdpmaster:10000
Enter username for jdbc:hive2://hdpmaster:10000:
Enter password for jdbc:hive2://hdpmaster:10000:
17/05/09 01:54:25 [main]: WARN jdbc.HiveConnection: Failed to connect to hdpmaster:10000
Error: Could not open client transport with JDBC Uri: jdbc:hive2://hdpmaster:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: hdpsysuser is not allowed to impersonate anonymous (state=08S01,code=0)

[#4]

I tried from Beeline prompt to connect & got the below error, i checked in hive.log and found Hiveserver2 is not started.

beeline> !connect jdbc:hive2://hdpmaster:10000
Connecting to jdbc:hive2://hdpmaster:10000
Enter username for jdbc:hive2://hdpmaster:10000:
Enter password for jdbc:hive2://hdpmaster:10000:
17/05/09 01:54:25 [main]: WARN jdbc.HiveConnection: Failed to connect to hdpmaster:10000
Error: Could not open client transport with JDBC Uri: jdbc:hive2://hdpmaster:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: hdpsysuser is not allowed to impersonate anonymous (state=08S01,code=0)

[#5]

Hi TalendBigData,

What are the settings for Cloudera Manager > HDFS > Configuration > Hive Proxy User Hosts and Hive Proxy User Groups?

[#6]

h@cloudera

The CM shows the following description and I am using the default value '*' for both. 

"Comma-delimited list of hosts where you want to allow the Hive user to impersonate other users. The default '*' allows all hosts. To disable entirely, use a string that doesn't correspond to a host name, such as '_no_host'"

https://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/bk_installing_manually_book/content/rmp-cha...

[#7]

@saranvisa Are you having the same issue? Or are you working with the OP? Just trying to understand..

Using the hive user should work properly. If you want to use a different user (eg. hdpsysuser), core-site.xml will need entries like the following:
<property>
<name>hadoop.hdpsysuser.server.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.hdpsysuser.server.groups</name>
<value>*</value>
</property>

Was there a particular reason impersonation is needed? Typically, Sentry is recommended for enforcing access policies.