Use the fields on this tab to create or edit mappings for an HBase table. The mapping defines metadata about the values that are stored in the table. Since data is stored as raw bytes in HBase, PDI can decode values and execute comparisons for column-based result set filtering. The fields area of the tab is used to enter information about the columns in the HBase table that the user wants to map. Selecting the name of an existing mapping loads the fields defined in that mapping into the fields area of the display.
A valid mapping must define metadata for the key of the source HBase table. The key must have a value specified in the Alias column because a name is not given to the key of an HBase table. Non-key columns must specify the Column family and the Column name that they belong to. Non-key columns can have an optional alias; if one is not supplied, then the column name is used as an alias. All fields must have type information supplied.
| Option | Description |
|---|---|
| HBase table name | Displays a list of table names. Connection information in the previous tab must be valid and complete for this drop-down list to populate. Selecting a table here populates the Mapping name drop-down box with the names of available mappings for that table. |
| Get table names (button) | Click to retrieve a list of all existing table names for the HBase table name field, even if they do not have Pentaho mappings. If you enter a namespace:filename in the HBase table name field and click Get mapped table names, only mapped table names display in the list. If you do not enter a namespace, all HBase tables across all namespaces are displayed. See Namespaces. |
| Mapping name |
Names of any mappings that exist for the table. This box is empty
when there are no mappings defined for the selected table.
Note: You can define multiple
mappings on the same HBase table using different subsets of
columns.
|