hive安装的“we don't support retries at the client level"问题
来源:互联网 发布:温柔强大动漫男主 知乎 编辑:程序博客网 时间:2024/06/04 23:22
在配置hive环境时候,遇到如题问题,前提:已经将hive的元数据存在远程的mysql中,现在想要通过运行的hive端删除创建的相关表内容
使用如下命令:
hive>drop table student;结果出现错误:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)
经过一阵度娘后,说是mysql数据库字符集出现问题。
修改mysql的字符集alter database hive character set latin1;但是经过修改后仍然并未解决问题,想起之前再看视频讲解sqoop里面说到mysql-connctor版本可能存在问题,我是用的5.6版本的mysql,拷贝到hive/lib下面的也是
mysql-connector-java-5.6-bin.jar,奇怪, 后来找到一个mysql-connector-java-5.1.34-bin.jar版本的, 将前者替换,嘿,还果然奏效了。
hive> drop table people;Moved: 'hdfs://ns1/user/hive/warehouse/people' to trash at: hdfs://ns1/user/hadoop/.Trash/CurrentOKTime taken: 2.606 seconds恩,具体原因有待探究。
1 0
- hive安装的“we don't support retries at the client level"问题
- hive:For direct MetaStore DB connections, we don't support retries at the client level
- Hive建表报:message:For direct MetaStore DB connections, we don't support retries at the client level
- hive删除表时候失败,For direct MetaStore DB connections, we don't support retries at the client level
- hive 建表报错 For direct MetaStore DB connections, we don't support retries at the client level
- For direct MetaStore DB connections, we don't support retries at the client level解决
- THE QUESTIONS :The Top 25 (what we don't know?)
- Windows Server 错误" We couldn't complete the updates Undoing changes. Don't turn off your computer"的解
- 使用AT&T Network Client时的VPN连接问题
- 在烧写wince时 “Don't support raw image !!OEMVERIFYMEMORY: Invalid image” 的问题!
- use regular expression to delete the lines which we don't need
- what happened when we don't set the namespace attrribute in Struts 2?
- Why don't we have virtual constructors?
- We don't wanna work! STL应用
- Don't in the
- Why don't structs support inheritance?
- C++设计模式7--外观模式--The Client don't want to know
- Scrum is fine, but don't leave the XP at home
- MyBatis学习总结(四)——解决字段名与实体类属性名不相同的冲突
- icon和default图标尺寸整理
- 动态广播和静态广播的区别:
- Django部署到Apache
- RxJava使用详解
- hive安装的“we don't support retries at the client level"问题
- HDOJ 5813 Elegant Construction
- Android创建属于自己的开源库(JitPack.io)
- iOS开发 - 第05篇 - 项目 - 07 - 首页
- NYOJ 915 +-字符串
- JAVA中的final探究
- 排序检索-340 Master-Mind Hints
- asp.net Forms Authentication
- 使用jquery对 某类标签从小到大排序