重点
重点:启动hive前要先启动zk,然后启动hdfs,然后是初始化 Hive 元数据库,配置文件一定要配对
问题
为什么:都需要cp /opt/dtc/software//flume/conf/flume-env.sh.template /opt/dtc/software/flume/conf/flume-env.sh
hadoop-daemon.sh start zkfc和zkServer.sh
问题1:
Mon Mar 07 23:28:09 PST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Mar 07 23:28:10 PST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
原因:根据mysql的要求,登录mysql服务器验证,这只是个警告,想要解决就需要加东西
解决办法:
找到hive的配置文件/hive/conf/hive-site.xml修改javax.jdo.option.ConnectionURL
在连接结尾加useSSL=false
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://a:3306/metastore?characterEncoding=UTF-8&createDatabaseIfNotExist=true&useSSL=false</value>
</property>
问题2:
[Fatal Error] hive-site.xml:505:90: The reference to entity "createDatabaseIfNotExist" must end with the ';' delimiter.
Exception in thread "main" java.lang.RuntimeException: org.xml.sax.SAXParseException; systemId: file:/opt/dtc/software/hive/conf/hive-site.xml; lineNumber: 505; columnNumber: 90; The reference to entity "createDatabaseIfNotExist" must end with the ';' delimiter.
at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2860)
at org