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

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list