check the option --input-fields-terminated-by in sqoop export
On Tue, Jun 18, 2013 at 4:31 PM, Hamza Asad <hamza.asa...@gmail.com> wrote: > I want to export my table in mysql and for that i'm using sqoop export > command but in HDFS i've data apparantly without any field seperator But it > does contain some field separator. data is saved in the format as shown > below > *8119844 1 4472499 2013-01-29 00:00:00.0 1 4 1 \N \N \N \N \N \N \N \N \N > \N 8 \N \N \N \N \N 1 \N \N 3 2 \N 1* > how can i export this type of data to mysql and what field separator i > mention it there.. Please help > > -- > *Muhammad Hamza Asad* > -- Nitin Pawar