Cannot Load All Data from File

Ashley_1

COPY tableName from /tmp/fileName.txt' I've a large text file with a few millions records. After I loaded into the table, used the above execution, it only loaded a few hundreds records. There's no error message at all. What's the issue?

[Deleted User]

Hi Ashley, Hm... Have you checked for rejected records? Maybe most of the records are failing to parse for some reason. If you're not familiar with Vertica's rejected-records mechanism, see https://my.vertica.com/docs/6.1.x/HTML/index.htm#12330.htm Adam

Ashley_1

Thank you, Adam. It was very helpful. Ashley