Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive Errors happend when execute hive --service metastore

Solved Go to solution
Highlighted

Re: Hive Errors happend when execute hive --service metastore

Super Guru

@dennisli,

 

Awesome work tracking that down!

 

The "Gateway" role is merely an indicator that Cloudera Manager should distribute client configuration files to that host for that service.  A hive gateway will ensure that /etc/hive/conf is populated with the necessary configuration to run hive clients on that host.  Since there is no running gateway, the status will be None and that is expected.

 

The parcel files shouldn't need to be modified and are expected to be static.

Cloudera Manager does use those files to generate configuration files for servers and clients based on defaults and on your configuration in CM.

 

I know you ran into some trouble, but I think all the work you did to troubleshoot goes a long way to an understanding the concepts of CM, services, roles, and client configuration :-).

Highlighted

Re: Hive Errors happend when execute hive --service metastore

Explorer

clear explanation!  Thanks  bgooley.

Highlighted

Re: Hive Errors happend when execute hive --service metastore

Contributor

Hi @dennisli ,

 

I hope You are doing well.

 

Please confirm one time in below fields value what i commented:-

<property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value> //this is metadata db
  </property>
  <property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>hive</value> //this is metadata db username
  </property>
  <property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>mypassword</value> //this is metadatapassword
  </property>







Thanks
HadoopHelp

 

Don't have an account?
Coming from Hortonworks? Activate your account here