[
https://issues.apache.org/jira/browse/HBASE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13101632#comment-13101632
]
Todd Lipcon edited comment on HBASE-4364 at 9/9/11 11:08 PM:
-------------------------------------------------------------
Actually, it turns out this isn't due to column family pruning - the same
behavior occurs even with just one column family:
{noformat}
create 't2', 'f'
put 't2', 'r1', 'f:e_word', 'hello'
put 't2', 'r1', 'f:f_word', 'bonjour'
put 't2', 'r2', 'f:e_word', 'goodbye'
put 't2', 'r2', 'f:f_word', 'au revoir'
scan 't2'
# scan selecting only one column - returns 2 distinct rows
scan 't2', { COLUMNS => ['f:e_word'] }
# scan with a predicate of the french word > 'b', returns 1 row
scan 't2', { FILTER => "SingleColumnValueFilter('f', 'f_word', >, 'binary:b')"
}
# scan with a predicate of the french word > 'b', selecting only the english
word
scan 't2', { COLUMNS => ['f:e_word'], FILTER => "SingleColumnValueFilter('f',
'f_word', >, 'binary:b')" }
{noformat}
was (Author: tlipcon):
Actually, it turns out this isn't due to column family pruning - the same
behavior occurs even with just one column family:
{noformat}
create 't2', 'f'
put 't2', 'r1', 'f:e_word', 'hello'
put 't2', 'r1', 'f:f_word', 'bonjour'
put 't2', 'r2', 'f:e_word', 'goodbye'
put 't2', 'r2', 'f:f_word', 'au revoir'
scan 't2'
# scan selecting only one column - returns 2 distinct rows
scan 't2', { COLUMNS => ['f:e_word'] }
# scan with a predicate of the french word > 'b', returns 1 row
scan 't2', { FILTER => "SingleColumnValueFilter('f', 'f_word', >, 'binary:b')"
}
# scan with a predicate of the french word > 'b', selecting only the english
word
scan 't2', { COLUMNS => ['f:e_word'], FILTER => "SingleColumnValueFilter('f',
'e_word', >, 'binary:b')" }
{noformat}
> Column family pruning incorrectly prunes CFs referred to by filters
> -------------------------------------------------------------------
>
> Key: HBASE-4364
> URL: https://issues.apache.org/jira/browse/HBASE-4364
> Project: HBase
> Issue Type: Bug
> Affects Versions: 0.90.4, 0.92.0
> Reporter: Todd Lipcon
> Priority: Critical
>
> For a scan, if you select some set of columns using addColumns(), and then
> apply a SingleColumnValueFilter that restricts the results based on some
> other columns which aren't selected, and those non-selected columns are part
> of a separate column family, then those filter conditions are ignored.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
