HBase filters - 7.3

HBase

Version
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > NoSQL components > HBase components
Data Quality and Preparation > Third-party systems > NoSQL components > HBase components
Design and Development > Third-party systems > NoSQL components > HBase components
Last publication date
2024-02-21

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.