In this article, you will learn Hive in Microsoft Azure HDInsight.
You need to have an active Azure account and you can try out the steps mentioned in this article. First, you need to have a provisional Azure storage account and HDinsight cluster. Create a HDInsight cluster, using the storage account created earlier. Hadoop compute cluster is also the storage cluster. Hence, create the HDInsight cluster in the same region as the storage account. Select the cluster and click Manage Cluster icon, located at the bottom of the page. This will bring up the Hive Page from where you can issue HiveQL statements as the jobs. Copy and paste the following HiveQL DDL statement in the text area and click submit. This will create a Hive database called suketudemo and a Hive table called incident_by_premise_type.
Microsoft Azure Step by Step Guide