Support Questions

Find answers, ask questions, and share your expertise

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.


Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.