Thats great, but it won't do what he wants, as he want only rows where the value for the status: column equals getBytes(1). Hence the filter.
On Thu, Mar 20, 2008 at 9:30 AM, Jim Kellerman <[EMAIL PROTECTED]> wrote: > 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 > >
