If you want to get all the family members, you can just specify 'familyname:' as the column. This creates a wild-card scanner which will do what you want without filters.
--- Jim Kellerman, Senior Engineer; Powerset > -----Original Message----- > From: Clint Morgan [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 20, 2008 9:19 AM > To: [email protected] > Subject: Re: Filter omitting columns > > 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 > > > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.21.7/1335 - Release > Date: 3/19/2008 9:54 AM > > No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1335 - Release Date: 3/19/2008 9:54 AM
