Hi Patricia,
We are looking to search based on string comparison (Begins with or exact
matches). The data is structured data with uniquekey, names, addresses etc.
There are around 100+ million records.
Let me know if that helps.
Thnx
From: Patricia Gorla [mailto:patri...@thelastpickle.com]
I may be missing something here, but is there a way in cql to get all unique
row keys in a column family(table) ?
I’ve created a table like this:
CREATE TABLE totp (
artist varchar,
track varchar,
appearance_type varchar,
PRIMARY KEY ((artist),track)
) WITH CLUSTERING ORDER BY (track asc);
an
Hi Rob,
I don't understand how setting those "initial_token" might solve this
issue. Even more since we cannot set them before bootstrapping...
Plus, once those tokens set, we would have to modify them after any new
bootstrap / decommission. Which would also imply to run a rolling restart
for the
Hello Andy
Since C* 2.0.1 it is possible to list all distinct partition keys (not
clustering keys) with: SELECT DISTINCT pk FROM
More info on the feature here:
https://issues.apache.org/jira/browse/CASSANDRA-4536
This query is quite efficient because the key cache is used most of the
tim
Thanks,
worked a treat !
Andy
From: DuyHai Doan
Sent: 15 February 2014 18:51
To: user@cassandra.apache.org
Subject: Re: CQL get unique row keys ?
Hello Andy
Since C* 2.0.1 it is possible to list all distinct partition keys (not
clustering keys) with: SELEC
Okay, so the matter is that when :
- I'm in multi-datacenters configuration (with endpoint_snitch:
PropertyFileSnitch)
- I create a keyspace with strategy SimpleStrategy
- I create a column family in this keyspace and select from it with CONSISTENCY
LOCAL_ONE
I get a rpc_timeout (A developer di
I started off with a single cassandra node on my 2GB digital ocean VPS, but
now I'm planning to upgrade it to 3 node cluster. My single node contain
around 10 GB data spread across 10-12 column families.
What should be the strategy to upgrade that to 3 node cluster, bearing in
mind that my data re