Copy error and log file or debug mode


#1

Hi, I am copying a simple csv file into a table, it simply fails with following error message. Is there a error log or can this command be run in debug mode?

“Loaded: 0 recs, Rejected: 9 recs in 0.009000 secs”


#2

You can see the discarded records and the discard reason in /var/log/messages of your machine (you hav to access it in sudo more)


#3

Hi,

The bad records with message will be printed in mapd_server.ERROR log

eg:

E1211 15:46:33.155334  5090 Importer.cpp:1212] Incorrect Row (expected 2 columns, has 1): [1]
E1211 15:46:33.155742  5090 Importer.cpp:1212] Incorrect Row (expected 2 columns, has 1): [2]
E1211 15:46:33.155776  5090 Importer.cpp:1212] Incorrect Row (expected 2 columns, has 1): [3]
E1211 15:46:33.155814  5090 Importer.cpp:1212] Incorrect Row (expected 2 columns, has 1): [4]
E1211 15:46:33.155899  5090 Importer.cpp:1212] Incorrect Row (expected 2 columns, has 1): [5]

regards