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.

I want to remove '/n' from data while sqoop tha data into hdfs. Is there any sqoop cmd?

Highlighted

I want to remove '/n' from data while sqoop tha data into hdfs. Is there any sqoop cmd?

I have ' --hive-delims-replacement 'this cmd but this is for replce '/n' while importing the data into hive. But I want to import data into hdfs.

2 REPLIES 2
Highlighted

Re: I want to remove '/n' from data while sqoop tha data into hdfs. Is there any sqoop cmd?

Hey @Anjali Shevadkar!
Instead of using the --hive-delims-replacement, you can use the --hive-drop-import-delims to your sqoop.
This parameter drops any \n \r \01 while importing data to HDFS.
Hope this helps!

Highlighted

Re: I want to remove '/n' from data while sqoop tha data into hdfs. Is there any sqoop cmd?

Hi @Anjali Shevadkar also facing same problem, if u find any solution plz share

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