Skip to content

Misinterpret data in lines in loan_cd.tsv #3

@rkiddy

Description

@rkiddy
 --------------
 load data local infile '/tmp/loan_cd.tsv' into table loan_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
 --------------

 Query OK, 64848 rows affected, 8 warnings (7.22 sec)
 Records: 64848  Deleted: 0  Skipped: 0  Warnings: 8

 --------------
 show warnings
 --------------

 +---------+------+-------------------------------------------------------------------------------+
 | Level   | Code | Message                                                                       |
 +---------+------+-------------------------------------------------------------------------------+
 | Warning | 1262 | Row 60757 was truncated; it contained more data than there were input columns |
 | Warning | 1262 | Row 61130 was truncated; it contained more data than there were input columns |
 | Warning | 1262 | Row 61131 was truncated; it contained more data than there were input columns |
 | Warning | 1262 | Row 61712 was truncated; it contained more data than there were input columns |
 | Warning | 1262 | Row 62544 was truncated; it contained more data than there were input columns |
 | Warning | 1262 | Row 62548 was truncated; it contained more data than there were input columns |
 | Warning | 1262 | Row 63222 was truncated; it contained more data than there were input columns |
 | Warning | 1262 | Row 64847 was truncated; it contained more data than there were input columns |
 +---------+------+-------------------------------------------------------------------------------+

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions