1.下载hive
wget http://archive.apache.org/dist/hive/hive-1.2.1/apache-hive-1.2.1-bin.tar.gz
2.解压hive
tar -zxvf apache-hive-1.2.1-bin.tar.gz
mv apache-hive-1.2.1-bin.tar.gz app/hive
3.安装mysql(如果有可用的mysql可以跳过)
http://www.cnblogs.com/nzplearnSite/p/5002775.html
密码修改:
grant all on *.* to root@'%' identified by 'gome_search';
update user set password=password('gome_search') where user='root' and host='localhost';
4.配置Hive环境变量
vim /etc/profile
export HIVE_HOME=/home/hadoop/app/hive
export PATH=${HIVE_HOME}/bin:$PATH
source /etc/profile
5.修改hive配置文件
cd ${HIVE_HOME}/conf/
cp hive-env.sh.template hive-env.sh
将以下内容写入到hive-env.sh文件中
export JAVA_HOME=/export/servers/jdk
export HADOOP_HOME=/export/servers/hadoop
export HIVE_HOME=/export/servers/hive
cp hive-log4j.properties.template hive-log4j.properties
将EventCounter修改成org.apache.hadoop.log.metrics.EventCounter
#log4j.appender.EventCounter=org.apache.hadoop.hive.shims.HiveEventCounter
log4j.appender.EventCounter=org.apache.hadoop.log.metrics.EventCounter
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://hadoop08:3306/hivedb?createDatabaseIfNotExist=true</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>你的密码</value>
</property>
</configuration>
将mysql驱动放在hive的lib目录下:
mv mysql-connector-java-5.1.32.jar app/hive/lib/
6.启动调试hive
如果报错Terminal initialization failed; falling back to unsupported 将/hive/lib 里面的jline2.12替换了hadoop 中/hadoop-2.6.1/share/hadoop/yarn/lib/jline-0.09*.jar
本地shell连接:
hive
远程连接hive:
启动方式
启动为前台:bin/hiveserver2
启动为后台: nohup /home/hadoop/app/hive/bin/hiveserver2 > /home/hadoop/log/hiveserver.log 2>&1 &
连接:
hive/bin/beeline 回车,进入beeline的命令界面
beeline> !connect jdbc:hive2://hadoop6:10000