Member since
10-30-2018
4
Posts
0
Kudos Received
0
Solutions
03-20-2019
06:25 PM
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
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
-
Apache Sqoop
10-30-2018
05:38 PM
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
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
-
Apache Sqoop