CODEWITHSUNDEEP
cassandracassandra-3.0
Damilola
Damilola

Reputation: 241

Cassandra Invalid Query: Some cluster keys are missing

I'm using Cassandra 3.0.

My table was created with this query, but when I try to insert data into the table, I get the error: 'Some cluster keys are missing: created'

Table Structure:

CREATE TABLE db.feed (
    action_object_id int,
    owner_id int,
    created timeuuid,
    action_object text,
    action_object_type int,
    actor text,
    feed_type text,
    target text,
    target_type int,
    verb text,
    PRIMARY KEY (action_object_id, owner_id, created)
) WITH CLUSTERING ORDER BY (owner_id ASC, created ASC)

Upvotes: 1

Views: 1515

Answers (1)

Chaity
Chaity

Reputation: 1388

You must have to provide values for all the primary keys. action_object_id, owner_id, created must have to be mentioned in your insert query. Ex: insert into db.feed(action_object_id, owner_id, created, ...) values (?,?,?,...). And you cannot provide NULL values for primary keys. created cannot be null.

Upvotes: 2

Related Questions