Thanks, it does. How about in astyanax? From: Eric Stevens [mailto:migh...@gmail.com] Sent: Tuesday, February 03, 2015 1:49 PM To: user@cassandra.apache.org Subject: Re: Smart column searching for a particular rowKey
WHERE < + ORDER DESC + LIMIT should be able to accomplish that. On Tue, Feb 3, 2015 at 11:28 AM, Ravi Agrawal <ragra...@clearpoolgroup.com<mailto:ragra...@clearpoolgroup.com>> wrote: Hi Guys, Need help with this. My rowKey is stockName like GOOGLE, APPLE. Columns are sorted as per timestamp and they include some set of data fields like price and size. So, data would be like 1. 9:31:00, $520, 100 shares 2. 9:35:09, $530, 1000 shares 3. 9:45:39, $520, 500 shares I want to search this column family using partition key timestamp. For a rowkey, if I search for data on partition id 9:33:00 which does not actually exist in columns, I want to return the last value where data was present. In this case 9:31:00, $520, 100 shares, since the next partitionkey is 9:35:09 which is greater than input value entered. One obvious way would be iterating through each columns and storing last data, if new timestamp is greater than given timestamp then return the last data stored. Is it any optimized way to achieve the same? Since columns are already sorted. Thanks
