tried to export the hdfs files back to postgresql database. failed.
this is the command i ran,
sqoop export --fields-terminated-by \t --lines-terminated-by \r --table
title --export-dir /path/to/data/folder --connect
jdbc:postgresql://192.168.x.x/db_tmp --username user --direct
13/09/25 10:36:37 INFO mapred.JobClient: Task Id :
attempt_201309241435_0166_m_000003_2, Status : FAILED
java.io.IOException: Can't export data, please check task tracker logs
at
org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:112)
at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:39)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:140)
at
org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330)
at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408)
at org.apache.hadoop.mapred.Child.main(Child.java:262)
Caused by: java.lang.NumberFormatException: For input string: "2369308 "" 2012-08-23
13:15:20.273 Mon"
at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Long.par
double checked the columns in db and the number fields in the hdfs file,
they are match.
the log in the database side i can see,
2013-09-25 10:36:40 PDT nim_tmp 192.168.10.171 idle 08P01 [unknown]LOG:
unexpected EOF on client connection
checked the code 08P01 for postgresql, it means "protocol_violation"
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
