1、下载hplsql安装包:
地址:http://www.hplsql.org/download ,当前测试环境CDH为6.3版本,选择下载0.3.17版的就可以
2、解压到某路径下,参考官网就行
3、配置hplsql-site.xml
主要改下hive2的jdbc连接参数:
<property> <name>hplsql.conn.hive2conn</name> <value>org.apache.hive.jdbc.HiveDriver;jdbc:hive2://test-hadoop-pc04:10000/;auth=KERBEROS;principal=hive/test-hadoop-pc04@ws.com</value> <description>HiveServer2 JDBC connection</description> </property>
4、修改hplsql文件
按照官网讲的要将这个文件中有关Hadoop的变量,例如
export "HADOOP_CLASSPATH=..."
均改为CDH环境的,如下:
export "HADOOP_CLASSPATH=/opt/cloudera/parcels/CDH/jars/*"
参数export HADOOP_OPTS="$HADOOP_OPTS -Djava.library.path=/usr/lib/hadoop/lib/native"也要改为CDH的,如下:
export HADOOP_OPTS="$HADOOP_OPTS -Djava.library.path=/data/cloudera/parcels/CDH/lib/hadoop/lib/native"
启动参数改为:
java -cp $SCRIPTPATH:$HADOOP_CLASSPATH:$SCRIPTPATH/hplsql-0.3.17.jar:$SCRIPTPATH/antlr-runtime-4.5.jar $HADOOP_OPTS -Djava.security.krb5.conf="/etc/krb5.conf" -Djava.security.krb5.realm="ws.com" -Djavax.security.auth.useSubjectCredsOnly="false" -Djava.security.auth.login.config="jaas.conf" -Djava.security.krb5.kdc="test-hadoop-pc01" org.apache.hive.hplsql.Hplsql "$@"
5、编辑jaas.conf,添加内容如下:
JaasSample {
com.sun.security.auth.module.Krb5LoginModule required
useKeyTab=true
keyTab="/home/xx/xx.keytab"
debug=true
principal="hive/_HOST@ws.com"
storeKey=true;
};
jaas.conf具体配置方法以及使用的java启动参数可参考官网:https://docs.oracle.com/javase/1.5.0/docs/guide/security/jgss/tutorials/AcnOnly.html#ConfigFile
hive jdbc连接参数可参考:https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBC