Re: Help with data modelling (from MySQL to Cassandra)

2017-03-27 Thread Zoltan Lorincz
e text static, > > element_title text, > > PRIMARY KEY (doc_id, element_id) > > ); > > The static columns are present once per unique doc_id. > > > > On 03/27/2017 01:08 PM, Zoltan Lorincz wrote: > > Hi Alexander, > > thank you for yo

Re: Help with data modelling (from MySQL to Cassandra)

2017-03-27 Thread Zoltan Lorincz
t I > usually run parallel async as Alexander explained. > > On Mon, Mar 27, 2017 at 12:08 PM, Zoltan Lorincz wrote: > >> Hi Alexander, >> >> thank you for your help! I think we found the answer: >> >> CREATE TABLE documents ( >> doc_

Re: Help with data modelling (from MySQL to Cassandra)

2017-03-27 Thread Zoltan Lorincz
cs.datastax.com/en/drivers/java/3.0/com/datastax/driver/core/policies/TokenAwarePolicy.html> > to > avoid unnecessary coordination. > > Cheers, > > > On Mon, Mar 27, 2017 at 4:40 AM Zoltan Lorincz wrote: > >> Querying by (doc_id and element_id ) OR just by (elem

Re: Help with data modelling (from MySQL to Cassandra)

2017-03-26 Thread Zoltan Lorincz
you need to query and/or update element just by > element_id but I don't know your queries up front. > > On Sun, Mar 26, 2017 at 10:16 PM, Zoltan Lorincz wrote: > >> Dear cassandra users, >> >> We have the following structure in MySql: >> >> docum

Help with data modelling (from MySQL to Cassandra)

2017-03-26 Thread Zoltan Lorincz
Dear cassandra users, We have the following structure in MySql: documents->[doc_id(primary key), title, description] elements->[element_id(primary key), doc_id(index), title, description] Notation: table name->[column1(key or index), column2, …] We want to transfer the data to Cassandra. Each