Re: Column Value Reference Timestamp Filter

2012-08-27 Thread Jerry Lam
Hi Alex: We decided to use setTimeRange and setMaxVersions, and remove the column with a reference timestamp (i.e. we don't put this column into hbase anymore). This behavior is what we would like but it seems very inefficient because all versions are processed before the setMaxVersions takes effe

Re: Column Value Reference Timestamp Filter

2012-08-20 Thread Alex Baranau
Hi, So, you have row with key rowKeyA and column col1. And it contains two values value1 and value2 at timestamp1 and timestamp2 respectively, where timestamp1 is most recent. And you want to fetch "most recent but one" values in all columns when doing the scan. I.e. you don't know the timestamp1

Column Value Reference Timestamp Filter

2012-08-20 Thread Jerry Lam
Hi HBase community: I have a requirement in which I need to query a row based on the timestamp stored in the value of a column of a row. For example. (rowkeyA of col1) -> (value) at timestamp = t1, (value) stores t2. Result should return all columns of rowkeyA at timestamp = t2. Note that t1 > t