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

Using Hive with PostgreSQL

To set up PostgreSQL for use with Hive:

Steps

  1. On the Ambari Server host, stage the appropriate PostgreSQL connector for later deployment.

    1. Download the PostgreSQL JDBC Driver from PostgreSQL.

    2. On the Ambari Server host run:

      ambari-server setup --jdbc-db=postgres --jdbc-driver=/path/to/postgres/postgresql.jar

    3. Confirm that .jar is in the Java share directory.

      ls /usr/share/java/postgresql-jdbc.jar
    4. Change the access mode of the .jar file to 644.

      chmod 644 /usr/share/java/postgresql-jdbc.jar
    5. Execute the following command:

      ambari-server setup --jdbc-db=postgres
      --jdbc-driver=/usr/share/java/postgresql-jdbc.jar
  2. Create a user for Hive and grant it permissions.

    • Using the PostgreSQL database admin utility:

      echo "CREATE DATABASE <HIVEDATABASE>;" | psql -U postgres
      echo "CREATE USER <HIVEUSER> WITH PASSWORD '<HIVEPASSWORD>';" | psql -U postgres
      echo "GRANT ALL PRIVILEGES ON DATABASE <HIVEDATABASE> TO <HIVEUSER>;" | psql -U postgres
    • Where <HIVEUSER> is the Hive user name, <HIVEPASSWORD> is the Hive user password and <HIVEDATABASE> is the Hive database name.