Sqoop export using delimiters

[mangleeswaran]

Hi,

I am trying to use delimiters while exporting from HDFS to mysql. The code runs successfully but exports only the first record.

Code:
sqoop export --num-mappers 1 --connect “jdbc:mysql://nn01.itversity.com:3306/retail_db” --username retail_dba --password itversity --table
departments_man --export-dir /user/mangleeswaran/departments_delim --input-enclosed-by " --input-fields-terminated-by ‘:’ --input-lines-terminated-by ‘|’

Dataset:

“1”:“Testing”|“2”:“Fitness”|“3”:“Footwear”|“4”:“Apparel”|“5”:“Golf”|“6”:“Outdoors”|“7”:“Fan Shop”|“8”:“Testing Merge”|“9”:“paper”|“10”:“Indoor”|“20”:“FedEx”|“10000
”:“savin”|“11000”:“savinTest”|“1000000”:“Naveen1”|

Please clarify.

[itversity]

Here is the solution

Sqoop Export fails

Hi Manoj, I tried the same. Input file is: 1|Jeeva:2|Durai: Export sqoop command is: sqoop export --connect jdbc:mysql://ip-172-31-13-154/retail_db --username sqoopuser --password NHkkP876rp --table jee_test2 --input-fields-terminated-by '|' --input-lines-terminated-by ':' --export-dir /user/ramXXXXX/jee_test1; But it exports only one record. The output in mysql is: ±-----±------+ | id | name | ±-----±------+ | 1 | Jeeva | ±-----±------+ 1 row in set. And I found that, Sqo…

[mangleeswaran]

Hi,

Yes. It works only for line delimited by new line.

Thanks.

[itversity]

It should work with other delimiters as well as demonstrated by Jeeva.