元数据初始化命令:
schematool -dbType mysql -initSchema
控制台日志(元数据初始化失败)
#bin/hive 进入客户端,查看数据时
Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStor
#元数据初始化错误提示信息
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException : Communications link failure
控制台日志(元数据初始化成功)
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/sweet/software/apache-hive-2.3.6-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/sweet/software/hadoop-2.7.2/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Metastore connection URL: jdbc:mysql://master:3306/metastore?createDatabaseIfNotExist=true
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: root
Starting metastore schema initialization to 2.3.0
Initialization script hive-schema-2.3.0.mysql.sql
Initialization script completed
schemaTool completed
日志信息,会把hive-site.xml配置信息读出来,显示元数据配置相关信息
这里是成功日志,提示schemaTool completed
如果不成功就是失败的,日志中会提示失败的原因,这里失败日志没有保存
附上hive配置信息
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>hive.exec.scratchdir</name>
<value>/home/hadoop/hive/tmp</value>
<description>Hive作业的HDFS根目录位置</description>
</property>
<property>
<name>hive.scratch.dir.permission</name>
<value>733</value>
<description>Hive作业的HDFS根目录创建写权限</description>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/home/hadoop/hive/warehouse</value>
<description>hdfs上hive数据存放位置</description>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.1.212:3306/hive?createDatabaseIfNotExist=true</value>
<description>连接数据库用户名称</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>连接数据库驱动</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>连接数据库用户名称</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
<description>连接数据库用户密码</description>
</property>
<property>
<name>hive.cli.print.header</name>
<value>true</value>
<description>客户端显示当前查询表的头信息</description>
</property>
<property>
<name>hive.cli.print.current.db</name>
<value>true</value>
<description>客户端显示当前数据库名称信息</description>
</property>
<property>
<name>hive.metastore.schema.verification</name>
<value>false</value>
<description></description>
</property>
<property>
<name>hive.metastore.local</name>
<value>false</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://master:9083</value>
<description>主节点元数据服务</description>
</property>
</configuration>