Home

Obtaining Hive Metastore Details
For CDH+CM

To enable instrumentation for the Hive metastore you need to obtain Hive metastore details from Cloudera Manager.

  1. Obtain the Hive metastore details from the Cloudera Manager by using a CDH REST API.

    • From CDH version 5.5 onward, use the REST API http://cloudera-manager-hostname-or-ip:7180/api/v12/cm/deployment

    • Look at the response body, a JSON-like text format as in the image below.

    • Search the response body for metastore.

    CMGR_rest_api_extracting_HM_pwd.png

  2. Edit /usr/local/unravel/etc/unravel.properties.

    For more information, see Hive Metastore Configuration.

    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

  3. Restart Unravel Server.

    sudo /etc/init.d/unravel_all.sh restart

  4. After restart, confirm that Hive queries appear in Unravel UI in Applications | Applications .

For HDP and MapR

Please contact your cluster administrator.

In this section: