Reply
New Contributor
Posts: 4
Registered: ‎05-09-2017

Error in Startup: HiveServer2

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

Posts: 376
Topics: 11
Kudos: 58
Solutions: 32
Registered: ‎09-02-2016

Re: Error in Startup: HiveServer2

@TalendBigData

 

beeline is CLI for hiveserver2. so use beeline option

New Contributor
Posts: 4
Registered: ‎05-09-2017

Re: Error in Startup: HiveServer2

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)

 

 

 

New Contributor
Posts: 4
Registered: ‎05-09-2017

Re: Error in Startup: HiveServer2

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)

 

 

 

Cloudera Employee
Posts: 39
Registered: ‎12-14-2016

Re: Error in Startup: HiveServer2

Hi TalendBigData,


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

Posts: 376
Topics: 11
Kudos: 58
Solutions: 32
Registered: ‎09-02-2016

Re: Error in Startup: HiveServer2

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...

 

 

Cloudera Employee
Posts: 39
Registered: ‎12-14-2016

Re: Error in Startup: HiveServer2

@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.

 

Announcements