One key feature of Microsoft’s Big Data Solution is solid integration of Apache Hadoop with the Microsoft Business Intelligence (BI) components. A good example of this is the ability for Excel to connect to the Hive data warehouse framework in the Hadoop
cluster. This section walks you through using Excel via the Hive ODBC driver
Create a Hive ODBC Data Source to use with Excel
11. Click Execute Query.
Cool.. tried it works like a charm