Hive 0.13搭建

以你之姓@ 2022-05-24 21:17 196阅读 0赞

# 安装hive包 #

1、从网下下载apache-hive-0.13.1-bin.tar.gz，使用WinSCP等上传工具上传到spark1(/etc/hosts配置，网址域名与其对应的IP地址建立的一个关联“数据库”)的/usr/local目录下。  
2、解压缩hive安装包：tar -zxvf apache-hive-0.13.1-bin.tar.gz。  
3、重命名hive目录：mv apache-hive-0.13.1-bin hive  
4、配置hive相关的环境变量  
vi .bashrc  
export HIVE\_HOME=/usr/local/hive  
export PATH=$HIVE\_HOME/bin  
source .bashrc

# 安装mysql #

1、在spark1上安装mysql。  
2、使用yum安装mysql server。  
yum install -y mysql-server  
service mysqld start  
chkconfig mysqld on  
3、使用yum安装mysql connector  
yum install -y mysql-connector-java  
4、将mysql connector拷贝到hive的lib包中  
cp /usr/share/java/mysql-connector-java-5.1.17.jar /usr/local/hive/lib  
5、在mysql上创建hive元数据库，并对hive进行授权  
create database if not exists hive\_metadata;  
grant all privileges on hive\_metadata.\* to ‘hive’@’%’ identified by ‘hive’;  
grant all privileges on hive\_metadata.\* to ‘hive’@’localhost’ identified by ‘hive’;  
grant all privileges on hive\_metadata.\* to ‘hive’@’spark1’ identified by ‘hive’;  
flush privileges;  
use hive\_metadata;

# 配置hive-site.xml #

mv hive-default.xml.template hive-site.xml
    vi hive-site.xml
    <property>
      <name>javax.jdo.option.ConnectionURL</name>
      <value>jdbc:mysql://spark1:3306/hive_metadata?createDatabaseIfNotExist=true</value>
    </property>
    <property>
      <name>javax.jdo.option.ConnectionDriverName</name>
      <value>com.mysql.jdbc.Driver</value>
    </property>
    <property>
      <name>javax.jdo.option.ConnectionUserName</name>
      <value>hive</value>
    </property>
    <property>
      <name>javax.jdo.option.ConnectionPassword</name>
      <value>hive</value>
    </property>
    <property>
      <name>hive.metastore.warehouse.dir</name>
      <value>/user/hive/warehouse</value>
    </property>

# 配置hive-env.sh和hive-config.sh #

mv hive-env.sh.template hive-env.sh
    
    vi /usr/local/hive/bin/hive-config.sh
    export JAVA_HOME=/usr/java/latest
    export HIVE_HOME=/usr/local/hive
    export HADOOP_HOME=/usr/local/hadoop

# 验证hive是否安装成功 #

直接输入hive命令，可以进入hive命令行  
![这里写图片描述][70]

# hive元数据库 #

![这里写图片描述][70 1]

[70]: /images/20220525/3ee41c8547624ec0ab0e2e44fd4839cc.png
[70 1]: /images/20220525/dbd45930434b44d79a34663f4a6a2cae.png