在初始化matastore的过程中报错
Starting metastore schema initialization to 2.0.0
Initialization script hive-schema-2.0.0.derby.sqlError: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!
*** schemaTool failed ***
删除在hive-site.xml中配置的
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/remote_db?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description></property>
drop掉这个数据库文件