Hi Jack, I'm just trying follow the logic and I'm a bit confused.
> Note that ['generic', 'photo'], utilizes 'OR' operator, and not > 'AND'. Is it possible to create a scanner that will not AND and not > OR?, in which case something like this: Am I right in thinking you meant "AND and not OR" instead of "not AND and not OR"? Thanks, Phil On Fri, Jan 7, 2011 at 8:01 PM, Jack Levin <[email protected]> wrote: > Hello all, I have a scanner question, we have this table: > > hbase(main):002:0> scan 'mattest' > ROW COLUMN+CELL > 1 column=generic:, > timestamp=1294454057618, value=1 > 1 column=photo:, > timestamp=1294453830339, value=1 > 1 column=type:, > timestamp=1294453812716, value=photo > 1 column=type:photo, > timestamp=1294453884174, value=photo > 2 column=generic:, > timestamp=1294454061156, value=1 > 2 column=type:, > timestamp=1294453851757, value=video > 2 column=type:video, > timestamp=1294453877719, value=video > 2 column=video:, > timestamp=1294453842722, value=1 > > We need to run this query: > > hbase(main):004:0> scan 'mattest', {COLUMNS => ['generic', 'photo']} > ROW COLUMN+CELL > 1 column=generic:, > timestamp=1294454057618, value=1 > 1 column=photo:, > timestamp=1294453830339, value=1 > 2 column=generic:, > timestamp=1294454061156, value=1 > > Note that ['generic', 'photo'], utilizes 'OR' operator, and not > 'AND'. Is it possible to create a scanner that will not AND and not > OR?, in which case something like this: > > scan 'mattest', {COLUMNS => ['generic' AND 'photo']} > ROW COLUMN+CELL > 1 column=generic:, > timestamp=1294454057618, value=1 > 1 column=photo:, > timestamp=1294453830339, value=1 > > Thanks in advance. > > -Jack >
