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

Using Hive with MySQL/MariaDB

To set up MySQL/MariaDB for use with Hive:

Steps

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

    1. Download the MySQL Connector/JDBC driver from MySQL.

    2. On the Ambari Server host run:

      ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar
    3. Confirm that

      mysql-connector-java.jar

      is in the Java share directory.

      ls /usr/share/java/mysql-connector-java.jar 
    4. Make sure the .jar file has the appropriate permissions - 644.

    5. Execute the following command:

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

    • Using the MySQL database admin utility:

       # mysql -u root -p
      CREATE USER '<HIVEUSER>'@'localhost' IDENTIFIED BY '<HIVEPASSWORD>';
      GRANT ALL PRIVILEGES ON *.* TO '<HIVEUSER>'@'localhost';
      CREATE USER '<HIVEUSER>'@'%' IDENTIFIED BY '<HIVEPASSWORD>';
      GRANT ALL PRIVILEGES ON *.* TO '<HIVEUSER>'@'%';
      CREATE USER '<HIVEUSER>'@'<HIVEMETASTOREFQDN>' IDENTIFIED BY '<HIVEPASSWORD>';
      GRANT ALL PRIVILEGES ON *.* TO '<HIVEUSER>'@'<HIVEMETASTOREFQDN>';
      FLUSH PRIVILEGES;
    • Where <HIVEUSER> is the Hive user name, <HIVEPASSWORD> is the Hive user password and <HIVEMETASTOREFQDN> is the Fully Qualified Domain Name of the Hive Metastore host.

  3. Create the Hive database.

    The Hive database must be created before loading the Hive database schema.

    # mysql -u root -p
    CREATE DATABASE <HIVEDATABASE>

    Where <HIVEDATABASE> is the Hive database name.