Key fields table
This table displays the metadata for the selected table.
Option
Description
#
The order of query limitation fields.
Alias
The name that the field will be given in the output stream.
Key
Indicates whether a field is the table's key field or not.
Column family
The column family in the HBase source table that the field belongs to.
Column name
The name of the column in the HBase table. The column family plus the column name uniquely identifies a column in an HBase table.
Type
The PDI data type for the field.
Format
Applies a formatting mask to the field. A formatting string must be provided for date values involved in a range scan (and optionally for numbers). There are two ways to provide this information in the dialog box:
Configure the step with fields from the mapping, include the key in the fields to output from the step, then enter a formatting string in the Format cell in the row corresponding to the key field.
If you have not opted to output the key from the step or have opted to output all fields in the mapping by leaving the fields table blank, then you can supply formatting information for the start and stop key values independently by suffixing the start or stop key value with the formatting string following a '@' separator character. For example, a date start key value of 1969-08-28 can be specified as
1969-08-28@yyy-MM-dd
.
Indexed values
An optional set of values you can define for string columns by entering comma-separated data in this field.
Get Key/Fields Info
Populates the field list and displays the name of the key as defined in the mapping when the connection information is complete and valid.
Last updated
Was this helpful?