Hive with Excel

You can download data from Hive-Hadoop and convert it into a PowerPivot model and use it with Power View. Here is how:

1. Download and install the Microsoft ODBC Driver from here.

image

2. Create an ODBC driver for Hive in ODBC.

image

3. From Excel > Data > Get Data > ODBC Driver > Connect to your ODBC driver.

Leave a Reply

Your email address will not be published. Required fields are marked *