Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to Sqoop Teradata column with latin charset into hive

Solved Go to solution
Highlighted

How to Sqoop Teradata column with latin charset into hive

Rising Star

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

Accepted Solutions

Re: How to Sqoop Teradata column with latin charset into hive

Contributor
2 REPLIES 2

Re: How to Sqoop Teradata column with latin charset into hive

Contributor
Highlighted

Re: How to Sqoop Teradata column with latin charset into hive

New Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here