Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Hadoop - Native Connection to Hive on HDP 2.3 or 2.4 from Alpine 6.x
Solution:
Native Connection to Hive on HDP 2.3 or 2.4 from Alpine 6.x
Native Connection to Hive on HDP 2.3 or 2.4 from Alpine 6.x
In order to be able to create a native connection from Alpine 6.x to HDP 2.3 or 2.4 Hive (non-Kerberized), go through the following steps:
1. Make sure that the Hive hostname is properly configured in the /etc/hosts file of Alpine server.
2. Add a new data connection - Hadoop Hive (see the attached screenshot).3. Configure the parameters on the first page accordingly (see the attached screenshot).
4. Then configure the additional parameters (see the attached screenshot). Here is the list of parameters for easy copying (make sure to edit the parameter values according to your cluster settings):
hadoop.rpc.protection=authentication
hadoop.security.authentication=simple
mapreduce.jobhistory.address=10.10.3.250:10020
mapreduce.jobhistory.webapp.address=10.10.3.250:19888
yarn.app.mapreduce.am.staging-dir=/tmp
yarn.resourcemanager.admin.address=10.10.3.250:8141
yarn.resourcemanager.resource-tracker.address=10.10.3.250:8025
yarn.resourcemanager.scheduler.address=10.10.3.250:8030
stack.version=2.4.0.0-169
stack.name=hdp
hdp.version=2.4.0.0-169
hive.metastore.client.connect.retry.delay=1
hive.metastore.client.socket.timeout=600
hive.hiveserver2.uris=jdbc:hive2://10.10.3.250:10000/default
Comments
0 comments
Article is closed for comments.