Use Interactive Query with HDInsight

• 05/07/2019
• 2 minutes to read
• Contributors
  • 
  • 
  • 
  • 
  • 
  • all

Interactive Query (also called Apache Hive LLAP, or Low Latency Analytical Processing) is an Azure HDInsight cluster type. Interactive Query supports in-memory caching, which makes Apache Hive queries faster and much more interactive.

An Interactive Query cluster is different from an Apache Hadoop cluster. It contains only the Hive service.

Create an Interactive Query cluster

For information about creating a HDInsight cluster, see Create Apache Hadoop clusters in HDInsight. Choose the Interactive Query cluster type.

Execute Apache Hive queries from Interactive Query

To execute Hive queries, you have the following options:

• Use Microsoft Power BI

  See Visualize Interactive Query Apache Hive data with Power BI in Azure HDInsight See Visualize big data with Power BI in Azure HDInsight.

• Use Visual Studio

  See Connect to Azure HDInsight and run Apache Hive queries using Data Lake Tools for Visual Studio.

• Use Visual Studio Code

  See Use Visual Studio Code for Apache Hive, LLAP, or pySpark.

• Run Apache Hive by using Apache Ambari Hive View.

  See Use Apache Hive View with Apache Hadoop in Azure HDInsight.

• Run Apache Hive by using Beeline.

  See Use Apache Hive with Apache Hadoop in HDInsight with Beeline.

  You can use Beeline from either the head node or from an empty edge node. We recommend using Beeline from an empty edge node. For information about creating an HDInsight cluster by using an empty edge node, see Use empty edge nodes in HDInsight.

• Run Apache Hive by using Hive ODBC.

  See Connect Excel to Apache Hadoop with the Microsoft Hive ODBC driver.

To find the Java Database Connectivity (JDBC) connection string:

1. Sign in to Apache Ambari by using the following URL: https://<cluster name>.AzureHDInsight.net.

2. In the left menu, select Hive.

3. To copy the URL, select the clipboard icon:

   

Next steps

• Learn how to create Interactive Query clusters in HDInsight.
• Learn how to visualize big data with Power BI in Azure HDInsight.
• Learn how to use Apache Zeppelin to run Apache Hive queries in Azure HDInsight.
• Learn how to run Apache Hive queries using Data Lake Tools for Visual Studio.
• Learn how to use HDInsight Tools for Visual Studio Code.
• Learn how to use Apache Hive View with Apache Hadoop in HDInsight
• Learn how to use Beeline to submit Apache Hive queries in HDInsight.
• Learn how to connect Excel to Apache Hadoop with the Microsoft Hive ODBC driver.