1. Hive/HCatalog - Apache Ambari

On the Hive Metastore machine, install the appropriate JDBC .jar file:

For Oracle:
1. Download the Oracle JDBC (OJDBC) driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
  
  Select Oracle Database 11g Release 2 - ojdbc6.jar
2. Copy the .jar file to the Java share directory
```
cp ojdbc6.jar /usr/share/java
```
3. Make sure the .jar file has the appropriate permissions - 644.
For MySQL:
1. Install the connector.
  - RHEL/CentOS
    
    yum install mysql-connector-java-5.0.8-1
  - SLES
    
    zypper install mysql-connector-java-5.0.8-1
2. Confirm that the MySQL .jar file is in the Java share directory
```
ls /usr/share/java/mysql-connector-java.jar
```
3. Make sure the .jar file has the appropriate permissions - 644.

On the Ambari Server host, install the appropriate JDBC .jar file:

For Oracle:
1. Download the Oracle JDBC (OJDBC) driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
  
  Select Oracle Database 11g Release 2 - ojdbc6.jar
2. Copy the .jar file to the Java share directory
```
cp ojdbc6.jar /var/lib/ambari-server/resources
```
3. Make sure the .jar file has the appropriate permissions - 644.
For MySQL:
1. Download the mysql connector driver from the host on which you installed mysql-connector-java.
2. Copy the .jar file to the Java share directory
```
cp mysql-connector-jave.jar /var/lib/ambari-server/resources
```
3. Make sure the .jar file has the appropriate permissions - 644.

Create a user for Hive and grant it permissions:

For Oracle, create the Hive user and grant it database permissions:

# sqlplus sys/root as sysdba
SQL> CREATE USER $HIVEUSER IDENTIFIED BY $HIVEPASSWORD;
SQL> GRANT SELECT_CATALOG_ROLE TO $HIVEUSER;
SQL> GRANT CONNECT, RESOURCE TO  $HIVEUSER;                            
SQL> QUIT;

Where $HIVEUSER is the Hive user name and $HIVEPASSWORD is the Hive user password.

For MySQL, create the Hive user and grant it database permissions
```
# mysql -u root -p
mysql> CREATE USER ‘$HIVEUSER’@’%’ IDENTIFIED BY ‘$HIVEPASSWORD’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘$HIVEUSER’@’%’;
mysql> flush privileges;
```
Where $HIVEUSER is the Hive user name and $HIVEPASSWORD is the Hive user password.

For Oracle only: Load the Hive Metastore Schema

The Hive Metastore database schema must be pre-loaded into your Oracle database using the schema script:
```
sqlplus $HIVEUSER/$HIVEPASSWORD < hive-schema-0.10.0.oracle.sql
```
The file hive-schema-0.10.0.oracle.sql is found in the /var/lib/ambari-server/resources/ directory of the Ambari Server machine, once you have completed the Set Up the Bits step in the install process.