Sqoop export using delimiters

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.

Here is the solution

Hi,

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

Thanks.

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