Choose the driver version that matches your Cloudera Runtime or CDH (Cloudera Distribution including Apache Hadoop) version. Choose Operating System: Windows: Available as an .msi installer (32-bit or 64-bit). Linux: Available as .rpm or .deb packages. macOS: Available as a .dmg file.
Specify the Hive database you wish to access (default is default ).
Use the 64-bit version if your BI tool (like Power BI) is 64-bit. 3. Create a New DSN (Data Source Name) Go to the System DSN tab and click Add . Select Cloudera ODBC Driver for Apache Hive from the list. Click Finish to open the configuration window. 4. Enter Connection Details
If the driver doesn't appear in the ODBC Administrator, try restarting your computer after installation.
Ensure you are using the 64-bit driver for 64-bit applications. A 32-bit Excel version cannot use a 64-bit ODBC DSN.
Give it a recognizable name (e.g., Hive_Production ). Host: Enter the IP address or hostname of your Hive server. Port: The default port is usually 10000 .
Once you have downloaded the .msi file, follow these steps to set up your connection: 1. Run the Installer
The Cloudera Hive ODBC Driver is the industry-standard connector for linking Windows, Linux, and macOS applications to Hadoop data clusters. This driver enables seamless integration between Business Intelligence (BI) tools like Tableau, Excel, or Power BI and the Apache Hive data warehouse.
Choose the driver version that matches your Cloudera Runtime or CDH (Cloudera Distribution including Apache Hadoop) version. Choose Operating System: Windows: Available as an .msi installer (32-bit or 64-bit). Linux: Available as .rpm or .deb packages. macOS: Available as a .dmg file.
Specify the Hive database you wish to access (default is default ).
Use the 64-bit version if your BI tool (like Power BI) is 64-bit. 3. Create a New DSN (Data Source Name) Go to the System DSN tab and click Add . Select Cloudera ODBC Driver for Apache Hive from the list. Click Finish to open the configuration window. 4. Enter Connection Details download cloudera hive odbc driver
If the driver doesn't appear in the ODBC Administrator, try restarting your computer after installation.
Ensure you are using the 64-bit driver for 64-bit applications. A 32-bit Excel version cannot use a 64-bit ODBC DSN. Choose the driver version that matches your Cloudera
Give it a recognizable name (e.g., Hive_Production ). Host: Enter the IP address or hostname of your Hive server. Port: The default port is usually 10000 .
Once you have downloaded the .msi file, follow these steps to set up your connection: 1. Run the Installer macOS: Available as a
The Cloudera Hive ODBC Driver is the industry-standard connector for linking Windows, Linux, and macOS applications to Hadoop data clusters. This driver enables seamless integration between Business Intelligence (BI) tools like Tableau, Excel, or Power BI and the Apache Hive data warehouse.