KUP-11003: bad data encountered while reading from file string

KUP-11003: bad data encountered while reading from file string
Cause: There was a datatype conversion error while attempting to convert the data in the data file to match the datatype of a column in the external table. The message that follows this one displays the name of the column and the start of the data for the column that could not be converted. The row containing the bad data is rejected and not included as a row in the external table.
Action: If the row containing the bad data should not be filtered out, then modify the definition of the external table so that the datatypes of the columns match the datatypes of the fields in the data file.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:48

KUP-11003：从文件字符串读取时遇到的数据不正确,
.原因：尝试将数据文件中的数据转换为外部表中列的数据类型时，会出现数据类型转换错误。此后面的消息显示列的名称和无法转换的列的数据的开始。包含不良数据的行将被拒绝，不会作为外部表中的一行包含。,
.操作：如果包含不良数据的行不应被过滤出来，则修改外部表的定义，以使列的数据类型与数据文件中字段的数据类型相匹配。,
.

aiaiDBA

13718043309

010-86462881

KUP-11003: bad data encountered while reading from file string

1 个回答

相似问题