Use the following instructions to query data from Hive through Microsoft Excel:
On the client machine where you will run Microsoft Excel:
Download the Windows 64-bit Hortonworks ODBC driver from here.
Execute the MSI and follow the instructions to install the ODBC driver.
Set up an ODBC DSN using the following instructions:
For 64-bit ODBC driver: Open the
pane.Navigate to the
tab.Click Hortonworks Hive driver and click .
, select theConfigure the driver using the following instructions:
Under Apache Hadoop hiveserver2 service.
, provide the hostname of the cluster node that runs theUnder
, enter the port of the Hive Server 2 service. By default, the Hive Server port is set to10001
.
Choose
for authentication, and enter 'Hadoop' as the user name.Click
.
You can now use this ODBC DSN from Excel, to see tables in Hive and pull data from these tables.