Hi,
Does monetdb support recursive CTE? Does monetdb has a group_concat similar function? if no how to do a similar operation? Does monetdb support execution of sql string? if no how to do dynamic pivot tables?
Thank you.
On Mon, Dec 23, 2013 at 11:21 AM, Martin Kersten Martin.Kersten@cwi.nlwrote:
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