Apache Phoenix now supports Zeppelin in Azure HDInsight

The HDInsight team is excited to announce Apache Zeppelin Support for Apache Phoenix Phoenix in Azure HDInsight Apache Phoenix is an open source, massively parallel relational database layer built on HBase. Phoenix allows you to use SQL like queries over HBase. Phoenix uses JDBC drivers underneath to enable users to create, delete, alter SQL tables,…


Simplifying big data analytics architecture

Fast Interactive BI, data security and end user adoption are three critical challenges for successful big data analytics implementations. Without right architecture and tools, many big data and analytics projects fail to catch on with common BI users and enterprise security architects. In this blog we will discuss architectural approaches that will help you architect…


Ten tools to analyze big data faster

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. 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…


How to use DBeaver with Azure #HDInsight

  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. Following is a simple walk through of how to connect Azure HDInsight cluster [Hadoop or Interactive Query] with DBeaver. This article is based on HDInsight 3.6 version. Step1: Install…


HDInsight HBase: Migrating to new HDInsight version

Following are short steps to upgrade your HDInsight HBase cluster with small downtime. Before you migrate please note that there may be incompatibilities between HBase Major/Minor version and below steps only works if there is no version compatibility issues between source and destination cluster. We recommend you to review HBase book before undertaking an upgrade….


What is Azure HDInsight?

Fully managed Big Data Open Source Analytics Service with popular open source frameworks such as Kafka, Storm, R, Spark, Hive, HBase, Phoenix, LLAP, Sqoop, Oozie & Hadoop. 100% Apache Open Source with No lock in. Customers can freely move between on premise, Azure and other clouds as Microsoft does not use any proprietary code with…


HDInsight# Hive Frequently Asked Questions

In this bog post we have captured some common questions and answers related to Hive in Azure HDInsight. How do I check DAG counters for a query? Go to Tez View. Find the DAG and click on Dag counters tab. How do I check that amount of data being read/writted/shuffled by a query? Go to…


HDInsight: How to enable Oozie UI in Ambari

Oozie UI can be accessed by creating an Oozie view in Ambari 1.        Go the cluster Ambari dashboard 2.        Click on Admin -> manage Ambari 3.        On the left click on views 4.        Expand WORKFLOW_MANAGER and press Create Instance 5.        Fill in the details…