Scenario: Apache Hive Zeppelin Interpreter gives a Zookeeper error in Azure HDInsight

  • Article

This article describes troubleshooting steps and possible resolutions for issues when using Interactive Query components in Azure HDInsight clusters.

Issue

On an Apache Hive LLAP cluster, the Zeppelin interpreter gives the following error message when attempting to execute a query:

java.sql.SQLException: org.apache.hive.jdbc.ZooKeeperHiveClientException: Unable to read HiveServer2 configs from ZooKeeper

Cause

The Zeppelin Hive JDBC Interpreter is pointing to the wrong URL.

Resolution

  1. Navigate to the Hive component summary and copy the "Hive JDBC Url" to the clipboard.

  2. Navigate to https://clustername.azurehdinsight.cn/zeppelin/#/interpreter

  3. Edit the JDBC settings: update the hive.url value to the Hive JDBC URL copied in step 1

  4. Save, then retry the query

Next steps

If you didn't see your problem or are unable to solve your issue, visit one of the following channels for more support:

  • If you need more help, you can submit a support request from the Azure portal. Select Support from the menu bar or open the Help + support hub.