1.首先下载apache-hive-0.14.0-bin.tar.gz并解压,为了方便,解压后的文件夹重命名为hive14
2.ls到hive目录下的conf目录,将hive-env.sh.template重命名为hive-env.sh。hive-default.xml.template重命名为hive-site.xml
3.修改hive-env.sh,增加以下三行
export JAVA_HOME=/usr/local/jdk (java安装目录)
export HIVE_HOME=/usr/local/hive14
export HADOOP_HOME=/usr/local/hadoop (hadoop安装目录)
4.修改hive-site.xml
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://X.X.X.X:3306/crxy_job5?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>username</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>password</value>
</property>
<property>
<name>hive.querylog.location</name>
<value>/usr/local/hive14/iotmp</value>
</property>
<property>
<name>hive.exec.local.scratchdir</name>
<value>/usr/local/hive14/iotmp</value>
</property>
<property>
<name>hive.downloaded.resources.dir</name>
<value>/usr/local/hive14/iotmp</value>
</property>
5.将hive14/bin添加到环境变量,启动hive。直接执行hive命令进入hive环境。hive会在指定的mysql数据库创建实例保
存metastore元数据
6.将mysql链接驱动jar包添加到hive/lib下