hive安装时遇到schemaTool failed
我运行bin/schematool -initSchema -dbType mysql -verbos
hive-site.xml文件是正确的
代码如下:
<configuration>
<property>
<name>javax.jdo.option.ConnectionURLname> <value>jdbc:mysql://01xdy33:3306/hive3?createDatabaseIfNotExist=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8value>
property>
<property>
<name>javax.jdo.option.ConnectionDriverNamename> <value>com.mysql.jdbc.Drivervalue>
property>
<property> <name>javax.jdo.option.ConnectionUserNamename> <value>rootvalue>
property>
<property>
<name>javax.jdo.option.ConnectionPasswordname> <value>654321value>
property>
<property>
<name>hive.server2.thrift.bind.hostname> <value>01xdy33value>
property>
<property>
<name>hive.metastore.urisname> <value>thrift://01xdy33:9083value>
property>
<property> <name>hive.metastore.event.db.notification.api.authname> <value>falsevalue>
property>
configuration>
但是初始化元数据依旧失败了
你看一下MySQL的版本,如果是8,驱动需要修改一下
<property>
<name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.cj.jdbc.Driver</value>
</property>