Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Sqoop Export Issue


Copy link to this message
-
Sqoop Export Issue
Hallo All,

I am working with Sqoop *Export* Command to write data from HDFS to
Postgres Database,
the Source Export file contains the data in the format

*28.00,10005|403.71,90210|20.02,95014*

and I am using the command

*sudo -u hdfs sqoop export --connect jdbc:postgresql://localhost/mydb
--username postgres -P -m 1 --table sqooptest --export-dir /user/hdfs/Sqoop
--input-lines-terminated-by '|'
*

to write to the database.

The command is ending successfully but writing only single record(*
28.00,10005*) to the Database.

Kindly let me know if anybody has worked with this issue in past. . .
--
Thanks
Vineet