mysql权限设置

进入mysql的命令行模式，设置权限

mysql -uroot -p123456

设置权限

mysql>create user 'hive' identified by 'hive';
mysql>GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%' IDENTIFIED BY 'hive' WITH  GRANT OPTION; 
mysql>grant all on *.* to  hive@'master' identified by 'hive';
mysql>grant all on *.* to  hive@'localhost' identified by 'hive';
mysql>grant all on *.* to  hive@'%' identified by 'hive';
mysql>flush privileges;    #刷新
mysql>quit;                   #退出

使用hive用户登录，创建Hive数据库：

mysql -uhive -phive
mysql>create database hive character set utf8;
mysql>flush privileges;

在Hadoop01上安装hive

rz  #上传hive安装包
[root@hdp01 lib]# tar -zxvf apache-hive-1.2.1-bin.tar.gz -C /home/Hadoopl/apps/  #解压到指定文件夹home/Hadoopl/apps
[root@hdp01 lib]# cd /home/Hadoopl/apps/
[root@hdp01 src]# mv apache-hive-1.2.1-bin/ hive-1.2.1 
#重命名为hive1.2.1
[root@hdp01 src]cp mysql-connector-java-5.1.25.jar /home/Hadoopl/apps/hive-1.2.1/lib/

配置环境变量

打开/etc/profile 文件

sudo vi /etc/profile

设置参数

 export HIVE_HOME=/home/Hadoop/apps/hive-1.2.1
export PATH=$PATH:$HIVE_HOME/bin
export CLASSPATH=$CLASSPATH:$HIVE_HOME/bin

source

[root@hdp01 lib]# source /etc/profile

修改hive配置文件

[root@hdp01 lib]# cd /usr/local/src/hive-1.2.1/conf/
[root@hdp01 conf]# cp hive-env.sh.template hive-env.sh
[root@hdp01 conf]# cp hive-default.xml.template hive-site.xml
[root@hdp01 conf]# vi hive-site.xml
<property>
    <name>javax.jdo.option.ConnectionURL</name>		
 <value>jdbc:mysql://192.168.72.140: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>hive</value>
    <description>Username to use against metastore database</description>
  </property>
<property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>hive</value>
    <description>password to use against metastore database</description>
  </property>

再新建tmp

[root@hdp01 conf]# mkdir /usr/local/src/hive-1.2.1/tmp

修改配置文件

[root@hdp01 conf]# vi hive-site.xml
<property>
    <name>hive.querylog.location</name>
    <valuo>/home/hadoop/apps/hive-1.2.1/tmp</value>
</description>Location of Hive run time structured log file</description>
</property>

<property>
    	<name>hive.exec.scratchdir</name>
    	<value>/home/hadoop/apps/hive-1.2.1/tmp</value>
</property>


<property>
    	<name>hive.exec.local.scratchdir</name>
    	<value>/home/hadoop/apps/hive-1.2.1/tmp</value>
</property>

<property>
    <name>hive.downloaded.resources.dir</name>
    <value>/home/hadoop/apps/hive-1.2.1/tmp</value>
    <description>Temporary local directory for added resources in the remote file system.</description>
  </property>

启动Hadoop

[root@hdp01 conf]# start-all.sh

启动hive

[root@hdp01 conf]# hive

hive安装完成!!!
发送到Hadoop02和03上
scp -r /home/hadoop/apps/hive-1.2.1/ hadoop02:/home/hadoop/apps/
scp -r /home/hadoop/apps/hive-1.2.1/ hadoop03:/home/hadoop/apps/
在mysql查看hive中的表
use hive;
show tables;
如果表没有35个则表示不成功
安装Navicat Premium 12l
连接hive

删除hive中的所有表
运行mysql运行文件hive.sql
运行完成有35个表