Re: Composite Slice Query returning non-sliced data

2012-07-10 Thread Tyler Hobbs
On Tue, Jul 10, 2012 at 2:20 PM, Sunit Randhawa wrote: > I have tested this extensively and EOC has huge issue in terms of > usability of CompositeTypes in Cassandra. > > As an example: If you have 2 Composite Columns such as A:B:C and A:D:C. > > And if you do search on A:B as start and end Compos

Re: Composite Slice Query returning non-sliced data

2012-07-10 Thread Sunit Randhawa
I have tested this extensively and EOC has huge issue in terms of usability of CompositeTypes in Cassandra. As an example: If you have 2 Composite Columns such as A:B:C and A:D:C. And if you do search on A:B as start and end Composite Components, it will return D as well. Because it returns all t

Re: Composite Slice Query returning non-sliced data

2012-07-10 Thread Tyler Hobbs
I think in this case that's just Hector's way of setting the EOC byte for a component. My guess is that the composite isn't being structured correctly through Hector, as well. On Tue, Jul 10, 2012 at 4:40 AM, aaron morton wrote: > > The first thing that stands out is that (in cassandra) comparis

Re: Composite Slice Query returning non-sliced data

2012-07-10 Thread aaron morton
Ah, it's a Hector query question. You may have bette luck on the Hector email list. Or if you can turn on debug logging on the server and grab the query that would be handy. The first thing that stands out is that (in cassandra) comparison operations are not used in a slice range. Cheers

Re: Composite Slice Query returning non-sliced data

2012-07-09 Thread Sunit Randhawa
Aaron, Let me start from the beginning. 1- I have a ColumnFamily called Rollup15 with below definition: create column family Rollup15 with comparator = 'CompositeType(org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8

Re: Composite Slice Query returning non-sliced data

2012-07-08 Thread aaron morton
Something like: This is how I did the write in CLI and this is what it printed. and then This is how I did the read in the CLI and this is what it printed. It's hard to imagine what data is in cassandra based on code. cheers - Aaron Morton Freelance Developer @aaronmorton h

Re: Composite Slice Query returning non-sliced data

2012-07-06 Thread Sunit Randhawa
Aaron, For writing, i am using cli. Below is the piece of code that is reading column names of different types. Composite start = new Composite(); start.addComponent(0, beginTime, Composite.ComponentEquality.EQUAL);

Re: Composite Slice Query returning non-sliced data

2012-07-06 Thread aaron morton
Can you provide an example of writing and reading column names of a different type. Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6/07/2012, at 11:30 AM, Sunit Randhawa wrote: > HI Aaron, > > It is > > create column family CF >

Re: Composite Slice Query returning non-sliced data

2012-07-05 Thread Sunit Randhawa
HI Aaron, It is create column family CF with comparator = 'CompositeType(org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)' and key_validation_class = UTF8Type and default_validation_class = UTF8Type;

Re: Composite Slice Query returning non-sliced data

2012-07-05 Thread aaron morton
> #2 has the Composite Column and #1 does not. They are both strings. All column names *must* be of the same type. What was your CF definition ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6/07/2012, at 7:26 AM, Sunit Randhawa wrote:

Composite Slice Query returning non-sliced data

2012-07-05 Thread Sunit Randhawa
Hello, I have 2 Columns for a 'RowKey' as below: #1 : set CF['RowKey']['1000']='A=1,B=2'; #2: set CF['RowKey']['1000:C1']='A=2,B=3''; #2 has the Composite Column and #1 does not. Now when I execute the Composite Slice query by 1000 and C1, I do get both the columns above. I am hoping get #2