apache-interactive-query-get-started.md

title	description	keywords	services	documentationcenter	tags	author	manager	editor	ms.assetid	ms.service	ms.custom	ms.workload	ms.tgt_pltfrm	ms.devlang	ms.topic	ms.date	ms.author
Use Interactive Query with Azure HDInsight | Microsoft Docs	Learn how to use Interactive Query (Hive LLAP) with HDInsight.		hdinsight		azure-portal	mumian	jhubbard	cgronlun	0957643c-4936-48a3-84a3-5dc83db4ab1a	hdinsight	hdinsightactive	big-data	na	na	article	10/11/2017	jgao

Use Interactive Query with HDInsight

Interactive Query (also called Hive LLAP, or Live Long and Process) is an Azure HDInsight cluster type. Interactive Query supports in-memory caching, which makes Hive queries faster and much more interactive.

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

Note

You can access the Hive service in the Interactive Query cluster only via Ambari Hive View, Beeline, and the Microsoft Hive Open Database Connectivity driver (Hive ODBC). You can’t access it via the Hive console, Templeton, the Azure command-line tool (Azure CLI), or Azure PowerShell.

Create an Interactive Query cluster

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

Execute Hive queries from Interactive Query

To execute Hive queries, you have the following options:

• Use Power BI

  See Visualize big data with Power BI in Azure HDInsight.

• Use Zeppelin

  See Use Zeppelin to run Hive queries in Azure HDInsight .

• Use Visual Studio

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

• Use Visual Studio Code

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

• Run Hive by using Ambari Hive View.

  See Use Hive View with Hadoop in Azure HDInsight.

• Run Hive by using Beeline.

  See Use Hive with 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 Hive by using Hive ODBC.

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

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

1. Sign in to 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 Zeppelin to run Hive queries in Azure HDInsight .
• Learn how to run Hive queries using Data Lake Tools for Visual Studio.
• Learn how to use HDInsight Tools for Visual Studio Code.
• Learn how to use Hive View with Hadoop in HDInsight
• Learn how to use Beeline to submit Hive queries in HDInsight.
• Learn how to connect Excel to Hadoop with the Microsoft Hive ODBC driver.