Field | Field Description/Action |
HBase Table | Select a table name from the list of tables. |
Column Family | Displays the list of column families for the selected table name. |
Select | Select the check box for the corresponding column family to query. |
Maximum Version | Specify the maximum number of versioned values for a corresponding column family. |
Sampling Range | Specify the number of records to be scanned to get a minimum set of column qualifiers. These column qualifiers are listed in the Columns tab. Value can be entered in the following formats: ![]() For example, if you provide Sampling Range: 10, then the service will scan initial 10 records of the selected table. ![]() For example, if you provide Sampling Range: row100-row1000, then the service will scan all the records which contain row ids between row100 to row1000 Note: Sampling is not performed for the values which do not contain the above formats, and the list of column qualifiers under Columns tab will remain empty. |
Versions | Specify the number of versions for the selected table, to retrieve more than one value for a particular column qualifier. The default value is 1. Use the default value to get the latest value of the column qualifiers. Note: Minimum value of version should be 1, to get a valid output. |
Output Structure | Select either of the following Output Structure: ![]() ![]() Note: If you do not make an entry for a column qualifier in Columns tab, then the Output Structure of the table remains the same, and returns the complete list of Row Ids of the selected table. |
Field | Description/Action |
Column Family | Provides the list of column families based on the selection made in the Schema tab. |
Select Column Qualifier | Select the column qualifier which can be retrieved for the corresponding column family. The Select Column Qualifier field is displayed as a drop down list. These values are retrieved based on the Sampling Range provided in the Schema tab. |
Column Qualifier Type | The Select Column Qualifier field supports the following data types: ![]() ![]() ![]() |
Enter Column Qualifier | Specify the column qualifiers which are not listed in the Select Column Qualifier field. |
Name | Description/Action |
AND/OR | Input Field. |
Parameter Key | Defines a unique key. Rows in both tables in the WHERE clause will be inter dependent if it contains same parameter key. For example, if you delete a row having parameter key as 1, then it automatically deletes the row having the same parameter key from the other table. Note: By default, the number of unique keys are between1 to 25. To increase the number of unique keys, set the watt property as, watt.hbase.filters.limit =30. |
Filters | Displays the list of different filters. Different types of filters are listed below: ![]() ![]() Note: Row Id Prefix works only with EQUAL operator. ![]() Note: Timestamp filter works only with EQUAL operator. ![]() Note: If you select the number of versions to be retrieved as 1, then the latest version for the row matching the value filter is retrieved even if the data passed in Value filter appears in any other version in the same row. ![]() Note: The Value and Column Qualifier based filters supports the following data types: ![]() ![]() ![]() |
Operator | The following are the operators used: ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Input Field Type | The data type of the Input Field. You can change this type if needed. |
Input Field | The default value is ?, which acts as a placeholder for the variable so that you can set the input variable for that column at run time, or get input external to this adapter service. You can also type a fixed value in this field now or at run time. If you type a fixed value, be sure that it is valid, or an exception will be generated at run time. |
Field | Description/Action |
Parameter Key | The unique key for those rows in the above table which takes input at runtime. |
Filters(second occurrence of this field) | The name of the column you need to use in the WHERE clause. |
Input Field type | The corresponding data type of an Input Field. |
Input Field(second oc-currence of this field) | The name of the input field. By default the name combines the values of Parameter and Field fields. However, you can also choose to specify any custom value. |