Use these fields in this table to filter
your results.
| Option | Description |
|---|---|
| # | The order of the filter operation. |
| Alias | A drop-down menu of column alias names derived from the mapping. |
| Type | Data type of the column. This field is automatically populated when you select a field after choosing the alias. |
| Operator | A drop-down menu that containing equality/inequality operators for numeric, date, and Boolean fields; or substring and regular expression operators for string fields. |
| Comparison value | A comparison constant to use in conjunction with the operator. |
| Format | A formatting mask to apply to the field. |
| Signed comparison | Specifies whether the comparison constant and/or field values involve negative numbers for non-string fields. Because HBase stores numbers in two's complement form, the Filter result set tab includes the Signed comparison column for indicating whether the comparison involves signed numbers. If the field values and comparison constants are only positive for a given filter, then HBase's native lexicographical byte-based comparisons will produce accurate results. If the field contains negative numbers, then column values must be deserialized from bytes to actual numbers before performing the comparison. |
Note: HBase
Input ships with a custom comparator for deserializing column values before
performing a comparison. This needs to be installed on each HBase node before signed
comparisons will work correctly. Similarly, a special comparator for Boolean values is
provided to implement deserializing and interpreting Boolean values from numbers and
various string encodings.