Apache Ambari Administration
Also available as:
PDF
loading table of contents...

Using Hive with Oracle

To set up Oracle for use with Hive:

Steps

  1. 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. For Oracle Database 11g: select

      Oracle Database 11g Release 2 drivers > ojdbc6.jar
    3. For Oracle Database 12c: select

      Oracle Database 12c Release 1 drivers > ojdbc7.jar
    4. Make sure the .jar file has the appropriate permissions. For example:

      chmod 644 ojdbc7.jar
    5. Execute the following command, adding the path to the downloaded .jar file:

      ambari-server setup --jdbc-db=oracle --jdbc-driver=/path/to/downloaded/ojdbc7.jar
  2. 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.