Column Id Unknown

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.