?
# hive搭建筆記（ubuntu）
在[hadoop單機環境搭建](http://blog.csdn.net/yfkiss/article/details/7715476)成功后，可以搭建hive。
在hdfs上建目錄：
~~~
$?hadoop?fs?-mkdir?/tmp??
$?hadoop?fs?-mkdir?/user/hive/warehouse??
~~~
添加權限：
~~~
$?hadoop?fs?-chmod?g+w???/tmp??
$?hadoop?fs?-chmod?g+w???/user/hive/warehouse??
~~~
下載解壓hive：
$?wget http://labs.mop.com/apache-mirror/hive/stable/hive-0.8.1.tar.gz .
$ tar -zxvf?hive-0.8.1.tar.gz
設置HADOOP_HOME、HIVE_HOME，并將其添加到~/.bashrc
~~~
export?HADOOP_HOME=/home/zxm/hadoop/hadoop-1.0.3??
export?HIVE_HOME=/home/work/hadoop/hive-0.8.1??
~~~
多用戶支持
(確認已安裝好mysql)
啟動mysql：
~~~
$ mysql -u root -p
mysql>grant all on hive.* to hive@localhost identified by '123456'
~~~
修改hive conf/hive-site.xml，如下：
~~~
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true<alue>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver<alue>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive<alue>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456<alue>
<description>password to use against metastore database</description>
</property>
~~~
下載mysql jdbc包：
wget http://downloads.mysql.com/archives/mysql-connector-java-5.0/mysql-connector-java-5.0.8.tar.gz .
解壓：
`tar -zxvf mysql-connector-java-5.0.8.tar.gz?`
將mysql-connector-java-5.0.8-bin.jar拷貝到hive lib目錄下：
cp mysql-connector-java-5.0.8/mysql-connector-java-5.0.8-bin.jar ?./lib
啟動hive：
`$ cd /home/zxm/hadoop/hive-0.8.1 ;?./bin/hive`
測試：
~~~
$ ./hive
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
Logging initialized using configuration in jar:file:/home/zxm/hadoop/hive-0.8.1/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/work/hive_job_log_work_201207051945_218572007.txt
hive> SHOW TABLES;
OK
Time taken: 7.281 seconds
hive> CREATE TABLE pokes (foo INT, bar STRING);
OK
Time taken: 0.398 seconds
hive> SHOW TABLES; ? ? ? ? ??? ? ? ? ? ? ? ? ??
OK
pokes
Time taken: 0.181 seconds
hive> DESCRIBE pokes;
OK
foo ? ? int
bar ? ? string
Time taken: 0.58 seconds
hive>?
~~~
