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.