hive安装与配置

1.先决条件

要先安装hadoop，安装详细见：http://blog.csdn.net/hwwn2009/article/details/39889465

2.安装hive

1）下载hive，注意hive版本与hadoop版本兼容

wget http://apache.fayea.com/apache-mirror/hive/hive-0.13.1/apache-hive-0.13.1-bin.tar.gz

tar xzf apache-hive-0.13.1-bin.tar.gz 

export HIVE_HOME=/home/hadooper/hadoop/hive-0.13.1
export CLASSPATH=.:$JAVA_HOME/lib:$HADOOP_HOME/lib:$HIVE_HOME/lib:$CLASSPATH
export PATH=$JAVA_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$HIVE_HOME/bin:$PATH

3.安装mysql

由于hive的元数据可能经常更新、修改和读取的操作，因此不宜存储在hadoop的hdfs中，而是RDBMS中。主要有以下两种：

①内嵌的Derby数据库（默认的）：只能允许一个会话连接，只适用于简单的测试。

②MySQL数据库（常用的）：支持多用户会话。

本文将mysql替换derby，具体如下：

1）安装mysql

yum install mysql-server

service mysqld start

3）初始化mysql

[hadooper@MasterServer hive-0.13.1]$/usr/bin/mysql_secure_installation

[...]
Enter current password for root (enter for none):
OK, successfully used password, moving on...
[...]
Set root password? [Y/n] y
New password:
Re-enter new password:
Remove anonymous users? [Y/n] Y
[...]
Disallow root login remotely? [Y/n] N
[...]
Remove test database and access to it [Y/n] Y
[...]
Reload privilege tables now? [Y/n] Y
All done!

3）用root登录mysql，为hive建立mysql账号

[hadooper@MasterServer hive-0.13.1]$ mysql -u root -p
mysql> create user 'hive' identified by '1234';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost' IDENTIFIED BY '1234' WITH GRANT OPTION; 
mysql> flush privileges;
mysql> exit

mysql -u hive -p

5）建立hive专用的数据库

mysql>create database hive;

yum install mysql-connector-java
ln -s /usr/share/java/mysql-connector-java.jar /home/hadooper/hadoop/hive-0.13.1/lib/mysql-connector-java.jar

（转载请注明：http://blog.csdn.net/hwwn2009/article/details/39934089）

将hive的conf目录下的hive-default.xml.template复制一份命名为：hive-site.xml。修改以下内容：

<property>
   <name>javax.jdo.option.ConnectionURL</name>
   <value>jdbc:mysql://localhost: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>hive</value>
</property>
<property>
   <name>javax.jdo.option.ConnectionPassword</name>
   <value>1234</value>
</property>

转载请注明：http://blog.csdn.net/hwwn2009/article/details/39934089