Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop Import with Multiple Delimiters

Highlighted

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.

1 REPLY 1

Re: Sqoop Import with Multiple Delimiters

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.

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