Skip to content

Misinterpret data in lines in text_memo_cd.tsv #8

@rkiddy

Description

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

 Query OK, 1426044 rows affected, 36 warnings (1 min 19.48 sec)
 Records: 1426044  Deleted: 0  Skipped: 0  Warnings: 36

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

 +---------+------+--------------------------------------------------+
 | Level   | Code | Message                                          |
 +---------+------+--------------------------------------------------+
 | Warning | 1261 | Row 1170770 doesn't contain data for all columns |
 | Warning | 1261 | Row 1170770 doesn't contain data for all columns |
 | Warning | 1261 | Row 1170770 doesn't contain data for all columns |
 | Warning | 1261 | Row 1170770 doesn't contain data for all columns |
 | Warning | 1261 | Row 1170770 doesn't contain data for all columns |
 | Warning | 1261 | Row 1170770 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283854 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283854 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283854 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283854 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283854 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283854 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283855 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283855 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283855 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283855 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283855 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283855 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283856 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283856 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283856 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283856 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283856 doesn't contain data for all columns |
 | Warning | 1261 | Row 1283856 doesn't contain data for all columns |
 | Warning | 1261 | Row 1315309 doesn't contain data for all columns |
 | Warning | 1261 | Row 1315309 doesn't contain data for all columns |
 | Warning | 1261 | Row 1315309 doesn't contain data for all columns |
 | Warning | 1261 | Row 1315309 doesn't contain data for all columns |
 | Warning | 1261 | Row 1315309 doesn't contain data for all columns |
 | Warning | 1261 | Row 1315309 doesn't contain data for all columns |
 | Warning | 1261 | Row 1319205 doesn't contain data for all columns |
 | Warning | 1261 | Row 1319205 doesn't contain data for all columns |
 | Warning | 1261 | Row 1319205 doesn't contain data for all columns |
 | Warning | 1261 | Row 1319205 doesn't contain data for all columns |
 | Warning | 1261 | Row 1319205 doesn't contain data for all columns |
 | Warning | 1261 | Row 1319205 doesn't contain data for all 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