Search found 16 matches

by ClevelandSteve
Tue Sep 23, 2014 9:47 pm
Forum: Vertica Data Load
Topic: Copy Rejected Data
Replies: 17
Views: 51965

Re: Copy Rejected Data

I didn’t see any information in this thread on the version being used - or maybe I missed it. If you’re using 7.0 or later you can use REJECTED DATA AS TABLE and avoid this issue. But I imagine you would have tried that already so you must be on 6.1.3? :-) Yes it's version 6.1.3. I opened a ticket ...
by ClevelandSteve
Tue Sep 23, 2014 9:41 pm
Forum: Vertica Data Load
Topic: Copy Rejected Data
Replies: 17
Views: 51965

Re: Copy Rejected Data

Since you are using a shared directory maybe you need to have unique file names for each node? Example: Copy myTable From '/myDirectory/*' On Any Node Rejected Data '/rejects_directory/ node1.rej ' On node_1, '/rejects_directory/ node2.rej ' on node_2 Exceptions '/exceptions_directory/ node1.exp ' ...
by ClevelandSteve
Tue Sep 23, 2014 3:16 pm
Forum: Vertica Data Load
Topic: Copy Rejected Data
Replies: 17
Views: 51965

Re: Copy Rejected Data

I'm still having this problem, and now it happening on a big important load. Has anyone else encountered this since I started the thread?
by ClevelandSteve
Thu Jun 26, 2014 7:40 pm
Forum: Vertica Data Load
Topic: Copy Rejected Data
Replies: 17
Views: 51965

Re: Copy Rejected Data

Yes, it is a shared directory using a common mount point on each node. I do it that way so that I don't need to ssh to each node looking for the reject files. Each of the data files being used by the Copy statement have a unique name to prevent two nodes trying to write the same reject file.
by ClevelandSteve
Thu Jun 26, 2014 4:07 pm
Forum: Vertica Data Load
Topic: Copy Rejected Data
Replies: 17
Views: 51965

Re: Copy Rejected Data

But I need to specify a directory when copying many files using ON ANY NODE. I'm not sure what you are getting at. In an attempt to give Vertica what it wants I have tried specifying a file just to see what happens. When I specify a file it gave me the opposite error, "is not a directory". I'm stuck...
by ClevelandSteve
Mon Jun 23, 2014 1:35 pm
Forum: Vertica Data Load
Topic: Copy Rejected Data
Replies: 17
Views: 51965

Re: Copy Rejected Data

Yes, I am using echo and qecho to watch what the variables are set to as the script runs. I also have the -s option turned on in the call to the vsql command line to see the sql that is being executed. There is nothing out of the ordinary anywhere.
by ClevelandSteve
Fri Jun 20, 2014 5:13 pm
Forum: Vertica Data Load
Topic: Copy Rejected Data
Replies: 17
Views: 51965

Re: Copy Rejected Data

Yes I have read the documentation many times. They are definitely single quotes and not back ticks. Like I said, there is a shell script building the sql syntax for me and the shell loops replacing the target table and source directory. 90% of the time it works fine, but on some of the tables I get ...

Go to advanced search