系统:centOS6.5 x86_64
hive版本:apache-hive-1.1.0-cdh5.7.0
JDK版本:1.7
1、下载cdh版本的hive
http://archive.cloudera.com/cdh5/cdh/5/
2、解压、配置环境变量
tar -zxvf apache-hive-1.1.0-cdh5.7.0-bin.tar.gz
vi /etc/profile
export HIVE_HOME=/opt/software/hive
export PATH=${HIVE_HOME}/bin:${PATH}
3 Hive配置修改
hive-env.sh
HADOOP_HOME=/opt/software/hadoop
hive-site.xml 统一元数据管理
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://hadoop001:3306/hive?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>123456</value>
</property>
</configuration>
https://dev.mysql.com/downloads/connector/j/
备注:这里使用mysql作为元数据数据库,必须确认登陆用户的登陆权限,否则会报错。
报错:java.sql.SQLException: Access denied for user 'root'@'hadoop001' (using password: YES)
grant all privileges on hive.* to root@'%' identified by '123456';
SET PASSWORD FOR root@hadoop001 = PASSWORD('123456');
flush privileges;
【来自@若泽大数据】