question Re: How to Sqoop Teradata column with latin charset into hive in Archives of Support Questions (Read Only)

How to Sqoop Teradata column with latin charset into hive

nbalaji-elangov — Sat, 17 Dec 2016 00:16:36 GMT

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

dconnolly — Sat, 17 Dec 2016 02:34:56 GMT

These links from previous questions may help

jack_howard — Tue, 28 Nov 2017 07:16:09 GMT

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