How to Sqoop Teradata column with latin charset into hive

[#1]

One of the column datatype is VARCHAR(15), LATIN

connection string - jdbc:teradata://<host>/database=<db>,charset=UTF8

We notice special characters in the column imported in hive

[#2 · Accepted solution]

These links from previous questions may help

https://community.hortonworks.com/questions/58916/utf-8-hive.html

https://community.hortonworks.com/articles/58548/processing-files-in-hive-using-native-non-utf8-cha....

[#3]

Your character set is incorrect on the url: It should be specified as

connection string - jdbc:teradata://<host>/database=<db>,CLIENT_CHARSET=ISO8859_1'

charset is not processed the same as "client_charset" - see this reference for all character sets for Teradata.
https://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_1.html