centos6安装hive

安装Mysql和与Hive的相关配置

下载地址

MySQL-5.6.30-1.el6.x86_64.rpm-bundle.tar
MySQL-shared-compat-5.6.30-1.el6.x86_64.rpm

安装

MySQL-shared-compat-5.6.30-1.el6.x86_64.rpm
MySQL-server-5.6.30-1.el6.x86_64.rpm(先装yum install perl和删除原来的mysql-libs)
MySQL-client-5.6.30-1.el6.x86_64.rpm
*下载：mysql-connector-java-5.1.38.tar.gz
解压mysql-connector-java-5.1.38.tar.gz将里面的mysql-connector-java-5.1.38-bin.jar复制到apache-hive-1.2.1/lib下*

数据库初始化

/usr/bin/mysql_secure_installation 参考
mysql> show databases;
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘citicbank’ WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> select user,host from mysql.user;

配置

Hive的安装

conf

修改 hive-site.xml

mv hive-default.xml.template hive-site.xml

修改hive-site.xml（删除所有内容，只留一个）
添加如下内容：

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://Master: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>*你的mysql登录密码*</value> 
<description>password to use against metastore database</description>
</property>

修改hive-env.sh

添加入下面的内容：

export HIVE_HOME=/root/cloud/hive1.2
export HIVE_CONF_DIR=/root/cloud/hive1.2/conf

修改hive-config.sh

这个配置文件不在conf下，在bin下

export HADOOP_HOME=写的相关路径
export SPARK_HOME=写的相关路径
export JAVA_HOME=写的相关路径

一些重要的，最要的，重要的内容

hadoop目录下存在老版本jline（将hive里的新版本cp到hadoop下的相关目录）：
path/hadoop-2.6.0/share/hadoop/yarn/lib：
hive/apache-hive-1.2.1/lib# cp jline-2.12.jar /usr/local/hadoop/hadoop-2.6.0/share/hadoop/yarn/lib/