Query data in a CF within a timestamp range

2013-02-28 Thread Kasun Weranga
Hi all, I have a column family with some data + timestamp values and I want to query the column family to fetch data within a timestamp range. AFAIK it is not better to use secondary index for timestamp due to high cardinality. Is there a way to achieve this functionality? Thanks, Kasun.

Re: Query data in a CF within a timestamp range

2013-02-28 Thread Edward Capriolo
Pseudo code : GregorianCalendar gc = new GregorianCalendar(); DateFormat df = new SimpleDateFormat( MMddhhmm'); String reversekey = df.format(gc); set mycolumnfamily['myrow']['mycolumn'] = 'myvalue'; set myreverseindex['$reversekey]['myrow'] = ''; Under rapid insertion this makes hot-spots.