CQL3 PreparedStatement - parameterized timestamp

2013-02-06 Thread Mike Sample
Is there a way to re-use a prepared statement with different using timestamp values? BEGIN BATCH USING timestamp INSERT INTO Foo (a,b,c) values (?,?,?) ... APPLY BATCH; Once bound or while binding the prepared statement to specific values, I'd like to set the timestamp value. Putting a question

Re: CQL3 PreparedStatement - parameterized timestamp

2013-02-06 Thread Sylvain Lebresne
Not yet: https://issues.apache.org/jira/browse/CASSANDRA-4450 -- Sylvain On Wed, Feb 6, 2013 at 9:06 AM, Mike Sample mike.sam...@gmail.com wrote: Is there a way to re-use a prepared statement with different using timestamp values? BEGIN BATCH USING timestamp INSERT INTO Foo (a,b,c) values

Re: CQL3 PreparedStatement - parameterized timestamp

2013-02-06 Thread Mike Sample
Thanks Sylvain. I should have scanned Jira first. Glad to see it's on the todo list. On Wed, Feb 6, 2013 at 12:24 AM, Sylvain Lebresne sylv...@datastax.comwrote: Not yet: https://issues.apache.org/jira/browse/CASSANDRA-4450 -- Sylvain On Wed, Feb 6, 2013 at 9:06 AM, Mike Sample

Estimating write throughput with LeveledCompactionStrategy

2013-02-06 Thread Ивaн Cобoлeв
Dear Community, Could anyone please give me a hand with understanding what am I missing while trying to model how LeveledCompactionStrategy works: https://docs.google.com/spreadsheet/ccc?key=0AvNacZ0w52BydDQ3N2ZPSks2OHR1dlFmMVV4d1E2eEE#gid=0 Logs mostly contain something like this: INFO

RE: DataModel Question

2013-02-06 Thread Kanwar Sangha
1) Version is 1.2 2) DynamicComposites : I read somewhere that they are not recommended ? 3) Good point. I need to think about that one. From: Tamar Fraenkel [mailto:ta...@tok-media.com] Sent: 06 February 2013 00:50 To: user@cassandra.apache.org Subject: Re: DataModel Question

Re: Pycassa vs YCSB results.

2013-02-06 Thread Tim Wintle
On Tue, 2013-02-05 at 13:51 -0500, Edward Capriolo wrote: Without stating the obvious, if you are interested in scale, then why pick python?. I would (kind of) agree with this point.. If you absolutely need performance here then python isn't the right choice. If, however, you are currently

RE: unbalanced ring

2013-02-06 Thread Stephen.M.Thompson
Thanks Aaron. I ran the cassandra-shuffle job and did a rebuild and compact on each of the nodes. [root@Config3482VM1 apache-cassandra-1.2.1]# bin/nodetool status Datacenter: 28 == Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns

Re: Why do Datastax docs recommend Java 6?

2013-02-06 Thread Edward Capriolo
Oracle already did this once, It was called jrockit :) http://www.oracle.com/technetwork/middleware/jrockit/overview/index.html Typically oracle acquires they technology and then the bits are merged with the standard JVM. On Wed, Feb 6, 2013 at 2:13 AM, Viktor Jevdokimov

Cassandra 1.1.8 timeouts on clients

2013-02-06 Thread Terry Cumaranatunge
I've gotten timeouts on clients when using Cassandra 1.1.8 in a cluster of 12 nodes, but I don't see the same behavior when using Cassandra 1.0.10. So, to do a controlled experiment, the following was tried: 1. Started with Cassandra 1.0.10. Built a database and ran our test tools against it to

Re: Why do Datastax docs recommend Java 6?

2013-02-06 Thread Wei Zhu
Anyone has first hand experience with Zing JVM which is claimed to be pauseless? How do they charge, per CPU?Thanks-WeiFrom: Edward Capriolo edlinuxg...@gmail.com To: user@cassandra.apache.org Sent: Wednesday, February 6, 2013 7:07 AM Subject: Re: Why do Datastax docs recommend Java 6?

Re: Estimating write throughput with LeveledCompactionStrategy

2013-02-06 Thread Wei Zhu
I have been struggling with the LCS myself. I observed that for the higher level compaction,(from level 4 to 5) it involves much more SSTables than compacting from lower level. One compaction could take an hour or more. By the way, you set the your SSTable size to be 100M? Thanks. -Wei 

Re: Cassandra 1.1.8 timeouts on clients

2013-02-06 Thread Terry Cumaranatunge
I may have found a trigger that is causing these problems. Anyone seen these compaction problems in 1.1? I did run scrub on all my 1.0 data to convert it to 1.1 and fix level-manifest problems before I started running 1.1. 1 node: ERROR [CompactionExecutor:281] 2013-02-06 23:56:16,183

Re: Operation Consideration with Counter Column Families

2013-02-06 Thread aaron morton
Thanks Aaron, so will there only be one value for each counter column per sstable just like regular columns? Yes. For some reason I was under the impression that Cassandra keeps a log of all the increments not the actual value. Not as far as I understand. Cheers -

Re: DataModel Question

2013-02-06 Thread aaron morton
2) DynamicComposites : I read somewhere that they are not recommended ? You probably wont need them. Your current model will not sort message by the time they arrive in a day. The sort order will be based on Message type and the message ID. I'm assuming you want to order messages, so

RE: DataModel Question

2013-02-06 Thread Kanwar Sangha
Thanks Aaron ! My use case is modeled like skype which stores IM + SMS + MMS in one conversation. I need to have the following functionality - *When I go offline and come online again, I need to retrieve all pending messages from all my conversations. *I should be able to

Netflix/Astynax Client for Cassandra

2013-02-06 Thread Cassa L
Hi, Has anyone used Netflix/astynax java client library for Cassandra? I have used Hector before and would like to evaluate astynax. Not sure, how it is accepted in Cassandra community. Any issues with it or advantagest? API looks very clean and simple compare to Hector. Has anyone used it in

Re: Netflix/Astynax Client for Cassandra

2013-02-06 Thread Michael Kjellman
It's a really great library and definitely recommended by me and many who are reading this. And if you are just starting out on 1.2.1 with C* you might also want to evaluate https://github.com/datastax/java-driver and the new binary protocol. Best, michael From: Cassa L

Re: Netflix/Astynax Client for Cassandra

2013-02-06 Thread Gabriel Ciuloaica
Astyanax is not working with Cassandra 1.2.1. Only java-driver is working very well with both Cassandra 1.2 and 1.2.1. Cheers, Gabi On 2/7/13 8:16 AM, Michael Kjellman wrote: It's a really great library and definitely recommended by me and many who are reading this. And if you are just

Re: Netflix/Astynax Client for Cassandra

2013-02-06 Thread Vivek Mishra
Kundera 2.3 is also upgraded for Cassandra 1.2(except CQL binary protocol). -Vivek On Thu, Feb 7, 2013 at 11:50 AM, Gabriel Ciuloaica gciuloa...@gmail.comwrote: Astyanax is not working with Cassandra 1.2.1. Only java-driver is working very well with both Cassandra 1.2 and 1.2.1. Cheers,