Home

Configuring a Hive Metastore

In order for the Reports > Data Insights tab to populate correctly you must configure the Hive Metastore Access parameters. You also have the option to configure the JDBC parameters managing JDBC pooling.

ahve to have read access to hive metastopre data base

  1. Download the right JDBC connector JAR for your database:

    ADD WHERE THE JAR GOES

  2. In /usr/local/unravel/etc/unravel.properties, edit the following properties:

    Tip

    To locate the values for the above properties see Obtaining Hive Metastore details.

    In other words,

    javax.jdo.option.ConnectionURL=jdbc:drivertype://hive-metastore-database-host/hive
    javax.jdo.option.ConnectionDriverName=driverclass
    javax.jdo.option.ConnectionPassword=hive-metastore-database-password 
    javax.jdo.option.ConnectionUserName=hive-metastore-database-user 

    For example,

    javax.jdo.option.ConnectionURL=jdbc:mysql://congo.unraveldata.com/hive
    javax.jdo.option.ConnectionDriverName=com.mysql.jdbc.Driver 
    javax.jdo.option.ConnectionUserName=hive 
    javax.jdo.option.ConnectionPassword=hadoop

    SRETH THINKS THIS SHOULD BE INTERNAL

  3. Restart Unravel Server.

    sudo /etc/init.d/unravel_all.sh restart
  4. Go to Unravel UI's Applications > Applications page to confirm that Hive queries are displayed. Approximately twenty-four hours after configuration the Reports > Data Insights > Details page displays a list of your Hive Metastore tables along with their KPIs and other details.

Reference

c3p0 project page