一：準(zhǔn)備工作和注意事項(xiàng)
?1.1 ?mysql 必須設(shè)置root用遠(yuǎn)程訪問,數(shù)據(jù)庫字符集要保持一致
?1.2 在Linux準(zhǔn)備Hive安裝包及搭建Hadoop環(huán)境，windows安裝mysql
二：實(shí)驗(yàn)步驟
?2.1 解壓Hive安裝
? tar -zxvf ?hive-0.12.0.tar.gz ? -C?/home/linwentao/desktop/app/
2.2 進(jìn)入hive目錄下的conf編輯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://192.168.16.105:3306/hive</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>
2.2 導(dǎo)入mySQL連接jar包到hive目錄下的lib下
2.3 設(shè)置環(huán)境變量 /etc/profile
#Hive
export HIVE_HOME=/home/linwentao/desktop/app/hive-0.12.0
export PATH=$HIVE_HOME/bin:$PATH
2.4 進(jìn)入hive 創(chuàng)建表
查看windows的mysql的hive是否有很多信息蓖议，有證明成功了讥蟆！
