{"id":2431,"date":"2018-08-07T00:00:00","date_gmt":"2018-08-07T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster"},"modified":"2023-05-11T15:38:17","modified_gmt":"2023-05-11T22:38:17","slug":"azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/","title":{"rendered":"Azure HDInsight Interactive Query: Ten tools to analyze big data faster"},"content":{"rendered":"<p>Customers use HDInsight Interactive Query (also called Hive LLAP, or Low Latency Analytical Processing) to query data stored in Azure storage &#038; Azure Data Lake Storage in super-fast manner. Interactive query makes it easy for developers and data scientist to work with the big data using BI tools they love the most. HDInsight Interactive Query supports several tools to access big data in easy fashion. In this blog we have listed most popular tools used by our customers:<\/p>\n<h2>Microsoft Power BI<\/h2>\n<p>Microsoft Power BI Desktop has a native connector to perform direct query against\u00a0 HDInsight Interactive Query cluster. You can explore and visualize the data in interactive manner. To learn more see <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/interactive-query\/apache-hadoop-connect-hive-power-bi-directquery\" target=\"_blank\" rel=\"noopener\">Visualize Interactive Query Hive data with Power BI in Azure HDInsight<\/a> and <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hadoop\/apache-hadoop-connect-hive-power-bi\" target=\"_blank\" rel=\"noopener\">Visualize big data with Power BI in Azure HDInsight<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"280\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp\" title=\"image\" width=\"563\"><\/p>\n<h2>Apache Zeppelin<\/h2>\n<p>Apache Zeppelin interpreter concept allows any language\/data-processing-backend to be plugged into Zeppelin. You can access Interactive Query from Apache Zeppelin using a JDBC interpreter. To learn more please see <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hdinsight-connect-hive-zeppelin\" target=\"_blank\" rel=\"noopener\">Use Zeppelin to run Hive queries in Azure HDInsight<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"416\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/82e16bdd-6258-406a-b2e3-c46934daf788.webp\" title=\"image\" width=\"543\"><\/p>\n<h2>Visual Studio Code<\/h2>\n<p>With HDInsight Tools for VS Code, you can submit interactive queries as well at look at job information in HDInsight interactive query clusters. To learn more please see <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hdinsight-for-vscode\" target=\"_blank\" rel=\"noopener\">Use Visual Studio Code for Hive, LLAP or pySpark<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"396\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/93f585ed-b47a-41b5-b71f-904aa9f3c4b4.webp\" title=\"image\" width=\"637\"><\/p>\n<h2>Visual Studio<\/h2>\n<p>Visual Studio integration helps you create and query tables in visual fashion. You can create a Hive tables on top of data stored in Azure Data Lake Storage or Azure Storage. To learn more please see <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hadoop\/apache-hadoop-visual-studio-tools-get-started#run-interactive-hive-queries\" target=\"_blank\" rel=\"noopener\">Connect to Azure HDInsight and run Hive queries using Data Lake Tools for Visual Studio<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"350\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/c41e56c6-75d6-42c1-aca7-eaa159914e79.webp\" title=\"image\" width=\"646\"><\/p>\n<h2>Ambari Hive View<\/h2>\n<p>Hive View is designed to help you author, optimize, and execute queries. With Hive Views you can:<\/p>\n<ul>\n<li>Browse databases.<\/li>\n<li>Write queries or browse query results in full-screen mode, which can be particularly helpful with complex queries or large query results.<\/li>\n<li>Manage query execution jobs and history.<\/li>\n<li>View existing databases, tables, and their statistics.<\/li>\n<li>Create\/upload tables and export table DDL to source control.<\/li>\n<li>View visual explain plans to learn more about query plan.<\/li>\n<\/ul>\n<p>To learn more please see <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hadoop\/apache-hadoop-use-hive-ambari-view\" target=\"_blank\" rel=\"noopener\">Use Hive View with Hadoop in Azure HDInsight<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"275\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/8245e067-59b7-4287-99bf-b8ecb9a80ace.webp\" title=\"image\" width=\"628\"><\/p>\n<h2>Beeline<\/h2>\n<p>Beeline is a Hive client that is included on the head nodes of HDInsight cluster. Beeline uses JDBC to connect to HiveServer2, a service hosted on HDInsight cluster. You can also use Beeline to access Hive on HDInsight remotely over the internet. To learn more please see <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hadoop\/apache-hadoop-use-hive-beeline\" target=\"_blank\" rel=\"noopener\">Use Hive with Hadoop in HDInsight with Beeline<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"351\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/831cc052-a22d-4244-bd9b-597e81510393.webp\" title=\"image\" width=\"602\"><\/p>\n<h2>Hive ODBC<\/h2>\n<p>Open Database Connectivity (ODBC) API, a standard for the Hive database management system, enables ODBC compliant applications to interact seamlessly with Hive through a standard interface. Learn more about how <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=40886\" target=\"_blank\" rel=\"noopener\">HDInsight publishes HDInsight Hive ODBC driver<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"521\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/576baaf4-f949-4aba-8fbe-81b1183f60f2.webp\" title=\"image\" width=\"623\"><\/p>\n<h2>Tableau<\/h2>\n<p>Tableau is very popular data visualization tool. Customers can build visualizations by connecting Tableau with HDInsight interactive Query.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"260\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/f53f0c85-4cd1-4d81-8a37-9b0cb49c3252.webp\" title=\"image\" width=\"476\"><\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"242\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/71b2fc14-9f85-4784-99a1-7dc6c430d33c.webp\" title=\"image\" width=\"458\"><\/h2>\n<h2>Apache DBeaver<\/h2>\n<p>Apache DBeaver is SQL client and a database administration tool. It is free and open-source (ASL). DBeaver use JDBC API to connect with SQL based databases. To learn more, see <a href=\"https:\/\/blogs.msdn.microsoft.com\/ashish\/2018\/05\/30\/how-to-use-dbeaver-with-azure-hdinsight\/\" target=\"_blank\" rel=\"noopener\">How to use DBeaver with Azure #HDInsight<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"362\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/2ed1ac67-50b6-43ac-8b43-ae42fdd7e83a.webp\" title=\"image\" width=\"607\"><\/p>\n<h2>Excel<\/h2>\n<p>Microsoft Excel is the most popular data analysis tool and connecting it with big data is even more interesting for our customers. Azure HDInsight Interactive Query cluster can be integrated with Excel with ODBC connectivity.To learn more, see <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hadoop\/apache-hadoop-connect-excel-hive-odbc-driver\" target=\"_blank\" rel=\"noopener\">Connect Excel to Hadoop in Azure HDInsight with the Microsoft Hive ODBC driver<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" height=\"257\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/b7c0bd70-8350-448d-987b-60ec30b007c3.webp\" title=\"image\" width=\"656\"><\/p>\n<h2>Try HDInsight now<\/h2>\n<p>We hope you will take full advantage fast query capabilities of HDInsight Interactive Query using your favorite tools. We are excited to see what you will build with Azure HDInsight. <a href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-training-resources-learn-about-big-data-using-open-source-technologies\/\" target=\"_blank\" rel=\"noopener\">Read this developer guide<\/a> and follow the quick start guide to learn more about implementing these pipelines and architectures on Azure HDInsight. Stay up-to-date on the latest Azure HDInsight news and features by following us on Twitter <a href=\"https:\/\/twitter.com\/search?q=%23HDInsight&#038;src=typd\" target=\"_blank\" rel=\"noopener\">#HDInsight<\/a> and <a href=\"https:\/\/twitter.com\/AzureHDInsight\" target=\"_blank\" rel=\"noopener\">@AzureHDInsight<\/a>. For questions and feedback, please reach out to <a href=\"mailto:AskHDInsight@microsoft.com\">AskHDInsight@microsoft.com<\/a>.<\/p>\n<h2>About HDInsight<\/h2>\n<p>Azure HDInsight is Microsoft\u2019s premium managed offering for running open source workloads on Azure. Azure HDInsight powers mission critical applications ranging in a wide variety of sectors including, manufacturing, retail education, nonprofit, government, healthcare, media, banking, telecommunication, insurance, and many more industries ranging in use cases from ETL to Data Warehousing, from Machine Learning to IoT, and more.<\/p>\n<h2>Additional resources<\/h2>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/interactive-query\/apache-interactive-query-get-started\" target=\"_blank\" rel=\"noopener\">Get started with HDInsight Interactive Query Cluster in Azure<\/a>.<\/li>\n<li><a href=\"https:\/\/dataworkssummit.com\/berlin-2018\/session\/zero-etl-analytics-with-llap-in-azure-hdinsight\/\" target=\"_blank\" rel=\"noopener\">Zero ETL analytics with LLAP in Azure HDInsight<\/a>.<\/li>\n<li><a href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/hdinsight-interactive-query-performance-benchmarks-and-integration-with-power-bi-direct-query\/\" target=\"_blank\" rel=\"noopener\">Azure HDInsight Performance Benchmarking: Interactive Query, Spark and Presto<\/a>.<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/\" target=\"_blank\" rel=\"noopener\">Learn more about Azure HDInsight<\/a>.<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hdinsight-hadoop-linux-tutorial-get-started\" target=\"_blank\" rel=\"noopener\">Use Hive on HDInsight<\/a>.<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hdinsight-component-versioning#hadoop-components-available-with-different-hdinsight-versions\" target=\"_blank\" rel=\"noopener\">Open Source component guide on HDInsight<\/a>.<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/hdinsight\/hdinsight-release-notes\" target=\"_blank\" rel=\"noopener\">HDInsight release notes<\/a>.<\/li>\n<li><a href=\"https:\/\/social.msdn.microsoft.com\/forums\/azure\/en-us\/home?forum=hdinsight\" target=\"_blank\" rel=\"noopener\">Ask HDInsight questions on Msdn forums<\/a>.<\/li>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/tagged\/hdinsight\" target=\"_blank\" rel=\"noopener\">Ask HDInsight questions on stackoverflow<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Customers use HDInsight Interactive Query (also called Hive LLAP, or Low Latency Analytical Processing) to query data stored in Azure storage &#038; Azure Data Lake Storage in super-fast manner.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1474],"tags":[],"audience":[3054,3057,3053],"content-type":[1511],"product":[2895],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-2431","post","type-post","status-publish","format-standard","hentry","category-analytics","audience-business-decision-makers","audience-data-professionals","audience-it-decision-makers","content-type-best-practices","product-azure-hdinsight-on-azure-kubernetes-service-aks"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Azure HDInsight Interactive Query: Ten tools to analyze big data faster | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"Customers use HDInsight Interactive Query (also called Hive LLAP, or Low Latency Analytical Processing) to query data stored in Azure storage &amp; Azure Data Lake Storage in super-fast manner.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure HDInsight Interactive Query: Ten tools to analyze big data faster | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"Customers use HDInsight Interactive Query (also called Hive LLAP, or Low Latency Analytical Processing) to query data stored in Azure storage &amp; Azure Data Lake Storage in super-fast manner.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-07T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-11T22:38:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp\" \/>\n<meta name=\"author\" content=\"Microsoft Azure\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Azure\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Azure HDInsight Interactive Query: Ten tools to analyze big data faster\",\"datePublished\":\"2018-08-07T00:00:00+00:00\",\"dateModified\":\"2023-05-11T22:38:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/\"},\"wordCount\":773,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp\",\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/\",\"name\":\"Azure HDInsight Interactive Query: Ten tools to analyze big data faster | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp\",\"datePublished\":\"2018-08-07T00:00:00+00:00\",\"dateModified\":\"2023-05-11T22:38:17+00:00\",\"description\":\"Customers use HDInsight Interactive Query (also called Hive LLAP, or Low Latency Analytical Processing) to query data stored in Azure storage & Azure Data Lake Storage in super-fast manner.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analytics\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Azure HDInsight Interactive Query: Ten tools to analyze big data faster\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure HDInsight Interactive Query: Ten tools to analyze big data faster | Microsoft Azure Blog","description":"Customers use HDInsight Interactive Query (also called Hive LLAP, or Low Latency Analytical Processing) to query data stored in Azure storage & Azure Data Lake Storage in super-fast manner.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/","og_locale":"en_US","og_type":"article","og_title":"Azure HDInsight Interactive Query: Ten tools to analyze big data faster | Microsoft Azure Blog","og_description":"Customers use HDInsight Interactive Query (also called Hive LLAP, or Low Latency Analytical Processing) to query data stored in Azure storage & Azure Data Lake Storage in super-fast manner.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2018-08-07T00:00:00+00:00","article_modified_time":"2023-05-11T22:38:17+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp","type":"","width":"","height":""}],"author":"Microsoft Azure","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Microsoft Azure","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Azure HDInsight Interactive Query: Ten tools to analyze big data faster","datePublished":"2018-08-07T00:00:00+00:00","dateModified":"2023-05-11T22:38:17+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/"},"wordCount":773,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp","articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/","name":"Azure HDInsight Interactive Query: Ten tools to analyze big data faster | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp","datePublished":"2018-08-07T00:00:00+00:00","dateModified":"2023-05-11T22:38:17+00:00","description":"Customers use HDInsight Interactive Query (also called Hive LLAP, or Low Latency Analytical Processing) to query data stored in Azure storage & Azure Data Lake Storage in super-fast manner.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/08\/25c67fe4-5ab0-45e1-831e-b3d7c2348a17.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-hdinsight-interactive-query-ten-tools-to-analyze-big-data-faster\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Analytics","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/"},{"@type":"ListItem","position":3,"name":"Azure HDInsight Interactive Query: Ten tools to analyze big data faster"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/2431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=2431"}],"version-history":[{"count":0,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/2431\/revisions"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=2431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=2431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=2431"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=2431"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=2431"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=2431"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=2431"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=2431"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=2431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}