Reasons for rejected rows in COPY FROM


#1

Is there anyway to get more info from MapD as to why a specific row was rejected when importing via COPY FROM? My file has the correct number of columns in the correct order, and I think the formatting is correct, but they’re all getting rejected. Would like more info from MapD as to what exactly is the problem with the file.


#2

Hi,

The log mapd_server.INFO should contain the details of why the row was rejected and the text of the row.

example output:

E1004 13:10:07.375572   858 Importer.cpp:1238] Incorrect Row (expected 2 columns, has 1): [1.one]
E1004 13:10:07.375636   858 Importer.cpp:1238] Incorrect Row (expected 2 columns, has 1): [2.two]
I1004 13:10:07.471501   858 ParserNode.cpp:2415] Loaded: 1 recs, Rejected: 2 recs in 0.095000 secs

regards