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 wrote: > I'm afraid we have to include all $JVM_OPTS in the c

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 i

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 nume

Re: thoughts on this feature request

2012-09-13 Thread aaron morton
> Remove . AND Add . such that if . is > NOT found, the whole row will be scanned for . 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 would need the sort of key range l

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 muta

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 follo

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 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 nodes (especially

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 c

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 IDs

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 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 have to restart. It

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 th

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: 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 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 out-of-order sstable was being i

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 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 state that wasn't >

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 wrote: > Hey all, >I'm setting up a new ring on