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

Sqoop Import with Multiple Delimiters

New Contributor

I am trying to import a SQL Server table into Hortonworks HDFS using Sqoop Import command. I have numerous text fields and large strings with special characters in them. Thus I cannot use regular delimiters like ',' or '|' . I even tried '\b' but still I have issues loading it.

The filed text is displaced and moved to subsequent field when ever one of these strings is already present int he field text. Is there a way to use multiple delimiter in sqoop ? Ex: '|--|' or '$$||' .

I tried using multiple delimiters but it tends to take only first character.

Thank you.


Expert Contributor

@vamsi krishna sabbisetty , Sqoop does not support multichar delimiter as the field and record delimiter are defined as char type in the code.