Open the System | Preferences | Network Connections menu.

Select the name of your card (should be something like Auto eth1) and click on Edit….

Move to the IPv4 Settings tab and change the Method from Automatic (DHCP) to Manual.

Click on the Add button to create a new address. Ask your network administrator for details here and fill Address, Netmask, and Gateway.

Click on Apply… and when prompted type the root password cloudera and click on Authenticate. Then click on Close.

Check if the change was successful by opening a Terminal window (Applications | System Tools | Terminal) and issue the ifconfig command, the answer should include the address that you typed in step 4.

From the MicroStrategy Suite virtual machine, test if you can ping the Cloudera VM.

When we first start Hadoop, there are no tables in the database, so we create the samples:

In the Cloudera virtual machine, from the main page in Firefox open Cloudera Manager, click on I Agree in the Information Assurance Policy dialog.

Log in with username admin and password admin.

Look for a line with a service named oozie1, notice that it is stopped. Click on the Actions button and select Start….

Confirm with the Start button in the dialog. A Status window will pop up, wait until the Progress is reported as Finished and close it.

Now click on the Hue button in the bookmarks toolbar.

Sign up with username admin and password admin, you are now in the Hue home page.

Click on the first button in the blue Hue toolbar (tool tip: About Hue) to go to the quick Start Wizard.

Click on the Next button to go to Step 2: Examples tab.

Click on Beeswax (Hive UI) and wait until a message over the toolbar says Examples refreshed.

Now in the Hue toolbar, click on the seventh button from the left (tool tip: Metastore Manager), you will see the default database with two tables: sample_07 and sample_08.

Enable the checkbox of sample_08 and click on the Browse Data button. After a while the Results tab shows a grid with data. So far so good.

We now go back to the Cloudera Manager to start the Impala service. Click on the Cloudera Manager bookmark button.

In the Impala1 row, open the Actions menu and choose Start…, then confirm Start.

Wait until the Progress says Finished, then click on Close in the command details window.

Go back to Hue and click on the fourth button on the toolbar (tool tip: Cloudera Impala (TM) Query UI).

In the Query Editor text area, type select * from sample_08 and click on Execute to see the table content.

Run C:\install\ClouderaHiveODBCSetup_v2_00.exe and click on the Next button until you reach Finish at the end of the setup, accepting every default.

Go to Start | All Programs | Administrative Tools | Data Sources (ODBC) to open the 32-bit ODBC Data Source Administrator (if you're on 64-bit Windows, it's in the SysWOW64 folder).

Click on System DSN and hit the Add… button.

Select Cloudera ODBC Driver for Apache Hive and click on Finish.

Fill the Hive ODBC DSN Configuration with these case-sensitive parameters (change the Host IP according to the address used in step 4 of the Getting ready section):

Click on OK and then on OK again to close the ODBC Data Source Administrator.

Now open the MicroStrategy Desktop application and log in with administrator and the corresponding password.

Right-click on MicroStrategy Analytics Modules and select Create New Project….

Click on the Create project button and name it HADOOP, uncheck Enable Change Journal for this project and click on OK.

When the wizard finishes creating the project click on Select tables from the Warehouse Catalog and hit the button labeled New….

Click on Next and type Cloudera VM in the Name textbox of the Database Instance Definition window.

In this same window, open the Database type combobox and scroll down until you find Generic DBMS. Click on Next.

In Local system ODBC data sources, pick Cloudera VM and type admin in both Database login and Password textboxes.

Click on Next, then on Finish, and then on OK.

When a Warehouse Catalog Browser error appears, click on Yes.

In the Warehouse Catalog Options window, click on Edit… on the right below Cloudera VM.

Select the Advanced tab and enable the radio button labeled Use 2.0 ODBC calls in the ODBC Version group.

Click on OK. Now select the category Catalog | Read Settings in the left tree and enable the first radio button labeled Use standard ODBC calls to obtain the database catalog.

Click on OK to close this window. When the Warehouse Catalog window appears, click on the lightning button (tool tip: Read the Warehouse Catalog) to refresh the list of available tables.

Pick sample_08 and move it to the right of the shopping cart. Then right-click on it and choose Import Prefix.

Click on Save and Close and then on OK twice to close the Project Creation Assistant.

You can now open the project and update the schema.

Go to the Schema Objects | Attributes folder, and create a new Job attribute with these columns:

Go to the Fact folder and create a new Salary fact with salary column. Update the schema.

Go to the Public Objects | Metrics folder and create a new Salary metric based on the Salary fact with Sum as aggregation function.

Go to My Personal Objects | My Reports and create a new report with the Job attribute and the Salary metric: