Re: column with TTL of 10 seconds lives very long...

Hi! Just an update, the weekly repair seemed to solve it. The column is no longer there. Still strange... Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Sat, May 25

Re: column with TTL of 10 seconds lives very long...

Yes.. still there. Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Sat, May 25, 2013 at 8:09 PM, Jeremiah Jordan wrote: > If you do that same get again, is

Re: column with TTL of 10 seconds lives very long...

mns for same CF expire as expected after their 10 seconds pass. Thanks, Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, May 23, 2013 at 11:20 PM, Robert Coli w

Re: column with TTL of 10 seconds lives very long...

good point! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, May 23, 2013 at 2:25 PM, wrote: > (Probably will not solve your problem, but worth mentioning): It’s

Re: column with TTL of 10 seconds lives very long...

ll other lock columns expire as expected. Thanks, Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, May 23, 2013 at 1:58 PM, wrote: > Maybe you didn’t set t

Re: column with TTL of 10 seconds lives very long...

Thanks for the response. Running date simultaneously on all nodes (using parallel ssh) shows that they are synced. Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu

column with TTL of 10 seconds lives very long...

, but it is stuck... Any ideas how to delete it? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: High CPU usage during repair

Thank you very much! Due to monetary limitations I will keep the m1.large for now, but try the throughput modification. Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956

Re: High CPU usage during repair

Hi! Thanks for the response. See my answers and questions below. Thanks! Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Sun, Feb 10, 2013 at 10:04 PM, aaron morton

High CPU usage during repair

n, and wanted to ask if I am on the right track: I thought of adding a call to my repair script, before repair starts to do: nodetool setcompactionthroughput 0 and then when repair finishes call nodetool setcompactionthroughput 16 Is this a right solution? Thanks, Tamar *Tamar Fraenkel * Senior

Re: DataModel Question

user columns are different in number of components and maybe type. 3. How do you associate between the SMS or MMS and the user you are chating with. Is it done by a separate CF? Thanks, Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +

Re: Upgrade 1.1.2 -> 1.1.6

Hi! I had the same problem (over counting due to replay of commit log, which ignored drain) after upgrading my cluster from 1.0.9 to 1.0.11. I updated the Cassandra tickets mentioned in this thread. Regards, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok

hector - cassandra versions compatibility

asure(KeyspaceOperationCallback.java:20) at me.prettyprint.cassandra.model.ExecutingKeyspace.doExecute(ExecutingKeyspace.java:101) at me.prettyprint.cassandra.model.thrift.ThriftColumnQuery.execute(ThriftColumnQuery.java:51) *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: I

Re: can't start cqlsh on new Amazon node

problem may be and how to solve it. Thanks! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Nov 8, 2012 at 9:38 AM, Tamar Fraenkel wrote: > Nope... > Same

Re: can't start cqlsh on new Amazon node

check for. Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Nov 8, 2012 at 4:56 AM, Jason Wee wrote: > should it be --cql3 ? > http://www.datastax.

can't start cqlsh on new Amazon node

lib: Connection error: Invalid method name: 'set_cql_version' * *This is the same if I chose cqlversion=3* *Any idea how to solve?* *Thanks,* Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 F

Re: compression

Hi! Thanks Aaron! Today I restarted Cassandra on that node and ran scrub again, now it is fine. I am worried though that if I decide to change another CF to use compression I will have that issue again. Any clue how to avoid it? Thanks. *Tamar Fraenkel * Senior Software Engineer, TOK Media

Re: how to stop hinted handoff

Thanks, that did the trick! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Oct 11, 2012 at 3:42 AM, Roshan wrote: > Hello > > You can delete the h

Re: Hinted Handoff runs every ten minutes

Is there a walk around other than upgrade? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Wed, Oct 24, 2012 at 1:56 PM, Brandon Williams wrote: > On Sun, Oct

Re: compression

ew sstable and 0 empty (tombstoned) rows dropped I don't see any CompressionInfo.db files and compression ratio is still 0.0 on this node only, on other nodes it is almost 0.5... Any idea? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-

Re: Hinted Handoff runs every ten minutes

Hi! I am having the same issue on 1.0.8. Checked number of SSTables, on two nodes I have 1 (on each) and on 1 node I have none. Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2

Performance problems & Unbalanced disk io on my cassandra cluster

so. This of course may be the result of flushing and compactions, but it persists for a long time, even when no compaction is happening. What would you do to further explore or fix the problem? Thank you very much!! * Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1]

Re: READ messages dropped

(out of ~8G). This was done because at that stage I had lots of key caches. I then reduced them to almost 0 on all CF. I guess now I can reduce the memory back to ~2 or ~3 G. Will that help? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel

Re: READ messages dropped

es of OpsCenter column families to disk and or compactions. What are the rollups CFs? why is there so much traffic in them? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956

Re: unbalanced ring

Hi! Apart from being heavy load (the compact), will it have other effects? Also, will cleanup help if I have replication factor = number of nodes? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490

Re: unbalanced ring

that this may cause the minor regular compactions not to run and then I will have to run compact manually. Is that right? Any idea if this means something wrong, and if so, how to solve? Thanks, * Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.co

READ messages dropped

if they are related. I am running Cassandra 1.0.8 on a 3 node cluster on EC2 m1.large instances. Rep factor 3 (Quorum read and write) Does anyone have a clue what I should be looking for, or how to solve it? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@to

Re: cassandra key cache question

Created https://issues.apache.org/jira/browse/CASSANDRA-4742 Any clue regarding the first question in this thread (key cache > number of keys in CF, and not many deletes on that CF)? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com

Re: compression

Hi! The situation didn't resolve, does anyone has a clue? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Sep 27, 2012 at 10:42 AM, Tamar Fraenkel wrote:

Re: cassandra key cache question

doing caching for a non-existing column family? If so, how do I remove those caches? Thanks! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Sep 27, 2012 at 11:45 AM,

cassandra key cache question

Hi! Is it possible that in JMX and cfstats the Key cache size is much bigger than the number of keys in the CF? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: compression

er-hc-271-Data.db') compete: 4868 rows in new sstable and 0 empty (tombstoned) rows dropped Any idea? Thanks!! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Wed, Sep

Re: compression

*Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, Sep 24, 2012 at 8:37 AM, Tamar Fraenkel wrote: > Thanks all, that helps. Will start with one - two CFs and let you k

Re: compression

Thanks all, that helps. Will start with one - two CFs and let you know the effect *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Sun, Sep 23, 2012 at 8:21 PM, Hiller

compression

a good fit for compression? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: Heap size question

n 1.1, but we are not there yet. Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Wed, Aug 22, 2012 at 9:23 AM, Thomas Spengler < thomas.speng...@toptarif.de>

Re: Heap size question

Much appreciated. What you described makes a lot of sense from all my readings :) Thanks! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, Aug 21, 2012 at 6:43 PM

Re: Heap size question

Thanks for you prompt response. Please see follow up questions below Thanks!!! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, Aug 21, 2012 at 12:57 PM, Alain

Heap size question

, should I hard-code it in acassandra-env.sh? Thanks! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: GCInspector info messages in cassandra log

Thank you very much! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Aug 16, 2012 at 12:11 AM, aaron morton wrote: > Is there anything to do before that? like dr

Re: GCInspector info messages in cassandra log

snapshot to one node where I tar them. I just saw that there is an option global_snapshot, is it still supported? Does that mean that if I run it on one node the snapshot will contain data from all cluster? How does it work in restore? Is it better than my current backup system? *Tamar Fraenkel * Senior

Re: GCInspector info messages in cassandra log

how do I change them? change yaml file and restart, or can it be done using jmx without restarting Cassandra? What do I do about the long rows? What value is considered too big. I appreciate your help! Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] t

GCInspector info messages in cassandra log

used; max is 1937768448 *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: increased RF and repair, not working?

Thanks! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, Jul 30, 2012 at 5:30 PM, Tim Wintle wrote: > > On Mon, 2012-07-30 at 15:16 +0300, Tamar Fraenkel

Re: increased RF and repair, not working?

How do you make this calculation? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, Jul 30, 2012 at 3:14 PM, Tim Wintle wrote: > On Mon, 2012-07-30 at 14

Re: increased RF and repair, not working?

ad of twice? Will it affect also performance? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Fri, Jul 27, 2012 at 11:29 PM, Riyad Kalla wrote: > Dave, > &

Re: Questions regarding DataStax AMI

Thanks! This worked fine! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Sat, Jul 28, 2012 at 7:10 AM, Joaquin Casares wrote: > Oh you're right, sorry about t

Re: Questions regarding DataStax AMI

HI! I tried starting a cluster with Cluster started with these options: --clustername --totalnodes 3 --version community --release 1.0.8 But Cassandra's version is 1.1.2 Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +

Re: Questions regarding DataStax AMI

s, > > Joaquin Casares > DataStax > Software Engineer/Support > > > > On Thu, Jul 26, 2012 at 12:44 AM, Tamar Fraenkel wrote: > Hi! > Is there a way to launch EC2 cluster from DataStax latest community AMI that > will run Cassandra 1.0.8 and not 1.1.2? >

Questions regarding DataStax AMI

Hi! Is there a way to launch EC2 cluster from DataStax latest community AMI that will run Cassandra 1.0.8 and not 1.1.2? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: Creating counter columns in cassandra

Consts.COUNTERS, columnName, inc); mutator.execute(); } Regards, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Wed, Jul 25, 2012 at 8:24 PM, Amila Paranawithana wrote

Re: Lots of GCInspector.java on my cluster

Thanks. I thought my problems may be related to the second leap and I ran sudo date -s "`date -u`" on all nodes. Things have improved much in the last 24 hours. *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob

Re: select count(*) returns 10000

Add "limit N" and it will count more than 1. Of course it will be slow when you increase N. *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, Jun 12, 201

Re: RESTful API for GET

Hi! I am using java and jersey. Works fine, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, Jun 12, 2012 at 9:06 AM, James Pirz wrote: > Dear all, > > I

Re: repair

Thanks, one more question. On regular basis, should I run repair for the system keyspace? *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, Jun 4, 2012 at 5:02 PM

Re: repair

Thank you all! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, Jun 4, 2012 at 3:16 PM, R. Verlangen wrote: > The "repair -pr" only repairs the nodes

Re: repair

Thanks. I actually did just that with cron jobs running on different hours. I asked the question because I saw that when one of the logs was running the repair, all nodes logged some repair related entries in /var/log/ cassandra/system.log Thanks again, *Tamar Fraenkel * Senior Software

repair

Hi! I apologize if for this naive question. When I run nodetool repair, is it enough to run on one of the nodes, or do I need to run on each one of them? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54

Re: Using EC2 ephemeral 4disk raid0 cause high iowait trouble

Did you upgrade DataStax AMIs? Did you add a node to an existing ring? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Wed, May 23, 2012 at 2:00 AM, Deno Vichas

Re: unable to nodetool to remote EC2

=localhost -J-DsocksProxyPort=8123 service:jmx:rmi:///jndi/rmi://ec2-*. amazonaws.com:7199/jmxrmi Still getting "channel 2: open failed: connect failed: Connection timed out" Any further idea? Where are you running the script. Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Med

Re: restoring from snapshot - missing data

Thanks. After creating the data model and matching the correct snapshot with the correct new node (same token) all worked fine! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956

Re: RE Ordering counters in Cassandra

e" the pointer to the column to > delete. > > -- > Filippo Diotalevi > > > On Monday, 21 May 2012 at 18:51, Tamar Fraenkel wrote: > >> I also had a similar problem. I have a temporary solution, which is not >> best, but may be of help. >>

Re: RE Ordering counters in Cassandra

will happen less if you do delete old columns. Another option is not to use Cassandra for that purpose, http://redis.io/ is a nice tool Will be happy to hear you comments. Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6

Re: unable to nodetool to remote EC2

though, I can ssh to that vm using ssh -i /c/Users/tamar/.ssh/Amazon/tokey.openssh -D22 ubuntu@my_ec2_cassandra_node_public_ip without being prompted for PW. Any help appreciated *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2

Re: restoring from snapshot - missing data

Thanks. Just figured out yesterday that I switched the snapshots mixing the tokens. Will try again today. And another question. If I am putting the snapshots on a clean ring, I need to first create the data model? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1

restoring from snapshot - missing data

pshot. Help is much appreciated, Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: failed to restore from snapshot

Hi! Sorry, ignore previous mail, my bad. Copied the files to the wrong place. Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Sun, May 20, 2012 at 6:19 PM, Tamar

failed to restore from snapshot

does not seem to have the data. What am I doing wrong? By the way I am running Cassandra 1.0.9 on DataStax AMIs Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: Matthew Dennis's "Cassandra On EC2"

I think the topic is very interesting :) I can't attend the SF event (as I am in Israel) and will appreciate a video! Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 56

Matthew Dennis's "Cassandra On EC2"

Hi! I found the slides of the lecture http://www.slideshare.net/mattdennis/cassandra-on-ec2 I wonder if there is a way to get a video of the lecture. Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

Actually woman ;-) *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, May 15, 2012 at 3:45 PM, Abhijit Chanda wrote: > Thanks so much Guys, specially Tamar, thank

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

+ ++c; Composite end = new Composite(); end.add(prefixEnd); ColumnSliceIterator iterator = new ColumnSliceIterator( query, start, end, false) while (iterator.hasNext()) { ... } Cheers, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image:

Re: Counter CF and TTL

Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, May 14, 2012 at 11:43 PM, aaron morton wrote: > Counter columns do not support a TTL. > &g

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

t one in order (i.e. "aaa"-"aab"). Hope that helps. *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, May 15, 2012 at 7:56 AM, Abhijit Chanda wrote:

Re: counter CF and TTL

Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, May 14, 2012 at 3:20 PM, Viktor Jevdokimov < viktor.jevdoki...@adform.com> wrote: > There’s no TTL o

Counter CF and TTL

see the > TTL as I see for regular CFs. > > So does a counter column have TTL or not? > > I actually don't have an issue of big rows, but I don't need the data > after a two weeks or so, so it seems a shame to clutter the DB with it. > > Thanks, > > *Tamar F

counter CF and TTL

a shame to clutter the DB with it. Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: Failing to delete commitlog at startup/shutdown (Windows)

What I do, is that I have VmWare player with VM running Cassandra localy on my laptop. This is useful when there is no internet connection and works fine for me. *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54

Re: HColumn.getName() appending special characters

Column name is a composite, so you should use MultigetSliceQuery and pass CompositeSerializer. *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, May 3, 2012 at 3:57 AM

Re: Taking a Cluster Wide Snapshot

I think it make's sense and would be happy if you can share the incremental snapshot scripts. Thanks! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, May 1, 2012

Re: Taking a Cluster Wide Snapshot

Thanks for posting the script. I see that the snapshot is always a full one, and if I understand correctly, it replaces the old snapshot on S3. Am I right? *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54

incremental_backups

Hi! I wonder what are the advantages of doing incremental snapshot over non incremental? Are the snapshots smaller is size? Are there any other implications? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob

Re: Cassandra backup queston regarding commitlogs

from setting incremental backup to true? Thanks, Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Sat, Apr 28, 2012 at 4:04 PM, Roshan wrote: > Hi > > Cu

Re: Long type column names in reverse order

27;UTF8Type' and key_validation_class = 'UUIDType'; Then to iterate it I use ColumnSliceIterator. You can also leave out the "reversed=true" and use ColumnSliceIterator to iterate backwards. *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1]

Re: exceptions after upgrading from 1.0.7 to 1.0.9

Thanks. This was the one I followed :) Wonder if there is something more detailed... *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Apr 19, 2012 at 1:06 PM, aaron

Re: Counter column family

My problem was the result of Hector bug, see http://groups.google.com/group/hector-users/browse_thread/thread/8359538ed387564e So please ignore question, Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972

Counter column family

stage. Can execute return before the nodes are really updated? So that if a read is done immediately after the increment it will still read the previous values? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob

Re: exceptions after upgrading from 1.0.7 to 1.0.9

tar.gz? or how to upgrade Amazon EC2 datastax AMI? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, Apr 17, 2012 at 4:56 PM, Watanabe Maki wrote: > You need

Re: cql shell error

Thanks! *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Sun, Apr 15, 2012 at 9:05 PM, Janne Jalkanen wrote: > > The "Resolution" line says "Fixed&q

Re: cql shell error

I apologize for what must be a dumb question, but I see that there are patches etc, what do I need to do in order to have the fix. I am running latest Cassandra 1.0.8. *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob

cql shell error

mp=1333816116526001) When I try to read with cqlsh I get: 'ascii' codec can't encode character u'\u2019' in position 5: ordinal not in range(128) Do I need to save only ascii chars, or can I read it somehow using cql? Thanks *Tamar Fraenkel * Senior Software En

Re: counter column family

Hi! So, if I am using Hector, I need to do: cassandraHostConfigurator.setRetryDownedHosts(false)? How will this affect my application generally? Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490

Re: data size difference between supercolumn and regular column

Do you have a good reference for maintenance scripts for Cassandra ring? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, Apr 3, 2012 at 4:37 AM, aaron morton

Re: Counter question

Thanks! will do. Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Mar 29, 2012 at 12:11 PM, Shimi Kiviti wrote: > You set the consistency with every requ

Re: Counter question

Can this be set on a CF basis. Only this CF needs higher consistency level. Thanks, Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Mar 29, 2012 at 10:44 AM

Counter question

esult> r = query.execute(); return r.get().getValue(); Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 <>

Re: unbalanced ring

Thanks, I will wait and see as data accumulates. Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, Mar 27, 2012 at 9:00 AM, R. Verlangen wrote: > Cassandra

Re: unbalanced ring

Normal 7.23 MB 33.33% 56713727820156410577229101238628035242 10.116.83.10us-east 1c Up Normal 5.02 MB 33.33% 113427455640312821154458202477256070485 Version is 1.0.8. *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel

unbalanced ring

versions: 4687d620-7664-11e1--1bcb936807ff: [10.38.175.131, 10.34.158.33, 10.116.83.10] Any idea what is the cause? I am running similar code on local ring and it is balanced. How can I fix this? Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta

Re: consistency level question

Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, Mar 19, 2012 at 11:49 AM, aaron morton wrote: > Some information on node failures, consistency levels

  1   2   >