Sqoop Import with Multiple Delimiters

[#1]

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.

[#2]

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

Ref: https://issues.apache.org/jira/browse/SQOOP-1175