Primary key support
I haven't found a way to make a column as primary key in the document. Any suggestions?
Hi Zipeng, OmniSci does not support primary keys. The workaround would be to delete duplicates on a column after import using the internal rowid column, something like this, where id is your "primary key":
DELETE FROM thetable WHERE rowid NOT IN (SELECT MAX(rowid) FROM thetable GROUP BY id)
Please sign in to leave a comment.