Sqoop export using delimiters

#1

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.

0 Likes

#2

Here is the solution

0 Likes

#3

Hi,

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

Thanks.

0 Likes

#4

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

0 Likes