安装完hive后,需要配置好hive-site.xml
配置如下:
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://bigdata113:3306/hivedb?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>root</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>000000</value>
<description>password to use against metastore database</description>
</property>
</configuration>
初始化数据元命令:
在hive的bin目录下执行 :./schematool -dbType mysql -initSchema
初始化成功如下:
[root@bigdata113 bin]# ./schematool -dbType mysql -initSchema
Metastore connection URL: jdbc:mysql://bigdata113:3306/hivedb?createDatabaseIfNotExist=true
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: root
Starting metastore schema initialization to 1.2.0
Initialization script hive-schema-1.2.0.mysql.sql
Initialization script completed
schemaTool completed
注意:1、首次初始化需要把mysql-connect的jar包传到hive的lib目录下
2、首次初始化如果报如下错误则可以查看一下mysql安全策略
检查步骤如下:
首先连接到mysql
mysql -uxxx -pxxx
在mysql中输入:SHOW VARIABLES LIKE 'validate_password%'; 查看mysql安全策略
这里看到密码长度需要8位,
密码强度检查等级为1级,(0/LOW、1/MEDIUM、2/STRONG)
因为我的mysql密码是000000所以这里修改mysql安全呢策略
set global validate_password_policy=LOW;
set global validate_password_length=6;
把权限都给用户,我这里不是这个原因,反正我是把权限都给了
grant all privileges on *.* to 'root'@'bigdata113' identified by 'bigdata113';