I am trying to create a table in Cassandra and my query is the following:

CREATE TABLE IF NOT EXISTS keyspace.user (

uid text,
userjson text,
email text,
username text,
dob text,
number text,

PRIMARY KEY ()

)

Most likely I will be querying this table via uid (unique) to pull userjson, how would I optimize by the PRIMARY KEY? What would I add in the PRIMARY KEY? is it just uid?

I haven’t tried anything yet.