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.

can some one provide a best approach to handle new line characters while importing data from sqoop to teradata? previously we used tpt script for data extract.

Highlighted

can some one provide a best approach to handle new line characters while importing data from sqoop to teradata? previously we used tpt script for data extract.

can some one provide a best approach to handle new line characters while importing data from sqoop to teradata? previously we used tpt script for data extract.

1 REPLY 1

Re: can some one provide a best approach to handle new line characters while importing data from sqoop to teradata? previously we used tpt script for data extract.

@sai venkatesh

Correct me if I am wrong, you are importing data from Teradata to HDFS/Hive using Sqoop.

If yes, then please note that Hive by default treats newline characters as row delimiters which would affect the data reads.