hive 安装

hive下载
http://hive.apache.org/releases.html
解压
gunzip hive-0.8.1.tar.gz
tar -xvf hive-0.8.1.tar
mysql-connector-java-5.1.20.tar.gz下载
http://www.mysql.com/downloads/connector/j/
放到hive-0.8.1/lib下
新建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://localhost:3306/metastore?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>hive</value> 
</property> 

<property>
        <name>datanucleus.autoCreateSchema</name>
        <value>true</value>
</property>

<property>
        <name>datanucleus.autoautoCreateTables</name>
        <value>true</value>
</property>

<property>
        <name>datanucleus.autoCreateColumns</name>
        <value>true</value>
</property>

<property>
        <name>datanucleus.fixedDatastore</name>
        <value>true</value>
</property>

<property>
        <name>hive.metastore.local</name>
        <value>true</value>
        <description>controls whether to connect to remove metastore server or open a new metastore server in Hive Client JVM</description> 
</property> 

</configuration>

这时需要在mysql中给hive建用户。
mysql -uroot -p
create database metastore;
create user 'hive'@'localhost' identified by 'hive';
grant all on metastore.* to hive@'%'  identified by 'hive';
flush privileges;
quit;

mysql -uhive -phive
use metastore;
source /home/hadoop/hive-0.8.1/scripts/metastore/upgrade/mysql/ upgrade-0.8.0-to-0.9.0.mysql.sql

因为不知道为什么?createDatabaseIfNotExist=true
和<name>datanucleus.autoCreateSchema</name>    <value>true</value>
都设置了，hive还不能自动刷脚本，所以这里就手工刷了。
需要高手解释一下。

 vi hive-env.sh

export JAVA_HOME=/home/hadoop/jdk1.6.0_32
export HADOOP_VERSION=1.0.1
export HADOOP_HOME=/home/hadoop/hadoop-1.0.1
export HIVE_HOME=/home/hadoop/hive-0.8.1
#export CLASSPATH=.:$JAVA_HOME/lib:$JRE_HOME/lib:$CLASSPATH
export PATH=$HOME/bin:$HADOOP_HOME/bin:$HIVE_HOME/bin:$JAVA_HOME/bin:/home/hadoop/cmake-2.8.7/bin:$PATH:.
export PATH=$HIVE_HOME/bin:$PATH

编辑hadoop的环境变量
vim hadoop-env.sh
export HADOOP_CLASSPATH=
将其修改为：
export HADOOP_CLASSPATH=$HADOOP_CLASSPATH
（注意：只需在原配置语句上加$HADOOP_CLASSPATH:既可）

hive

hive> show databases;
OK
default
Time taken: 1.63 seconds
hive> create database test;
hive> use test ;
OK
Time taken: 0.019 seconds
hive> create table t1(id int, name string);
OK
Time taken: 0.292 seconds
hive> show tables;
OK
t1
Time taken: 0.064 seconds
hive> desc t1;
OK
id      int
name    string
Time taken: 0.095 seconds
hive> 

hive安装搞定。