You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hbase.apache.org by "Andrew Kyle Purtell (Jira)" <ji...@apache.org> on 2022/06/16 17:52:00 UTC

[jira] [Resolved] (HBASE-9169) More Comparator

     [ https://issues.apache.org/jira/browse/HBASE-9169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrew Kyle Purtell resolved HBASE-9169.
----------------------------------------
    Resolution: Invalid

> More Comparator
> ---------------
>
>                 Key: HBASE-9169
>                 URL: https://issues.apache.org/jira/browse/HBASE-9169
>             Project: HBase
>          Issue Type: Task
>          Components: Filters
>    Affects Versions: 0.94.9
>            Reporter: liuhongtao
>            Priority: Major
>              Labels: Comparator
>
> SubstringComparator valueComp1 = new SubstringComparator("C34");
> Filter actAttributeValueFilter1 = new SingleColumnValueFilter(Bytes.toBytes("cf"),
> 				Bytes.toBytes("code"), CompareOp.EQUAL, valueComp1);
> SubstringComparator valueComp2 = new SubstringComparator("S72");
> Filter actAttributeValueFilter2 = new SingleColumnValueFilter(Bytes.toBytes("cf"),
> 				Bytes.toBytes("code"), CompareOp.EQUAL, valueComp2);
> SubstringComparator valueComp3 = new SubstringComparator("S75");
> Filter actAttributeValueFilter3 = new SingleColumnValueFilter(Bytes.toBytes("cf"),
> 				Bytes.toBytes("code"), CompareOp.EQUAL, valueComp3);
> FilterList multiValueFilters = new FilterList();
> multiValueFilters.addFilter(actAttributeValueFilter1);
> multiValueFilters.addFilter(actAttributeValueFilter2);
> multiValueFilters.addFilter(actAttributeValueFilter3);
> Filter multiValueORFilter = new FilterList(FilterList.Operator.MUST_PASS_ONE, multiValueFilters);
> replace with:
> SubstringsOrComparator orValueComp = new SubstringsOrComparator("C34^S72^S75");
> Filter orValueFilter = new SingleColumnValueFilter(Bytes.toBytes("cf"),
> Bytes.toBytes("code"), CompareOp.EQUAL, orValueComp);
> or 
> SubstringsAndComparator orValueComp = new SubstringsAndComparator("C34^S72^S75");
> Filter orValueFilter = new SingleColumnValueFilter(Bytes.toBytes("cf"),
> Bytes.toBytes("code"), CompareOp.NOT_EQUAL, orValueComp);



--
This message was sent by Atlassian Jira
(v8.20.7#820007)