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 escape ^M character in data while doing sqoop import from the Oracle Database

Highlighted

How to escape ^M character in data while doing sqoop import from the Oracle Database

Rising Star
 
1 REPLY 1
Highlighted

Re: How to escape ^M character in data while doing sqoop import from the Oracle Database

Hello @PPR Reddy.
Did you try to escape by passing it's hexadecimal value?
https://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_large_objects
I didn't give it a shot, but I'd say would be like this:

sqoop import <YOUR ORACLE CONN STRING> --fields-terminated-by \0xD --the representation of ^M in hexdecimal

Hope this helps!

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