...
| Setting | Description | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Table | Select a database table from the drop-down list. The name of the table columns and their data type will appear.
| |||||||||||
| UDR Type | Click the Browse button and then select a UDR type that will be routed to a Data Hub agent. For information about Ultra types that can be mapped to Impala types, see Compatible Types below. | |||||||||||
| Auto Map | Click this button to automatically map UDR fields and database columns with identical names. The automatic mapping is not case-sensitive. If a field cannot be mapped, the current value in the UDR Field column remains unchanged. | |||||||||||
| Column | The name of the columns in the selected table. | |||||||||||
| Type | Clicking the cell, displays a list of valid Impala types. Each column must be mapped against a type. For information about Ultra types that can be mapped to Impala types, see Compatible Types below. | |||||||||||
| UDR Field | Select a UDR field from the drop-down list. This represents selectable fields available based on the selected UDR Type above. | |||||||||||
| Date Hint | Select the date format to be stored in the table. A date in the Ultra format can be stored as date, string, or integer types. When the type is string or integer, you must select the corresponding date format from a drop-down list in this column:
The selected format determines the granularity of date pickers in the Web UI. When you change the Date Hint value of a partition column for an existing profile, make sure to review the settings of Data Hub task workflows that depend on the updated profile and table.
|
...