Most HBase data is stored as raw bytes. PDI uses mapping to decode values and execute meaningful comparisons for column-based result set filtering. Use the Create/Edit mapping tab to define metadata about the values that are stored in an HBase table.
Perform the following tasks before writing a value to HBase:
- Configure a connection by using the Hadoop cluster properties.
- Define which column family the value belongs to and its type.
- Specify type information about the key of the table.
This tab includes the following options:
Option | Description |
---|---|
Hadoop Cluster |
Select an existing Hadoop cluster configuration from the drop-down box. If you do not have an existing connection, click New. If you need to modify an existing connection, click Edit. See Connect to a Hadoop cluster with the PDI client for instructions. |
HBase table name | Select the source HBase table name that has a defined mapping from the drop-down list of displayed names. Connection information must be valid and complete for this list to populate. Select a table to populate 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. The table names display the namespace, followed by a colon, then the table name. See Namespaces. |
Mapping name | Select the name of an existing map for the source table. The drop-down list is empty when no mappings are defined for the selected table. You can define multiple mappings on the same HBase table using different subsets of columns. |