Use these entries to help you troubleshoot any issues you might have installing Hive with non-default databases.
Check the install log:
cp /usr/share/java/${jdbc_jar_name} ${target}] has failures:
true
The Oracle JDBC.jar file cannot be found.
Check the install log:
java.sql.SQLSyntaxErrorException: ORA-01754: a table may contain only one
column of type LONG
The Hive Metastore schema was not properly loaded into the database.
For secure and non-secure clusters, with Hive security authorization enabled, the Hive service check may fail. Hive security authorization may not be configured properly.
Two workarounds are possible. Using Ambari Web, in HiveConfigsAdvanced:
Disable
hive.security.authorization, by setting thehive.security.authorization.enabledvalue to false.or
Properly configure Hive security authorization. For example, set the following properties:
For more information about configuring Hive security, see Metastore Server Security in Hive Authorization and the HCatalog document Storage Based Authorization.
Hive Security Authorization Settings
Property
Value
hive.security.authorization.manager
org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider
hive.security.metastore.authorization.manager
org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider
hive.security.authenticator.manager
org.apache.hadoop.hive.ql.security.ProxyUserAuthenticator
Metastore Server SecurityHive AuthorizationStorage Based Authorization
