Hive 问题汇总
来源:互联网 发布:江淮地区 知乎 编辑:程序博客网 时间:2024/06/05 10:31
1 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT…
当启动Hive
的时候报错:
Caused by: javax.jdo.JDOException: Couldnt obtain a new sequence (unique id) : Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.NestedThrowables:java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
这个问题是由于hive
的元数据存储MySQL
配置不当引起的,可以这样解决:
mysql> set global binlog_format='MIXED';
2 For direct MetaStore DB connections, we don’t support retries at the client level.
当在Hive
中创建表的时候报错:
create table years (year string, event string) row format delimited fields terminated by '\t';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;
3 HiveConf of name hive.metastore.local does not exist
当执行Hive
客户端时候出现如下错误:
WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist
这是由于在0.10 0.11或者之后的HIVE版本 hive.metastore.local 属性不再使用。将该参数从hive-site.xml
删除即可。
4 Permission denied: user=anonymous, access=EXECUTE, inode=”/tmp”
在启动Hive
报如下错误:
(Permission denied: user=anonymous, access=EXECUTE, inode="/tmp":hadoop:supergroup:drwx------
这是由于Hive
没有hdfs:/tmp
目录的权限,赋权限即可:
hadoop dfs -chmod -R 777 /tmp
5 未完待续
2 0
- hive问题汇总
- Hive 问题汇总
- hive问题汇总
- Hive 问题汇总
- Hive 问题汇总
- 安装hive(mysql模式)问题汇总
- HIVE汇总
- hadoop、hbase、hive环境搭建时候遇到的问题汇总
- Hive 在运行时的各种问题汇总
- Hadoop2.6.3+Hive-1.2.1+mysql5.6.15 问题汇总
- hadoop+hive使用中遇到的问题汇总
- Hive通过JDBC方式访问时碰到的问题汇总
- Hive学习笔记汇总
- hive 资料汇总
- hive命令汇总
- Hive常见问题汇总
- hive DDL语法汇总
- hive常见错误汇总
- ORACLE日期时间函数大全
- 二叉搜索树的中序遍历排序
- SQLite Expert professional 修改列名
- 互联网专家资源分享(二)
- 九度OJ 1102:最小面积子矩阵 (DP、缓存、剪枝)
- Hive 问题汇总
- 二分法求解数列中最小的数
- 当div属性有 position: fixed 属性时,flash文件显示在最顶层遮挡div层级解决方法
- java HashMap的简单实现
- C plus plus(1)---算术类型
- SLAM实验及其他视频
- Ubuntu PPPOE拨号
- 【C/C++】类的作用域
- sql char varchar nvarchar区别