FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column...
来源：互联网 发布：淘宝申请退款次数 编辑：程序博客网 时间：2024/04/28 09:49
Insert table t1
Partition (country,province)
Select * from t2
country 和province根据select返回记录的相对位置进行复制, 分区字段是处于t1的末尾，所以也是t2的末尾赋值到t1
Insert table t1
Partition (country=”american”,province)
Select * from t2
当其中一个设置为静态分区后，那么country就不再 从select返回的取值，而province就会根据字段相对位置获取t2中country的字段，此时会导致返回的t2多出一个列，会如下的错
FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column number/types are different ‘province’: Table insclause-0 has 5 columns, but query has 6 columns.
这种情况就需要将select 字句的*中去掉country
阅读全文
0 0
- FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column...
- Cannot insert the value NULL into column 'StuID', table 'NETRepository.dbo.S
- Sqoop ERROR tool.ImportTool: Imported Failed: There is no column found in the target table
- 错误："SQL Server Error:Table unknow tb_temp At line 1,column 30"之解决
- mycat-错误-ERROR 1064 (HY000): bad insert sql (sharding column:ID not provided,INSERT INTO
- Parse Fatal Error at line 1 column 7: The processing instruction target matching "[xX][mM][lL]" is not allowed.
- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
- Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Paramet
- 1048:Column 'xingzhi' cannot be null [ SQL语句 ] : INSERT INTO `mx_bill` (`status`,`balance`,`xingzhi`
- table xx has no column named 00:;while compiling:INSERT INTO xx（00...)
- XMLSchema validation error occured in: null ,line = 2, column = 1, Message = cvc-elt.1: Cannot find
- Error:Cannot build Artifact :war exploded because it is included into a circular depency
- Error:Cannot build Artifact 'art_training:war exploded' because it is included into a circular depen
- Error:Cannot build Artifact 'ueditor:war exploded' because it is included into a circular depen
- Insert Data into Sorted Table
- Insert Data into Sorted Table
- Cannot insert explicit value for identity column in table 'settings' when IDENTITY_INSERT is set to OFF.
- Cannot insert explicit value for identity column in table 'settings' when IDENTITY_INSERT is set to OFF.
- javax.servlet.ServletException: java.lang.IllegalStateException: No WebEnvironment found: no Environ
- 树莓派3 基于Ubuntu mate 16.04的无线WIFI连接
- unity对象池方案
- Redis系列—持久化存储方案
- Java程序在Linux上运行虚拟内存耗用很大
- FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column...
- Java设计模式：适配器模式（Adapter Pattern）
- C++ Socket（三）
- @Temporal 注解使用
- grep命令--文件过滤分割与合并
- Retrofit使用教程
- MongoDB固定集合的使用（基于Ruby）-记录用户日志行为
- js和 Java des 加解密
- header 头
