Error FUNCTION NUCLEUS ASCII already exists

Question

Hi,

This is an which I am getting in hive.

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 *

Can anyone help me to solve this?
Thank You  

Answer 1

Hi@akhtar,

This error occurs when hive-shell started before metastore_db service. To avoid this just delete or move your metastore_db and try the below command.

$ mv metastore_db metastore_db.tmp

$ schematool -dbType derby -initSchema

$./bin/hive

Hope this will work.

Thank You

Comments

Perfect!

This solution is working just fine.