The Microsoft deployment of Apache Hadoop for Windows lets you set up a private Hadoop cluster on Azure. One of the included administration/deployment tools is an Interactive Console for JavaScript and Hive. This video introduces the Interactive Hive console. Developer Lengning Liu demonstrates running several Hive commands against your Hadoop cluster.
Hi, my name is Lengning Liu and I'm a Developer on the Microsoft Hadoop Services team. In this video I will introduce you to the Interactive Hive console on Hadoop for Windows Azure. I will show you how to use the Interactive Hive console to perform Hive queries against the cluster.
To enter the console, I start from the home page and click on the Interactive Console tile. There are 2 consoles within this environment. One is the Interactive JavaScript console and using that console is covered in a separate video. In this demo I select Hive.
The Interactive Hive console opens a simple webpage where I can type in arbitrary Hive queries and it will show results back to the gray area once the query has finished from the server side. Let's do a couple quick demos. I type my queries in the edit pane below the gray box.
As you can see in this table I see typical dimensions that you will have for weblog and then I have a couple of measurements that are calculated, such as dwelltime.
Since this query will take some time to run on the server side, let’s go to the remote desktop session we established previously and watch the progress.
For this particular query there will be another stage, a 2nd stage job, created by Hive.
The result is shown to the screen. I see the top 10 device models that have been used to do the query, and the maximum query time associated.
Thank you for viewing this demo, I hope you found it helpful.
Michele [MSFT] edited Revision 11. Comment: moved video up
Michele [MSFT] edited Revision 10. Comment: naming
tonysoper_MSFT edited Revision 8. Comment: deleting spam link