Cannot Load All Data from File
+1COPY 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?
+2Hi 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
+1Thank you, Adam. It was very helpful. Ashley
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
