RE: How HBase perform per-column scan?

2013-03-10 Thread Liu, Raymond
, 2013 7:43 AM > To: user@hbase.apache.org > Subject: RE: How HBase perform per-column scan? > > Just curious, won't ROWCOL bloom filter works for this case? > > Best Regards, > Raymond Liu > > > > > As per the above said, you will need a full t

RE: How HBase perform per-column scan?

2013-03-10 Thread Anoop Sam John
.com] Sent: Monday, March 11, 2013 7:43 AM To: user@hbase.apache.org Subject: RE: How HBase perform per-column scan? Just curious, won't ROWCOL bloom filter works for this case? Best Regards, Raymond Liu > > As per the above said, you will need a full table scan on that CF. > As Ted said

RE: How HBase perform per-column scan?

2013-03-10 Thread Liu, Raymond
Just curious, won't ROWCOL bloom filter works for this case? Best Regards, Raymond Liu > > As per the above said, you will need a full table scan on that CF. > As Ted said, consider having a look at your schema design. > > -Anoop- > > > On Sun, Mar 10, 2013 at 8:10 PM, Ted Yu wrote: > > > b

Re: How HBase perform per-column scan?

2013-03-10 Thread Anoop John
As per the above said, you will need a full table scan on that CF. As Ted said, consider having a look at your schema design. -Anoop- On Sun, Mar 10, 2013 at 8:10 PM, Ted Yu wrote: > bq. physically column family should be able to perform efficiently (storage > layer > > When you scan a row, da

Re: How HBase perform per-column scan?

2013-03-10 Thread Ted Yu
bq. physically column family should be able to perform efficiently (storage layer When you scan a row, data for different column families would be brought into memory (if you don't utilize HBASE-5416) Take a look at: https://issues.apache.org/jira/browse/HBASE-5416?focusedCommentId=13541258&page=c

Re: How HBase perform per-column scan?

2013-03-10 Thread PG
Hi, Ted and Anoop, thanks for your notes. I am talking about column rather than column family, since physically column family should be able to perform efficiently (storage layer, CF's are stored separately). But columns of the same column family may be mixed physically, and that makes filters c

Re: How HBase perform per-column scan?

2013-03-10 Thread Ted Yu
Hi, Yun: Take a look at HBASE-5416 (Improve performance of scans with some kind of filters) which is in 0.94.5 release. In your case, you can use a filter which specifies column C as the essential family. Here I interpret column C as column family. Cheers On Sat, Mar 9, 2013 at 11:11 AM, yun pen

Re: How HBase perform per-column scan?

2013-03-09 Thread Anoop John
When you say column, you mean one column family (CF) or column qualifier? If this is one column qualifier and there are other qualifiers in the same CF? -Anoop- On Sun, Mar 10, 2013 at 12:41 AM, yun peng wrote: > Hi, All, > I want to find all existing values for a given column in a HBase, and w