I was having a similar problem as well. Though I've never used just the column families to specify the columns (eg always fully qualified col names like family:col) . Maybe you can try my patch and see if it fixes your problem.
https://issues.apache.org/jira/browse/HBASE-527 Also you can give a null value for the row key regexp if you don't want to use it in RegExpRowFilter. -clint On Thu, Mar 20, 2008 at 7:23 AM, Goel, Ankur <[EMAIL PROTECTED]> wrote: > > Hi, > I am trying to obtain a set of rows by obtaining a scanner > on Htable. I also specify the RowFilterCriteria like this. > > /* Code Start */ > Map<Text, byte[]> columnFilter = new HashMap<Text, byte[]>(); > columnFilter.put(new Text("status:"), getBytes(1)); > RowFilterInterface rowFilter = new RegExpRowFilter(".*", columnFilter); > > HTable myTable = new HTable(conf, new Text("myTable")); > Text[] columns = {new Text("url:"), new Text("status:")}; > myTable.obtainScanner(columns, HConstants.EMPTY_START_ROW, rowFilter); > /* Code End */ > > When I scan the table, I only get 'status:' column family and its > values. > The 'url:' family is not present. > > In simple SQL the query translates to something like > > SELECT url, status FROM mytable WHERE status=1; > > What could be wrong ? > > I eventually want to do something like this > > SELECT url, status, date FROM mytable WHERE (status=1 or (status=2 and > [today's date] > date)); > > I have used RowFilterSet with RowFilterSet.Operation options to > accomplish this but the omission > of columns not on the filter column list by the filter beats me. > > Thanks > -Ankur >
