安装HPLSQL 0.3.31

文档信息

日期：2019年4月17日

作者：朱小猛

文档内容：安装HPLSQL 0.3.31

一、下载hplql 0.3.31

下载地址

二、解压文件

[john@hadoop112 ~]$ tar -zxvf /opt/software/hplsql-0.3.31.tar.gz -C /opt/module/

三、为hplsql增加执行权限

[john@hadoop112 hplsql-0.3.31]$ chmod +x hplsql

四、修改hplsql

1、cdh版本

删除hplsql文件中所有的export “HADOOP_CLASSPATH=…”
添加export “HADOOP_CLASSPATH=/opt/cloudera/parcels/CDH/jars/*”

2、hadoop2.7.2版本

#!/bin/bash

export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/share/hadoop/common/*"
export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/share/hadoop/common/lib/*"
export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/share/hadoop/tools/lib/*"
export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/etc/hadoop"

export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/share/hadoop/mapreduce/*"
export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/share/hadoop/mapreduce/lib/*"

export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/share/hadoop/hdfs/*"
export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/share/hadoop/hdfs/lib/*"

export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/share/hadoop/yarn/*"
export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hadoop-2.7.2/share/hadoop/yarn/lib/*"

export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hive/lib/*"
export "HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/opt/module/hive/conf"

export HADOOP_OPTS="$HADOOP_OPTS -Djava.library.path=/opt/module/hadoop-2.7.2/lib/native" 

SCRIPTPATH=${0%/*}

java -cp $SCRIPTPATH:$HADOOP_CLASSPATH:$SCRIPTPATH/hplsql-0.3.31.jar:$SCRIPTPATH/antlr-runtime-4.5.jar $HADOOP_OPTS org.apache.hive.hplsql.Hplsql "$@"

五、安装成功查看版本

[john@hadoop112 hplsql-0.3.31]$ ./hplsql -version

六、设置PATH

[john@hadoop112 hplsql-0.3.31]$ sudo vi /etc/profile
#添加到文件
export PATH=$PATH:/opt/module/hplsql-0.3.31
#生效
[john@hadoop112 hplsql-0.3.31]$ source /etc/profile
#查看版本号，
[john@hadoop112 hplsql-0.3.31]$ hplsql --version

七、修改配置文件hplsql-site.xml

原本：

<property>
	<name>hplsql.conn.init.hive2conn</name>
	<value></value>
</property>

修改后

<property>
  <name>hplsql.conn.init.hive2conn</name>
  <value>
     set mapred.job.queue.name=dev;
     set hive.execution.engine=mr; 
     use sales_db;
  </value>
</property>

八、运行HPL/SQL

[john@hadoop112 hplsql-0.3.31]$ hplsql -e "CURRENT_DATE+1"