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.