一步一步安装hive,mysql安装

--安装hive
下载软件：apache-hive-1.2.1-bin.tar.gz
winscp传到：node1（或任意一个节点）
[hadoop@node1 ~]$ tar -zxvf apache-hive-1.2.1-bin.tar.gz
[hadoop@node1 conf]$ cp hive-default.xml.template hive-site.xml
[hadoop@node1 bin]$ ./hive

[hadoop@node1 conf]$ cp -a hive-default.xml.template hive-site.xml
[hadoop@node1 conf]$ cp -a hive-log4j.properties.template hive-log4j.properties
[hadoop@node1 conf]$ cp -a hive-exec-log4j.properties.template hive-exec-log4j.properties

----------------------------------------------------------------------
--修改配置文件
hive-site.xml
<name>hive.querylog.location</name>
<name>hive.exec.local.scratchdir</name>
<name>hive.downloaded.resources.dir</name>

都改为：
<value>/home/hadoop/tmp</value>

mkdir /home/hadoop/tmp
----------------------------------------------------------------------
--配置环境变量
export JAVA_HOME=/home/hadoop/jdk1.7.0_67
export HADOOP_HOME=/home/hadoop/hadoop-2.7.1
export ZK_HOME=/home/hadoop/zookeeper-3.4.6
export HIVE_HOME=/home/hadoop/apache-hive-1.2.1-bin
export PATH=$PATH:${JAVA_HOME}/bin:${HADOOP_HOME}/bin:${HADOOP_HOME}/sbin:${ZK_HOME}/bin:${HIVE_HOME}/bin


----------------------------------------------------------------------
--初步测试
[hadoop@node1 bin]$ ./hive

Logging initialized using configuration in file:/home/hadoop/apache-hive-1.2.1-bin/conf/hive-log4j.properties
hive>  show databases;
OK
default
Time taken: 3.191 seconds, Fetched: 1 row(s)
hive> show tables;
OK
Time taken: 0.411 seconds
hive> 
----------------------------------------------------------------------
--安装mysql

最好是安装一个关系型数据库（mysql），存放元数据，默认的不稳定，不建议。

[hadoop@node1 ~]$ su - root
[root@node1 ~]# yum install mysql-server
Downloading Packages:
(1/4): mysql-5.1.73-5.el6_6.x86_64.rpm                      
(2/4): mysql-server-5.1.73-5.el6_6.x86_64.rpm               
(3/4): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm                
(4/4): perl-DBI-1.609-4.el6.x86_64.rpm   

--启服务   
[root@node1 ~]# service mysqld start
[root@node1 ~]# netstat -nplt|grep 3306
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      6092/mysqld  
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.12 sec)

mysql> use mysql
mysql> select Host,User,Password from user;
+-----------+------+----------+
| Host      | User | Password |
+-----------+------+----------+
| localhost | root |          |
| node1     | root |          |
| 127.0.0.1 | root |          |
| localhost |      |          |
| node1     |      |          |
+-----------+------+----------+
5 rows in set (0.00 sec)

----------------------------------------------------------------------
--配置mysql
[hadoop@node1 tmp]$ sudo service mysqld start
[root@node1 ~]# mysqladmin -uroot password root
[root@node1 ~]# mysql -uroot -proot
Welcome to the MySQL monitor.  Commands end with ; or \g.

grant all on *.* to root@'%' identified by '123456';
grant all on *.* to root@'node1' identified by '123456'; 
grant all on *.* to root@'localhost' identified by '123456';

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION
mysql> use mysql
mysql> select Host,User,Password from user;
+-----------+------+-------------------------------------------+
| Host      | User | Password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| node1     | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| 127.0.0.1 | root |                                           |
| localhost |      |                                           |
| node1     |      |                                           |
| %         | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+-----------+------+-------------------------------------------+


mysql> create database hive;   --给hive保存元数据



----------------------------------------------------------------------
--下载和scp上传插件
[hadoop@node1 bin]$ cp -a ~/mysql-connector-java-5.1.7-bin.jar ~/apache-hive-1.2.1-bin/bin


----------------------------------------------------------------------
--修改hive配置
vi hive-site.xml


----------------------------------------------------------------------



[hadoop@node1 conf]$ vi hive-site.xml 

    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://node1/hive</value>
    --hive是 上面创建的数据库名称，node1后面可以不加3306，默认就是这个端口

    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>

    <name>javax.jdo.option.ConnectionUserName</name>
    <value>root</value>

    <name>javax.jdo.option.ConnectionPassword</name>
    <value>123456</value>




vi hive-site.xml tmp目录

<property>

   <name>hive.querylog.location</name>

   <value>/home/hadoop/dirtmp</value>

   <description>Location of Hive run time structured log file</description>

 </property>

 

 <property>

   <name>hive.exec.local.scratchdir</name>

   <value>/home/hadoop/dirtmp</value>

   <description>Local scratch space for Hive jobs</description>

 </property>

 

 <property>

   <name>hive.downloaded.resources.dir</name>

   <value>/home/hadoop/dirtmp</value>

   <description>Temporary local directory for added resources in the remote file system.</description>

 </property>



 <property>
    <name>hive.server2.logging.operation.log.location</name>
    <value>/home/hadoop/dirtmp</value>
    <description>Top level directory where operation logs are stored if logging functionality is enabled</description>
  </property>