Hive (ii): Windows Hive ODBC Installation

For Windows 32-bit and 64-bit systems that have multiple versions of Hive ODBC Connector, the version must be fully matched during installation (that is: 32-bit Connector can only be run on 32-bit systems, and 64-bit Connector can only be 64-bit system operation)

Reference: http://doc.mapr.com/display/MapR/Hive+ODBC+Connector#HiveODBCConnector-HiveODBCConnectoronWindows

Directory:

• Package download
• Installation configuration
• Connection test

Install package Download:

• Different versions of packages: http://archive.mapr.com/tools/MapR-ODBC/MapR_Hive/

Installation configuration:

• Software Installation under Window System is not so troublesome under CentOS, follow the steps of the wizard, the parameters described in the installation process are as follows
• When the installation is complete, open ODBC Data Source Administrator, create a new ODBC connection, and select MapR Hive ODBC Connector
• DNS important parameter configuration such as:

1. 1. IP address of the HOST:HIVESERVER2 server
   2. Port:hive Server listens on the service port, default is 10000, can be found in the Hive-site.xml configuration file
   3. Hive Server Type:hiveserver2 (already explained in the first chapter)
   4. Authentication: If you choose to access by "User name" and enter the user name

• Click "Test", if the connection is successful, then OK

Hive (ii): Windows Hive ODBC Installation