Support Questions
Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

Rising Star

Hello @PPR Reddy.
Did you try to escape by passing it's hexadecimal value?
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!