Search found 16 matches
- Tue Sep 23, 2014 9:47 pm
- Forum: Vertica Data Load
- Topic: Copy Rejected Data
- Replies: 17
- Views: 53632
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 ...
- Tue Sep 23, 2014 9:41 pm
- Forum: Vertica Data Load
- Topic: Copy Rejected Data
- Replies: 17
- Views: 53632
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 ' ...
- Tue Sep 23, 2014 3:16 pm
- Forum: Vertica Data Load
- Topic: Copy Rejected Data
- Replies: 17
- Views: 53632
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?
- Thu Jun 26, 2014 7:40 pm
- Forum: Vertica Data Load
- Topic: Copy Rejected Data
- Replies: 17
- Views: 53632
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.
- Thu Jun 26, 2014 4:07 pm
- Forum: Vertica Data Load
- Topic: Copy Rejected Data
- Replies: 17
- Views: 53632
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...
- Mon Jun 23, 2014 1:35 pm
- Forum: Vertica Data Load
- Topic: Copy Rejected Data
- Replies: 17
- Views: 53632
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.
- Fri Jun 20, 2014 5:13 pm
- Forum: Vertica Data Load
- Topic: Copy Rejected Data
- Replies: 17
- Views: 53632
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 ...