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.