How to Import Data to Hadoop on Windows Azure from Windows Azure Marketplace

Before you use the Apache Hadoop on Windows Azure portal to import Windows Azure Marketplace data into Hadoop on Windows Azure, you must know the following information:

User name: the live ID used to sign in to the marketplace.
PassKey
1. Sign in http://datamarket.azure.com with your live ID.
2. Click My Account.
3. Click Account Keys. The GUID number on the Value column is the pass key.
Query
1. Sign in http://datamarket.azure.com with your live ID.
2. Click Data.
3. In the Search the Marketplace textbox, type the keywords.
4. Clck the dataset.
5. Click EXPLORE THIS DATASET.
6. From the BUILD QUERY pane on the right, click DEVELOP.
7. (Optional) From the BUILD QUERY PANE on the right, type the parameters.
8. Click Run Query. The sample data is display on the main pane.
9. From the Build Query pane, click DEVELOP. The URL listed there is the query URL.

To import data from the marketplace

Browse to http://www.hadooponazure.com.
Sign in with your live ID.
Click the Manage Data tile.
Click DataMarket.
Type the DataMarket subscription account information, the Query, and the hive table where you want to import the data.
Click Import data.