Breaking News: Grepper is joining You.com. Read the official announcement!

Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)

sandy_inspires answered on August 27, 2022 Popularity 3/10 Helpfulness 4/10

answer Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)

Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)

Comment

Solution : 
Go to below directory 
vim $HIVE_HOME/scripts\metastore\upgrade\derby\hive-schema-3.1.0.derby.sql 

this should be at the top
comment the 'NUCLEUS_ASCII' function and 'NUCLEUS_MATCHES' function 
rerun schematool -dbType derby -initSchema, then everything goes well!

Popularity 3/10 Helpfulness 4/10 Language shell

Source: stackoverflow.com

Tags: function shell

Link to this answer
Share Copy Link