How to understandr primary key in Apache cassandra?

Question

i new for use apache cassandra, i have install cassandra and use cqlsh in my laptop

i used to create table using :

create table userpageview( created_at timestamp, hit int, userid int, variantid int, primary key (created_at, hit, userid, variantid) );

and insert several data into table, but when i tried to select using condition for all column (i mean one by one) it's error

maybe my data modelling wrong, maybe anyone can tell me how create data modelling in cassandra

thx

"when i tried to select using condition for all column (i mean one by one)" -- how do you mean? Can you show an example? — tbsalling, Sep 16 '15 at 10:16
Select * from userpageview where userid=10; it make error :( — ihsansat, Sep 16 '15 at 10:18

score 1 · Answer 1 · edited May 23 '17 at 12:14

1

You need to read about partition keys and clustering keys. Cassandra works much differently than relational databases and the types of queries you can do are much more restricted.

Some information to get you started: here and here.

edited May 23 '17 at 12:14

Community

1
1

answered Sep 16 '15 at 12:39

Jim Meyer

9,275
1
24
49

How to understandr primary key in Apache cassandra?

1 Answers1