2.1. Using Hive with Oracle

To set up Oracle for use with Hive:

On the Ambari Server host, stage the appropriate JDBC driver file for later deployment.
1. Download the Oracle JDBC (OJDBC) driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
2. Select Oracle Database 11g Release 2 - ojdbc6.jar and download the file.
3. Make sure the .jar file has the appropriate permissions - 644.
4. Execute the following command, adding the path to the downloaded .jar file:
  ambari-server setup --jdbc-db=oracle --jdbc-driver=/path/to/downloaded/ojdbc6.jar
Create a user for Hive and grant it permissions.
- Using the Oracle database admin utility:
  # sqlplus sys/root as sysdba CREATE USER <HIVEUSER> IDENTIFIED BY <HIVEPASSWORD>; GRANT SELECT_CATALOG_ROLE TO <HIVEUSER>; GRANT CONNECT, RESOURCE TO <HIVEUSER>; QUIT;
- Where <HIVEUSER> is the Hive user name and <HIVEPASSWORD> is the Hive user password.

Load the Hive database schema.

For a HDP 2.2 Stack

	Important
Ambari sets up the Hive Metastore database schema automatically. You do not need to pre-load the Hive Metastore database schema into your Oracle database for a HDP 2.2 Stack.

Important

Ambari sets up the Hive Metastore database schema automatically.

You do not need to pre-load the Hive Metastore database schema into your Oracle database for a HDP 2.2 Stack.

For a HDP 2.1 Stack
You must pre-load the Hive database schema into your Oracle database using the schema script, as follows: sqlplus <HIVEUSER>/<HIVEPASSWORD> < hive-schema-0.13.0.oracle.sql
Find the hive-schema-0.13.0.oracle.sql file in the /var/lib/ambari-server/resources/stacks/HDP/2.1/services/HIVE/etc/ directory of the Ambari Server host after you have installed Ambari Server.
For a HDP 2.0 Stack
You must pre-load the Hive database schema into your Oracle database using the schema script, as follows: sqlplus <HIVEUSER>/<HIVEPASSWORD> < hive-schema-0.12.0.oracle.sql
Find the hive-schema-0.12.0.oracle.sql file in the /var/lib/ambari-server/resources/stacks/HDP/2.0.6/services/HIVE/etc/ directory of the Ambari Server host after you have installed Ambari Server.
For a HDP 1.3 Stack
You must pre-load the Hive database schema into your Oracle database using the schema script, as follows: sqlplus <HIVEUSER>/<HIVEPASSWORD> < hive-schema-0.10.0.oracle.sql
Find the hive-schema-0.10.0.oracle.sql file in the /var/lib/ambari-server/resources/stacks/HDP/1.3.2/services/HIVE/etc/ directory of the Ambari Server host after you have installed Ambari Server.