guyuqi commented on PR #965:
URL: https://github.com/apache/bigtop/pull/965#issuecomment-1203498501

   @timyuer 
   May I ask: 
   1. which Hive database do you take: MySQL , PostreSQL or Oracle?
   2. How to configure it properly?
   
   And it's better to give more info about what the other dependencies are for 
hive deployment.
   
   Otherwise, it failed to start Hive Metastore.( Hive database: PostreSQL )
   r```
   esource_management.core.exceptions.ExecutionFailed: Execution of 'export 
HIVE_CONF_DIR=/etc/hive/conf ; /usr/lib/hive/bin/schematool -initSchema -dbType 
postgres -userName hive -passWord [PROTECTED] -verbose' returned 1. SLF4J: 
Class path contains multiple SLF4J bindings.
   SLF4J: Found binding in 
[jar:file:/usr/lib/hive/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
   SLF4J: Found binding in 
[jar:file:/usr/lib/hadoop/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
   SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an 
explanation.
   SLF4J: Actual binding is of type 
[org.apache.logging.slf4j.Log4jLoggerFactory]
   Metastore connection URL:     ://ambari-agent-02postgresql:5432/hive
   Metastore Connection Driver :         org.postgresql.Driver
   Metastore connection User:    hive
   org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema 
version.
   Underlying cause: java.sql.SQLException : No suitable driver found for 
://ambari-agent-02postgresql:5432/hive
   SQL Error code: 0
   org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema 
version.
        at 
org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getConnectionToMetastore(HiveSchemaHelper.j
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to