Skip to main content

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!