I’ve tried a lot of syntax combinations, but always got “column _id unknown” or similar error
The following is a sample query:
CREATE TABLE IF NOT EXISTS “doc”.“test1” (
“col1” STRING,
“col2” INTEGER,
primary key (“_id”)
) ;
As outlined in the documentation:
If no primary keys are defined the id is randomly generated. If no dedicated routing column is defined the _id value is used for distributing the records on the shards.
so you don’t need to set primary key (“_id”) since it is a primary key already if no other primary keys are set already.