Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to Sqoop Teradata column with latin charset into hive

avatar
Expert Contributor

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

1 ACCEPTED SOLUTION
2 REPLIES 2

avatar
Expert Contributor

avatar
Explorer

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