Error: Duplicate key name 'PCS_STATS_IDX' (state=42000,code=1061)
以下异常说明mysql已经启动。 应先关掉先前启动的mysql.再执行初始化schema操作。
$service mysql stop;
# $HIVE_HOME/bin/schematool -dbType mysql -initSchema
which: no hbase in (/usr/lib64/qt-3.3/bin:/usr/local/sbin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:/usr/local/src/jdk1.8.0_112/bin:/usr/local/src/hadoop-2.7.3/bin:/usr/local/src/apache-hive-2.1.1-bin/bin:/home/pl62716/spark-2.1.0-bin-hadoop2.6/bin:/home/pl62716/apache-maven-3.3.9/bin://home/pl62716/sbt-launcher-packaging-0.13.13/bin:/root/bin)
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/local/src/apache-hive-2.1.1-bin/lib/hive-jdbc-2.1.1-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/src/apache-hive-2.1.1-bin/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/src/hadoop-2.7.3/share/hadoop/common/lib/slf4j-log4j12-1.7.10.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:mysql://sd-9c1f-2eac:3306/hive?createDatabaseIfNotExist=true
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: hive
Starting metastore schema initialization to 2.1.0
Initialization script hive-schema-2.1.0.mysql.sql
Error: Duplicate key name 'PCS_STATS_IDX' (state=42000,code=1061)
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!
Underlying cause: java.io.IOException : Schema script failed, errorcode 2
Use --verbose for detailed stacktrace.
*** schemaTool failed ***
最新文章
- 内网穿透神器ngrok
- Android驱动开发之Hello实例
- Django web 进阶
- Jar mismatch! Fix your dependencies的问题
- JS实现rgb与16进制颜色相互转换
- Eclipse插件卸载
- web页面缓存技术之Local Storage
- UITextView(文本视图) 学习之初体验
- jQuery版推箱子游戏详解和源码
- Python2和Python3中除法操作/的不同
- InstallShield -6109
- 2018-2019-2 网络对抗技术 20165335 Exp2 后门原理与实践
- 用javascript请求动态页url返回更新
- Kafka版本升级 ( 0.10.0 ->; 0.10.2 )
- 第六周PSP&;进度条
- 洛谷P1772 [ZJOI2006]物流运输 题解
- Linux启动与禁止SSH用户及IP的登录
- python爬虫----基本操作
- PHPexcle案例
- mongodb远程连接
热门文章
- 分立元件封装尺寸及PCB板材工艺与设计实例
- Operating System-Thread(1)What and Why Thread &;&;进程和线程的对比
- HDOJ1059(多重部分和问题)
- 使用SVG + CSS实现动态霓虹灯文字效果
- Python模块-configparse模块
- day18-事务与连接池 4.事务特性
- SpringSecurity01 SpringSecurity环境搭建
- c++中placement new
- 1.2 xss原理分析与剖析(3)
- POJ 3690 Constellations (哈希)