【数据挖掘】11-hive安装

hive 安装

1，启动hadoop，启动mysql
  hadoop安装在第3篇博客，http://blog.csdn.net/luolinll1212/article/details/78484518
  mysql安装在第10篇博客，http://blog.csdn.net/luolinll1212/article/details/78491148

2，解压hive

tar -zxvf apache-hive-1.2.1-bin.tar.gz

3，修改配置文件，hive需要修改两个配置文件，分别是hive-site.xml和hive-env.sh

cd apache-hive-1.2.1-bin/conf

vi hive-env.sh
  HADOOP_HOME=/home/hadoop/apps/hadoop-2.6.5

vi hive-site.xml
  <configuration>
   <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>com.mysql.jdbc.Driver</value>
    <description>Driver class name for a JDBC metastore</description>
  </property>

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

  <property>
   <name>javax.jdo.option.ConnectionPassword</name>
   <value>123</value>
   <description>password to use against metastore database</description>
   </property>
  </configuration>

4，将对应的mysql版本连接的jar包拷贝到apache-hive-1.2.1-bin/lib目录
mysql-connector-java-5.1.28.jar

5，启动hive

bin/hive

6，Jline包版本不一致问题，需要拷贝hive的lib目录下中的jline.2.12.jar
替换hadoop的jline包，/home/hadoop/apps/hadoop-2.6.5/etc/hadoop/share/hadoop/yarn/lib/jline-0.9.94.jar