Cassandra didn't order data according to clustering order

2018-07-15 Thread Soheil Pourbafrani
I created table using the command: CREATE TABLE correlated_data ( processing_timestamp bigint, generating_timestamp bigint, data text, PRIMARY KEY (processing_timestamp, generating_timestamp) ) WITH CLUSTERING ORDER BY (generating_timestamp DESC); When I get data using the command

changing ip address of all nodes in cluster

2018-07-15 Thread onmstester onmstester
I need to assign a new ip range to my cluster, What's the procedure? Thanks in advance Sent using Zoho Mail

Re: Cassandra didn't order data according to clustering order

2018-07-15 Thread shalom sagges
The clustering column is ordered per partition key. So if for example I create the following table: create table desc_test ( id text, name text, PRIMARY KEY (id,name) ) WITH CLUSTERING ORDER BY (name DESC ); I insert a few rows: insert into desc_test (id , name ) VALUES ( '

Fwd: changing ip address of all nodes in cluster

2018-07-15 Thread onmstester onmstester
I tested the single node scenario on all nodes iteratively and it worked: https://docs.datastax.com/en/dse/5.1/dse-admin/datastax_enterprise/operations/opsChangeIp.html Sent using Zoho Mail Forwarded message From : onmstester onmstester To : "user" Date : Sun, 15 Jul

Re: Cassandra didn't order data according to clustering order

2018-07-15 Thread Soheil Pourbafrani
To the point, Thanks! On Sun, Jul 15, 2018 at 4:31 PM, shalom sagges wrote: > The clustering column is ordered per partition key. > > So if for example I create the following table: > create table desc_test ( >id text, >name text, >PRIMARY KEY (id,name) > ) WITH CLUSTERIN

Re: Cassandra didn't order data according to clustering order

2018-07-15 Thread Aaron Ploetz
It also helps to think about it with the token values of the partition key in place. Assume I have a table "users_by_dept" keyed like this: PRIMARY KEY ((department),username). Querying that table with the token function on the partition key looks like this: SELECT token(department),department,u

Re: batchstatement

2018-07-15 Thread kurt greaves
What is the primary key for the user_by_ext table? I'd assume it's ext_id, which would imply your update doesn't make sense as you can't change the primary key for a row - which would be the problem you're seeing. On Sat., 14 Jul. 2018, 06:14 Randy Lynn, wrote: > TL/DR: > - only 1 out of 14 stat