hi,
look at the collection type support in cql3,
e.g
http://www.datastax.com/documentation/cql/3.0/cql/cql_using/use_list_t.html
we can append or remove using + and - operator
UPDATE users
SET top_places = top_places + [ 'mordor' ] WHERE user_id = 'frodo';
UPDATE users
SET top_places =
Referring to the original post, I think the confusion is what is a row in
this context:
So as far as I understand, the s column is now the *row *key
...
Since I have multiple different p, o, c combinations per s, deleting the whole
*row* identified by s is no option
The s column is in fact
Hi,
is it possible that NetworkTopologyStrategy does not work with Cassandra
2.0 any more?
I just updated my Dev Cluster to 2.0.7 and got UnavailableExceptions for
CQLThrift queries on my already existing column families, even though all
(two) nodes were up. Changing to SimpleStrategy fixed the
Ok, it seems 2.0 now is simply stricter about datacenter names. I simply
had to change the datacenter name to match the name in nodetool ring:
update keyspace MYKS with placement_strategy = 'NetworkTopologyStrategy'
and strategy_options = {datacenter1 : 2};
So the schema was wrong, but 1.2 did
Hi Cassandra Users-
I have a Hadoop job that uses the pattern in Cassandra 2.0.6's
hadoop_cql3_word_count example to load data from HDFS into Cassandra. Having
read about BulkOutputFormat as a way to potentially significantly increase the
write throughput from Hadoop to Cassandra, I am
From my understanding, this would delete all entries with the given s.
Meaning, if I have inserted (sa, p1, o1, c1) and (sa, p2, o2, c2),
executing this:
DELETE FROM table_name WHERE s = sa AND p = p1 AND o = o1 AND c = c1
would delete sa, p1, o1, c1, p2, o2, c2. Is this correct? Or does the
Your understanding is incorrect - the easiest way to see that is to try it.
On Tue, Apr 22, 2014 at 12:00 PM, Sebastian Schmidt isib...@gmail.comwrote:
From my understanding, this would delete all entries with the given s.
Meaning, if I have inserted (sa, p1, o1, c1) and (sa, p2, o2, c2),
It isn’t natively supported but theres some things you can do if need it.
A lot depends on how frequently this list is getting updated. For heavier
workloads I would recommend using a custom CF for this instead of collections.
If extreme inserts you would want to add additional partitioning to
Generally Ive seen it recommended to do a composite CF since it gives you more
flexibility and its easier to debug. You can get some performance improvements
by storing a serialized blob (a lot of data you can represent much smaller this
way by factor of 10 or more if clever) to represent your
Hi all,
I have a data item whose row key is
7573657238353137303937323637363334393636363230
and I have a five node Cassandra cluster with replication factor set to
3. Each replica's token is listed below
TOK: 0
TOK: 34028236692093846346337460743176821145
TOK:
nodetool getendpoints keyspace cf key
On April 22, 2014 at 4:52:08 PM, Han,Meng (meng...@ufl.edu) wrote:
Hi all,
I have a data item whose row key is
7573657238353137303937323637363334393636363230
and I have a five node Cassandra cluster with replication factor set to
3. Each replica's
On Tue, Apr 22, 2014 at 1:55 PM, Russell Bradberry rbradbe...@gmail.comwrote:
nodetool getendpoints keyspace cf key
That will tell OP what nodes *should* have the row... to answer which of
those replicas *actually have* the row, call the JMX
method getSSTablesForKey, on each node returned by
12 matches
Mail list logo