How to import Azure Marketplace data into Hadoop on Azure

Here is a quick demo on how to import Azure Marketplace data into Hadoop on Azure and how to query it in Hive using the Interactive JavaScript console.

Demo provided by MicrosoftBI team

Be sure to check out how to extract data from Hadoop on Azure using Hive Excel addin http://grow-n-shine.blogspot.com/2012/02/use-excel-hive-add-in-to-access-hive-on.html

Currently, https://www.hadooponazure.com is available by invitation only.

Use Excel Hive Add-in to Access Hive on Windows Azure

Wondering how to connect Excel and Extract data from Hive on Widows Azure. Look no further:

1. Open the HiveODBC port on Windows Azure
2. Install the Excel Hive Add in on your PC
3. Setup the HiveODBC connection using Excel
4. Import data using the HiveAddin into Excel