1.hive
1.1 解压
tar -zxf apache-hive-1.2.2-bin.tar.gz -C ..
mv apache-hive-1.2.2-bin/ hive-1.2.2
1.2 修改配置文件 ${HIVE_HOME}/conf/hive-env.sh 48行
HADOOP_HOME=/usr/modules/hadoop-2.9.2
1.3 启动(元数据库使用的是默认的derby数据库,数据就保存在bin目录下的metastore_db文件夹中)
bin/schematool -initSchema -dbType derby
bin/hive
这种启动方式弊端:只能启动一个客户端。
2.hive元数据保存至mysql(mariadb、oracle、sql-server、postgesql)
2.1 mysql数据库安装
sudo yum remove mariadb-libs -y
sudo rpm -ivh mysql-community-common-5.7.32-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-libs-5.7.32-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-client-5.7.32-1.el7.x86_64.rpm
sudo yum install net-tools perl -y
yum install libnuma*
yum install libaio
sudo rpm -ivh mysql-community-server-5.7.32-1.el7.x86_64.rpm
2.2 mysql数据库启动
systemctl start mysqld
2.3 连接数据库
2.3.1 获取临时密码
临时密码保存在/var/log/mysqld.log的第7行
2020-12-22T01:53:06.495310Z 1 [Note] A temporary password is ge nerated for root@localhost: l1%xqBgfpAhL
2.3.2 连接
mysql -u root -pl1%xqBgfpAhL
2.3.3 修改密码
alter user user() identified by "3.1415926Aa?";
FLUSH PRIVILEGES;
远程登录
use mysql;
update user set host = '%' where user = 'root'; exit;
systemctl stop firewalld
2.4 修改hive配置文件
2.4.1 vi hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?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>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>3.1415926Aa?</value>
</property>
</configuration>
2.4.2 上传mysql的驱动包
将“mysql-connector-java-5.1.38.jar”上传至${HIVE_HOME}/lib
2.4.3 格式化数据库(重要操作)
bin/schematool -initSchema -dbType mysql
2.4.4 启动hive
bin/hive