August 16, 2023

HBase filters – Docs for ESB 6.x

HBase filters

This table presents the HBase filters available in
Talend Studio
and the
parameters required by those filters.

Filter type

Filter column

Filter family Filter operation Filter value Filter comparator type Objective

Single Column Value Filter

Yes

Yes

Yes

Yes

Yes

It compares the values of a given column against the value defined
for the Filter value parameter. If
the filtering condition is met, all columns of the row will be
returned.

Family filter

 

Yes

Yes

 

Yes

It returns the columns of the family that meets the filtering
condition.

Qualifier filter

Yes

 

Yes

 

Yes

It returns the columns whose column qualifiers match the filtering
condition.

Column prefix filter

Yes

Yes

     

It returns all columns of which the qualifiers have the prefix
defined for the Filter column parameter.

Multiple column prefix filter

Yes (Multiple prefixes are separated by comma, for
example, id,id_1,id_2)

Yes

     

It works the same way as a Column prefix
filter
does but allows specifying multiple
prefixes.

Column range filter

Yes (The ends of a range are separated by comma. )

Yes

      It allows intra row scanning and returns all matching columns of a
scanned row.

Row filter

   

Yes

Yes

Yes It filters on row keys and returns all rows that matches the
filtering condition.

Value filter

   

Yes

Yes

Yes

It returns only columns that have a specific value.

The use explained above of the listed HBase filters is subject to revisions made by
Apache in its Apache HBase project; therefore, in order to fully understand how to use
these HBase filters, we recommend reading Apache’s HBase documentation.


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x