hive sql 常见异常
1、union
Logging initialized using configuration in file:/home/xiaoju/hadoop/apache-hive-1.2.1-bin/conf/hive-log4j.properties
Added [target/publiclog-serde-1.0-SNAPSHOT-jar-with-dependencies.jar] to class path
Added resources: [target/publiclog-serde-1.0-SNAPSHOT-jar-with-dependencies.jar]
FAILED: SemanticException Schema of both sides of union should match.
原因：union 两边的表必须字段必须一致。
2、insert into
17/02/22 20:15:54 WARN conf.HiveConf: HiveConf of name hive.client.unlimit.users does not exist
17/02/22 20:15:54 WARN conf.HiveConf: HiveConf of name hive.hadoop.master does not exist
Logging initialized using configuration in file:/home/xiaoju/hadoop/apache-hive-1.2.1-bin/conf/hive-log4j.properties
Added [target/publiclog-serde-1.0-SNAPSHOT-jar-with-dependencies.jar] to class path
Added resources: [target/publiclog-serde-1.0-SNAPSHOT-jar-with-dependencies.jar]
OK
Time taken: 0.859 seconds
OK
Time taken: 0.291 seconds
FAILED: SemanticException [Error 10044]: Line 3:18 Cannot insert into target table because column number/types are different ''20'': Table insclause-0 has 1 columns, but query has 2 columns.
原因：insert into 后跟的结果集的字段类型和个数与表的字段和个数不一致。
最新文章
- C++中的4个类型转换关键字
- 关于iOS导航控制器隐藏和显示会出现返回键失效,导航栏标题动画异常
- 我的Logo设计简史
- python 中的集合（set) 详解
- 软件工程个人项目-Word frequency program by11061167龚少波
- GCC参数详解
- HDU5137 How Many Maos Does the Guanxi Worth(枚举+dijkstra）
- 在Xcode中使用C++与Objective-C混编
- Javascript J更深层次的理解avascript 基础知识
- 预编译语句(Prepared Statements)介绍，以MySQL为例
- Kubernetes服务之“运行单实例的有状态服务”
- JavaScript数字例子，二分法，冒泡排序
- 史上最全最强Charles截取手机https协议数据包教程（附上利用此技术制作最近微信比较火的头脑王者辅助外挂）！
- c# IPC实现本机进程之间的通信
- 走进netty
- java异常处理try catch finally
- PAT 1124 Raffle for Weibo Followers
- C#移动及改变控件大小
- 网站模仿——LOFTER个人主页
- Windows 10 IoT Core 17083 for Insider 版本更新