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 http://www.thelastpickle.com On 7/07/2012, at 1:28 PM, Sunit Randhawa wrote: > 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. >> >> >> >>
