CentOS 6.4 hadoop集成Hive

在本节中，我们来学习如何安装Hive。在之前我们已经学习过如何在CentOS上安装Hadoop，详情请参看[url=http://flyingdutchman.iteye.com/admin/blogs/1897181]CentOS 6.4 安装伪分布式Hadoop 1.0.3 [/url],这里不再赘述。

第一步，下载并解压Hive的tar文件：[quote]
[color=blue]# chmod +x hive-0.8.1.tar.gz
# tar xzvf hive-0.8.1.tar.gz
# cp -rf hive-0.8.1 /opt/bigdata[/color]
[/quote]

第二步，配置Hive：[quote]
[color=blue]# cd /opt/bigdata/hive-0.8.1
# ll[/color]
[/quote]
[img]http://dl2.iteye.com/upload/attachment/0086/6865/6281efec-c802-3a5a-b0de-a22b73f3e912.png[/img]
1、先配置Hive_HOME：[quote]
[color=blue]# vi /etc/profile[/color]
[color=red]export HIVE_HOME=/opt/bigdata/hive-0.8.1
export export PATH=%HIVE_HOME%/bin:$PATH[/color]
[color=blue]# source /etc/profile[/color]
[/quote]
2、进入hive/conf，依据hive-env.sh.template，创建并配置hive-env.sh：[quote]
[color=blue]# cp hive-env.sh.template hive-env.sh
# vi hive-env.sh[/color]
[color=red]export HIVE_CONF_DIR=/opt/bigdata/hive-0.8.1/conf //设置hive配置文件的路径
export HADOOP_HOME=/opt/bigdata/hadoop-1.0.3 //配置hadoop的路径[/color]
[/quote]
[img]http://dl2.iteye.com/upload/attachment/0086/6879/71b35223-121d-3d86-8951-9ce7b1682595.png[/img]
3、到了这里，额哦们先来在mysql中给Hive配置一个数据库：[quote]
[color=blue]# mysql -u root -p
Enter password:[/color]
[color=red]mysql> create database hive;
mysql> grant all on hive.* to hive@'%' identified by 'hive'; //创建hive用户，并授权
mysql> flush privileges;[/color]
[/quote]
[img]http://dl2.iteye.com/upload/attachment/0086/6885/24765fd1-1ad6-38c1-ac4b-732104a90436.png[/img]
4、接下来在配置hive-site.xml：[quote]
[color=blue]# cp hive-default.xml.template hive-site.xml
# cp hive-default.xml.template hive-default.xml
# cp hive-log4j.properties.template hive-log4j.properties
# cp hive-exec-log4j.properties.template hive-exec-log4j.properties
# vi hive-site.xml[/color]
[color=red]<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>

<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>org.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>

<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
<description>username to use against metastore database</description>
</property>

<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value></value>
<description>password to use against metastore database</description>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/data/hive/warehouse/</value>
</property>[/color]
[/quote]
5、最后下载mysql-connector-java-version.jar并将之copy到hive-0.8.1/lib目录下。
经过上述5个步骤，hive运行环境已经配置好了，下面我们来启动Hive：[quote]
[color=blue]# cd ../bin
# ./hive [/color]
[/quote]
最终显示如下：
[img]http://dl2.iteye.com/upload/attachment/0086/6890/bc01f16a-41c3-3b10-96ad-461bb1b78416.png[/img]