Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB