hive启动过程遇到的问题

在初始化matastore的过程中报错

Starting metastore schema initialization to 2.0.0

Initialization script hive-schema-2.0.0.derby.sql
Error: 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掉这个数据库文件