# 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<br>for the Filter value parameter. If<br>the filtering condition is met, all columns of the row will be<br>returned. |
| Family filter |  | Yes | Yes |  | Yes | It returns the columns of the family that meets the filtering<br>condition. |
| Qualifier filter | Yes |  | Yes |  | Yes | It returns the columns whose column qualifiers match the filtering<br>condition. |
| Column prefix filter | Yes | Yes |  |  |  | It returns all columns of which the qualifiers have the prefix<br>defined for the Filter column parameter. |
| Multiple column prefix filter | Yes (Multiple prefixes are separated by comma, for<br>example, *id,id\_1,id\_2*) | Yes |  |  |  | It works the same way as a Column prefix<br>filter does but allows specifying multiple<br>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<br>scanned row. |
| Row filter |  |  | Yes | Yes | Yes | It filters on row keys and returns all rows that matches the<br>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.