Primary key support

Follow

zipeng liu

• May 06, 2020 18:37

Hi Experts,

I haven't found a way to make a column as primary key in the document. Any suggestions?

Best, Zipeng

0

• 

  JP Harvey

  • May 06, 2020 18:49

  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)
  

  1

  Comment actions Permalink
• 

  anon23740792

  • May 12, 2020 01:07

  Hi there - we dont support primary keys in omnisci. could you explain a little bit more detail on what you are trying to do that requires a PK, so we can help with alternatives?

  0

  Comment actions Permalink

Please sign in to leave a comment.