hive初始化mysql数据库失败的原因_初始化hive元数据库失败怎么回事

在配置好hive-site.xml后执行初始化数据：schematool -initSchema -dbType mysql

然而搞程序的都知道不会那么顺利的：报错信息如下
which: no hbase in (/home/jdk/jdk1.8.0_192/bin:/home/hadoop-2.7.7/bin:/home/hadoop-2.7.7/sbin:/home/jdk/jdk1.8.0_192/bin:/home/hadoo
p-2.7.7/bin:/home/hadoop-2.7.7/sbin:/home/jdk/jdk1.8.0_192/bin:/home/hadoop-2.7.7/bin:/home/hadoop-2.7.7/sbin:/usr/local/sbin:/usr/l
ocal/bin:/usr/sbin:/usr/bin:/home/hive/hive-2.3.3/bin:/root/bin:/home/hive/hive-2.3.3/bin:/home/hive/hive-2.1.0/bin)
Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User: APP
Starting metastore schema initialization to 2.1.0
Initialization script hive-schema-2.1.0.mysql.sql
Error: Syntax error: Encountered “” at line 1, column 64. (state=42X01,code=30000)
org.apache.hadoop.hive.metastore.HiveMetaExcept