Re: Schema consistently not propagating to a node.

2012-09-13 Thread Sergey Tryuber
Hi Ben, We've seen similar behavior once a time. The cause was unsynchronized time on the nodes. So I can recommend to check that system time is equal over the nodes (especially on that one bad server). On 13 September 2012 05:15, Ben Frank b...@airlust.com wrote: Hey all, I'm setting up

Re: is Not a time-based UUID serious?

2012-09-13 Thread Omid Aladini
On Thu, Sep 13, 2012 at 1:43 AM, Bryan Talbot btal...@aeriagames.com wrote: To answer my own question: yes, the error is fatal. This also means that upgrades to 1.1.x from 1.0.x MUST use 1.0.11 or greater it seems to be successful. My test upgrade from 1.0.9 to 1.1.5 left the cluster in a

Re: Assertions running Cleanup on a 3-node cluster with Cassandra 1.1.4 and LCS

2012-09-13 Thread Omid Aladini
On Wed, Sep 12, 2012 at 9:38 AM, Janne Jalkanen janne.jalka...@ecyrd.com wrote: OK, so what's the worst case here? Data loss? Bad performance? Low performance is for sure a side effect. I can't comment on data loss (and I'm curious about as well) because it depends on how data off of an

secondery indexes TTL - strange issues

2012-09-13 Thread Roland Gude
Hi, we have been running a system on Cassandra 0.7 heavily relying on secondary indexes for columns with TTL. This has been working like a charm, but we are trying hard to move forward with Cassandra and are struggling at that point: When we put our data into a new cluster (any 1.1.x version -

Re: hadoop inserts blow out heap

2012-09-13 Thread Brian Jeltema
I didn't get a response to this, so I'll give it another shot. I tweaked some parameters and cleaned up my schema. My Hadoop/Cassandra job got further, but still dies with an OOM error. This time, the heap dump displays a JMXConfigurableThradPoolExecutor with a retained heap of 7.5G. I presume

Re: Changing bloom filter false positive ratio

2012-09-13 Thread Eric Czech
Thanks Peter. On Thu, Sep 13, 2012 at 12:52 PM, Peter Schuller peter.schul...@infidyne.com wrote: changing it on some of them. Can I just change that value through the cli and restart or are there any concerns I should have before trying to tweak that parameter? You can change it, you don't

Data Model

2012-09-13 Thread Roshni Rajagopal
I want to learn how we can model a mix of static and dynamic columns in a family. Consider a course_students col family which gives a list of students for a coursewith row key- Course IdColumns - Name, Teach_Nm, StudID1, StudID2, StudID3Values - Maths, Prof. Abc, 20,21,25 where 20,21,25 are

Re: Data Model

2012-09-13 Thread Soumya Acharya
I just started learning Cassandra any suggestion where to start with ?? Thanks Soumya On Thu, Sep 13, 2012 at 10:54 AM, Roshni Rajagopal roshni_rajago...@hotmail.com wrote: I want to learn how we can model a mix of static and dynamic columns in a family. Consider a course_students col

Re: Schema consistently not propagating to a node.

2012-09-13 Thread Ben Frank
Hi Sergey, That was exactly it, thank you! -Ben On Thu, Sep 13, 2012 at 12:07 AM, Sergey Tryuber stryu...@gmail.com wrote: Hi Ben, We've seen similar behavior once a time. The cause was unsynchronized time on the nodes. So I can recommend to check that system time is equal over the

Composite Column Query Modeling

2012-09-13 Thread Adam Holmberg
I'm modeling a new application and considering the use of SuperColumn vs. Composite Column paradigms. I understand that SuperColumns are discouraged in new development, but I'm pondering a query where it seems like SuperColumns might be better suited. Consider a CF with SuperColumn layout as

Re: hadoop inserts blow out heap

2012-09-13 Thread aaron morton
What version of Cassandra are you using ? 2.9G of the heap is consumed by a JMXConfigurableThreadPoolExecutor that appears to be full of batch mutations. That sounds like writes were backing up and/or blocked for some reason. Check the logs for errors. Notetool tpstats will show you if

Re: thoughts on this feature request

2012-09-13 Thread aaron morton
Remove value1.pkX AND Add value2.pkX such that if value1.pkX is NOT found, the whole row will be scanned for ANYvalue.pkX and remove that value instead. Couple of thoughts: * that sounds like something that would need a lock or transaction to stop changes when things were scanned. e.g. You

Re: Data Model

2012-09-13 Thread Michael Morris
I'm fairly new to Cassandra myself, but had to solve a similar problem. If ordering of the student number values is not important to you, you can store them as UTF8 values (Ascii would work too, may be a better choice?), and the resulting columns would be sorted by the lexical ordering of the

Re: Composite Column Types Storage

2012-09-13 Thread aaron morton
Range queries do not use bloom filters. Are you talking about row range queries ? Or a slice of columns in a row ? If you are getting a slice of columns from a single row, a bloom filter is used to locate the row. If you are getting a slice of columns from a range of rows, the bloom filter

Re: nodetool connection refused

2012-09-13 Thread aaron morton
Yes. If your IDE is starting cassandra the settings from cassandra-env.sh will not be used. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/09/2012, at 12:41 PM, Manu Zhang owenzhang1...@gmail.com wrote: I'm afraid we have to include