IIS-CONN-HIVE-20002W The link column column_name is defined as ds_data_type and the respective column in the Hive data source is defined as hive_data_type. To match the data source column definition the link column should be defined as preferred_ds_data_type.
Explanation
To verify the schema column definitions, the connector compared the design schema column (on
the link) with the external schema column (in the data source). It detected that the currently
specified definition for the link column column_name is not the optimal
one.
User response
Change the data type of the specified link column as indicated in the message to resolve the
mismatch. You can also ignore the warning if the driver supports the value specified in the
format implied by the link column data type. To eliminate the warning messaged without making
changes to the column definitions on the link, disable the option to report schema mismatch
in the connector properties for the link.