I am working on a data lake project and one of the data sources happens to be Lotus notes database. Is anyone familiar with a process either sqoop or some other way of ingesting data from Lotus Notes db ? ... View more

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. ... View more