Hive错误:Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)
来源:互联网 发布:机锋市场淘宝店 编辑:程序博客网 时间:2024/05/17 07:16
错误现象:
-----------------------------------------------------------------------------------------------------------------
doupeihua@doupeihua-2104 ~/software/hive/bin $ schematool -initSchema -dbType derby
SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/home/doupeihua/software/hive/lib/hive-jdbc-2.0.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/doupeihua/software/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/doupeihua/software/spark-1.6.2-bin-hadoop2.6/lib/spark-assembly-1.6.2-hadoop2.6.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/doupeihua/software/hadoop-2.6.4/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User: APP
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 !!
解决办法: (1. 将metastore_db更名为:metastore_db.tmp 2.schematool -initSchema -dbType derby)
------------------------------------------------------------------------------------------------------------------------
beeline beeline.cmd derby.log ext hive hive-config.cmd hive-config.sh hive.cmd hiveserver2 hplsql hplsql.cmd metastore_db metatool schematool
doupeihua@doupeihua-2104 ~/software/hive/bin $ schematool -initSchema -dbType derby
SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/home/doupeihua/software/hive/lib/hive-jdbc-2.0.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/doupeihua/software/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/doupeihua/software/spark-1.6.2-bin-hadoop2.6/lib/spark-assembly-1.6.2-hadoop2.6.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/doupeihua/software/hadoop-2.6.4/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User: APP
Starting metastore schema initialization to 2.0.0
Initialization script hive-schema-2.0.0.derby.sql
Initialization script completed
schemaTool completed
- Hive错误:Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)
- hive schematool 初始化 发生 'NUCLEUS_ASCII' Error
- beeline连接hive server遭遇MapRedTask (state=08S01,code=1)错误
- 解决MySQL 5.6版的Function 'innodb' already exists错误
- magento -- 解决magento错误:ERROR: Base table or view already exists: 1050 Table ... already exists
- table already exists (code 1)
- [hive]InvalidObjectException(message:Role admin already exists.)
- function Error(){[native code}
- django migrate error: table 'xxx' already exists
- Error: For input string: "5000L" (state=,code=0)
- SVN使用补遗-Entry already exists错误
- SVN使用补遗-Entry already exists错误
- VirtualBox报“uuid already exists”错误
- virtualbox UUID already exists 错误解决办法
- “A class named TcxRect already exists”错误
- Github “fatal: remote origin already exists”错误
- hive仓库远程链接:Peer indicated failure: Unsupported mechanism type PLAIN (state=08S01,code=0)
- error: function "atomicAdd(double *, double)" has already been defined错误解决方法
- 点击tr选中每一行前面的checkbox
- Unity常用的函数和遇到的C#的知识整理
- 7.6 I POJ 3185 The Water Bowls
- 解决wordpress页面加载慢的问题
- Leetcode编程练习一:盗马三则
- Hive错误:Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)
- 浅谈android如何利用webView调用网页链接来调用QQ临时会话类似QQ客服
- 了解和使用keystone(二)安装keystone
- 从程序员到CTO的Java技术路线图
- 红色警报(PAT)
- hadoop自带例子wordcount的具体运行步骤
- 使用eclipse建立第一个web项目(java)
- JAVA语言概述
- 被 6 整除