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); if (columns != null){ int colCount =1; for (String colName : columns){ start.addComponent(colCount,colName,Composite.ComponentEquality.EQUAL); colCount++; } } Composite finish = new Composite(); finish.addComponent(0, endTime, Composite.ComponentEquality.EQUAL); if (columns != null){ int colCount =1; for (String colName : columns){ if (colCount == columns.size()) finish.addComponent(colCount,colName+ Character.MAX_VALUE, Composite.ComponentEquality.GREATER_THAN_EQUAL); //Greater_than_equal is meant for any subslices to A:B:C if searched on A:B else finish.addComponent(colCount,colName,Composite.ComponentEquality.EQUAL); colCount++; } } SliceQuery<String, Composite, String> sq = HFactory.createSliceQuery(keyspace, StringSerializer.get(), new CompositeSerializer(), StringSerializer.get()); sq.setColumnFamily(columnFamilyName); sq.setKey(key); logger.debug("Start:"+start+",finish:"+finish); sq.setRange(start, finish, false, 10000); QueryResult<ColumnSlice<Composite, String>> result = sq .execute(); ColumnSlice<Composite, String> orderedRows = result.get(); Please let me know if you additional info. Thanks, Sunit. On Fri, Jul 6, 2012 at 10:59 AM, aaron morton <aa...@thelastpickle.com> wrote: > 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 > 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; > > This is allowing me to insert column names of different type. > > Thanks, > Sunit. > On Thu, Jul 5, 2012 at 4:24 PM, aaron morton <aa...@thelastpickle.com> > wrote: > > #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: > > > 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 only since I am specifically providing "C1" as > > Start and Finish Composite Range with > > Composite.ComponentEquality.EQUAL. > > > > I am not sure if this is by design. > > > Thanks, > > Sunit. > > > >