Hi Consider loading the objects into a column without KEY constraint first and then select/delete duplicates using a query and, finally, alter the constraint On 23/12/13 10:17, Vasilis Efthymiou wrote:
I am trying to bulk-load a list of objects into a one-column (primary key) db. The only reason is to remove duplicates. I can't load the list in memory, because the file size is way greater than my memory size.
I use monetdb's COPY-INTO http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto command, but I don't want it to fail when there is a duplicate. I want it to add everything that is not a duplicate and skip the duplicates.
Is there any way to do that with monetdb? Any other way?
Thank you in advance!
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list