...
| 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. |
When the UDR fields do not have names that matches the database columns, you can map these manually by clicking the corresponding cell and selecting the field from a drop-down list.
...
| title | Note! |
|---|
...
| 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.
|
When the UDR fields do not have names that matches the database columns, you can map these manually by clicking the corresponding cell and selecting the field from a drop-down list.
| Anchor | ||||
|---|---|---|---|---|
|
The following table shows allowed mappings of Impala types to Ultra types.
...