Getting Started With Azure HDInsight: Run A Hive Query - Part Two

Prerequisites

Now let's get started with the following steps:

Run a Hive query

Step 1: Sign in to the online Microsoft Azure Portal.

Step 2: Click the name of the cluster that you want to use to run the Hive job, and then click Dashboard at the top of the blade.



Step 3 

Then cluster webpage opens in a different browser tab and Hadoop asks for user account and password. (The default user name is admin; the password).



Step 4 - 
From the dashboard, click the Hive Editor tab.



After clicking Hive Tab, the following web page opens.



Step 5

In the Query Name field, enter Apple. The query name is the job title. In the query pane, enter the Hive query as shown in the image and Click Submit.



It takes sometime to get the results back after the status shows that the job is completed.


Step 6 -
 Then click the query name on the screen to see the output.



The page also shows the Job Output and the Job Log.