Error: FUNCTION 'NUCLEUS_ASCII' already exists.

0 votes

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

Feb 5 in Big Data Hadoop by akhtar
• 1,440 points
26 views

1 answer to this question.

0 votes

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

answered Feb 5 by MD
• 2,750 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Getting error in Hadoop: Output file already exist

When you executed your code earlier, you ...READ MORE

answered Apr 19, 2018 in Big Data Hadoop by Shubham
• 13,370 points
2,047 views
0 votes
1 answer
0 votes
1 answer

Hadoop: error: Cannot lock storage /app/hadoop/tmp/dfs/name. The directory is already locked.

Hi, Check your dfs.name.dir and dfs.data.dir path in hdfs-site.xml. Or ...READ MORE

answered Aug 5, 2019 in Big Data Hadoop by Gitika
• 25,830 points
139 views
0 votes
1 answer

The file exists before processing with hadoop command

Took session and it got resolved. READ MORE

answered Dec 18, 2017 in Big Data Hadoop by Sudhir
• 1,610 points
110 views
0 votes
1 answer

What is Metastore in Hive?

It stores metadata for Hive tables (like their schema ...READ MORE

answered Dec 20, 2018 in Big Data Hadoop by Frankie
• 9,810 points
335 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,840 points
4,137 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,840 points
583 views
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
22,375 views
0 votes
1 answer

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Hi@akhtar, Before setting password in mysql, check the ...READ MORE

answered 4 days ago in Big Data Hadoop by MD
• 2,750 points
14 views