1 /etc/profile
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export JAVA_HOME=/home/jka07@int.hrs.com/software/jdk1.8.0_121
PATH=$PATH:$JAVA_HOME/bin
export SCALA_HOME=/usr/share/scala
export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar
export PATH
export HADOOP_HOME=/home/jka07@int.hrs.com/software/hadoop-2.7.0
#export HIVE_HOME=/home/jka07@int.hrs.com/software/hive-0.10.0
export HIVE_HOME=/home/jka07@int.hrs.com/software/apache-hive-2.1.1
export HADOOP_CONF_DIR=${HADOOP_HOME}/etc/hadoop
export PATH=$PATH:$HBASE_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$HIVE_HOME/bin
alias tohd='cd /home/jka07@int.hrs.com/software/hadoop-2.7.0'
#alias tohv='cd /home/jka07@int.hrs.com/software/hive-0.10.0'
alias tohv='cd /home/jka07@int.hrs.com/software/apache-hive-2.1.1'
alias tohb='cd /home/jka07@int.hrs.com/software/hbase-1.2.4'
alias tosp='cd /home/jka07@int.hrs.com/software/spark-2.1.0-bin-hadoop2.7'
alias tohdlog='cd /home/jka07@int.hrs.com/software/hadoop-2.7.0/logs'
2)
cp hive-default.xml.template hive-default.xml
cp hive-default.xml.template hive-site.xml
cp hive-exec-log4j2.properties.template hive-exec-log4j.properties
cp hive-log4j2.properties.template hive-log4j.properties
下面为hive-site.xml: (同时,要修改 hive-site.xml 中所有包含 ${system:java.io.tmpdir} => /home/jka07@int.hrs.com/hive/tmp)
<configuration>
<property>
<name>hive.metastore.schema.verification</name>
<value>false</value>
</property>
<property>
<name>hive.metastore.local</name>
<value>true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:MySQL://127.0.0.1:3306/hive?characterEncoding=UTF-8</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>Hrs12345</value>
</property>
<property>
<name>hive.exec.scratchdir</name>
<value>/tmp/hive</value> // in hadoop fs
</property>
<property>
<name>hive.exec.local.scratchdir</name>
<value>/home/jka07@int.hrs.com/hive/tmp</value> //in linux fs
</property>
<property>
<name>hive.downloaded.resources.dir</name>
<value>/home/jka07@int.hrs.com/hive/tmp/${hive.session.id}_resources</value> //in linux
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value> //in hadoop fs
</property>
</configuration>
3) hive-env.sh
export HADOOP_HOME=/home/jka07@int.hrs.com/software/hadoop-2.7.0
export HIVE_HOME=/home/jka07@int.hrs.com/software/apache-hive-2.1.1
export HIVE_CONF_DIR=$HIVE_HOME/conf
export HADOOP_CONF_DIR=${HADOOP_HOME}/etc/hadoop
export HIVE_AUX_JARS_PATH=$HIVE_HOME/lib
export PATH=$PATH:$HBASE_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$HIVE_HOME/bin
$HADOOP_HOME/bin/hadoop fs -mkdir -p /user/hive/warehouse
$HADOOP_HOME/bin/hadoop fs -mkdir -p /tmp/hive/
hadoop fs -chmod 777 /user/hive/warehouse
hadoop fs -chmod 777 /tmp/hive
4)start up
$HADOOP_HOME/bin/hadoop fs -mkdir -p /user/hive/warehouse
$HADOOP_HOME/bin/hadoop fs -mkdir -p /tmp/hive/
hadoop fs -chmod 777 /user/hive/warehouse
hadoop fs -chmod 777 /tmp/hive
>./bin/schematool -initSchema -dbType mysql