HPLSQL安装

HPLSQL安装

参考文档：HPL/SQL - Get Started

下载地址：Download

HPD中其实是自带hplsql的，但是HPD中的hplsq无法读取外部配置文件，修改配置文件无法生效，只能将修改好的配置文件打入hive-hplsql-3.1.0.3.0.0.0-1634.jar才能生效，而且还会有其他错误，故直接安装HPLSQL即可

1. 将hplsql-0.3.31.tar.gz下载后上传到服务器，解压到/opt目录：

   tar -zxvf ~/softs/hplsql-0.3.31.tar.gz -C ./

2. hplsql脚本添加执行权限：

   chmod u+x hplsql-0.3.31/hplsql

3. 根据hpd安装路径修改hplsq中的环境路径：

   #!/bin/bash
   
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hadoop/*"
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hadoop/lib/*"
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/etc/hadoop/conf"
   
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hadoop-mapreduce/*"
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hadoop-mapreduce/lib/*"
   
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hadoop-hdfs/*"
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hadoop-hdfs/lib/*"
   
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hadoop-yarn/*"
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hadoop-yarn/lib/*"
   
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hive/lib/*"
   export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/3.0.0.0-1634/hive/conf"
   
   export HADOOP_OPTS="$HADOOP_OPTS -Djava.library.path=/usr/hdp/3.0.0.0-1634/hadoop/lib/native"
   ## 上面的所有路径都修改为环境中hpd相关路径
   
   SCRIPTPATH=${0%/*}
   
   java -cp $SCRIPTPATH:$HADOOP_CLASSPATH:$SCRIPTPATH/hplsql-0.3.31.jar:$SCRIPTPATH/antlr-runtime-4.5.jar $HADOOP_OPTS org.apac
   he.hive.hplsql.Hplsql "$@"
   

4. 复制一份配置文件：

   cp hplsql-site.xml hplsql-site.xml.templates

5. 修改配置文件hplsql-site.xml:

   <!-- 主要修改这项，默认的链接为hive2conn，将对应信息修改为hiveserver2Interactiv的连接信息（llap） -->
   <property>
     <name>hplsql.conn.hive2conn</name>
     <value>org.apache.hive.jdbc.HiveDriver;jdbc:hive2://slave1:10500/warehouse;hive;hive</value>
     <description>HiveServer2 JDBC connection</description>
   </property>
   

6. 配置环境变量/etc/profile：

   # HPLSQL_HOME
   export HPLSQL_HOME=/opt/hplsql-0.3.31
   export PATH=$HPLSQL_HOME:$PATH
   

7. 使修改生效：source /etc/profile

8. 执行查看hplsql是否能正常使用：

   [root@master ~]# hplsql --version

   HPL/SQL 0.3.31

9. 执行一条hpl语句看是否能正常连接hive（根据自己hive表情况做对应修改）：

   hplsql -e "select count(1) from test;"

   Starting query

   Query executed successfully (285 ms)

   11648328