FAQ
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 scm-users+unsubscribe@cloudera.org.

Search Discussions

  • Vikram Srivastava at Sep 25, 2013 at 6:13 pm
    +cdh-user, -scm-users

    Forwarding to cdh-user where this can be properly answered.

    ---------- Forwarded message ----------
    From: Rex Zhen <rex.zhen@gmail.com>
    Date: Wed, Sep 25, 2013 at 10:55 AM
    Subject: sqoop export failed
    To: scm-users@cloudera.org


    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 scm-users+unsubscribe@cloudera.org.

    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedSep 25, '13 at 5:56p
activeSep 25, '13 at 6:13p
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Vikram Srivastava: 1 post Rex Zhen: 1 post

People

Translate

site design / logo © 2022 Grokbase