--安装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>
一步一步安装hive,mysql安装
最新推荐文章于 2024-04-15 12:44:51 发布