MapR and Hive Work (ii)--using HiveServer2

HiveServer2 allows multiple concurrent connections to the Hive server on the network.

HiveServer2 is a patch for 0.9.0 basic version of the hive distributed to Apache Hadoop in MAPR. See Installing hive installation for more information. The mapr-Hive Pack includes HiveServer1 and HiveServer2, which you can choose to run.

This page contains the following topics:

Configuring the hive's HiveServer2 enable s SL HiveServer2 Configuration security Authentication HiveServer2 using OpenLDAP LDAP authentication settings authentication using pluggable module Access configuration Custom Authentication Configure user impersonation For example: Hive impersonation Access Hive with Billein Client connection to HiveServer2 JDBC ODBC configuration JDBC Client LDAP authentication with HIVESERVER2 enable SSL on the client to enable S SL for JDBC through the Trust and trust password in the URI string. Pass the trust parameter JVM parameter. Using a CA-signed certificate in the JRE Library uses a self-signed SSL certificate related topic

Configuring the HiveServer2 of the hive

HiveServer2 access to hive data does not change if you do not change the hive version. You do not need to update or otherwise to start using HiveServer2 to convert data. Simply make support, as described later, and run Hiveserver2 instead of the previous hiveserver.

To configure the hive to be used with HiveServer2, include the following configuration properties for the/OPT/MAPR/hive/Hive <VERSION>/CONF/hive-site.xml configuration file.

<p roperty> <NAME> hive.support.concurrency </name > <DESCRIPTION> enable hive for the table lock Manager service </Description > Value <value> true </value > </property > <p roperty> <NAME> hive.zookeeper.quorum </name > The table lock tube in the hive Manager </Description > <DESCRIPTION> breeder Quorum value <value> <zk node1>,<zk node2>,...,<zk noden> </value > </Property > <p roperty> <NAME> hive.zookeeper.client.port </name > value <value> 5181 </ Value > <DESCRIPTION> Zoo Administrator Client port. The MAPR default clientport is 5181. </Description > </property >

For the Hive.zookeeper.quorum property above, replace the <ZK nodex> value with a comma-delimited list of host names or IP addresses of the nodes that run the Zookeeper service.

For user HiveServer1 migrations, you may need to modify applications and scripts to interact with HiveServer2.

If you are running a dedicated instance of HiveServer1 on each client, because HiveServer1 does not support concurrent connections, you can replace those instances with a single instance of HiveServer2.

HiveServer2 uses a different connection URL for the JDBC driver. Using JDBC to communicate with HiveServer1 existing scripts will need to be modified by changing the JDBC driver URL to jdbc: hive://HiveServer2 with s SL enabled

To enable SSL for HIVESERVER2, set the following parameters in the hive's Site.xml file: