Guest User

Untitled

a guest
Jul 27th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.83 KB | None | 0 0
  1. Facing some problems in sqoop-export?
  2. hadoop@ubuntu:~/sqoop-1.3.0-cdh3u1/bin$ ./sqoop-export --connect 'jdbc:sqlserver://192.168.1.1;username=abcd;password=12345;database=HadoopTest' --table tmptempmeasurereport --export-dir /user/hive/warehouse/tmptempmeasurereport
  3.  
  4. 12/03/29 16:20:21 INFO SqlServer.MSSQLServerManagerFactory: Using Microsoft's SQL Server - Hadoop Connector
  5. 12/03/29 16:20:21 INFO manager.SqlManager: Using default fetchSize of 1000
  6. 12/03/29 16:20:21 INFO tool.CodeGenTool: Beginning code generation
  7. 12/03/29 16:20:21 INFO manager.SqlManager: Executing SQL statement: SELECT TOP 1 * FROM [tmptempmeasurereport]
  8. 12/03/29 16:20:21 INFO manager.SqlManager: Executing SQL statement: SELECT TOP 1 * FROM [tmptempmeasurereport]
  9. 12/03/29 16:20:21 INFO orm.CompilationManager: HADOOP_HOME is /home/hadoop/hadoop-0.20.2-cdh3u2
  10. 12/03/29 16:20:22 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-hadoop/compile/1c5aae88cd7daca66aa665d4bab5b470/tmptempmeasurereport.jar
  11. 12/03/29 16:20:22 INFO mapreduce.ExportJobBase: Beginning export of tmptempmeasurereport
  12. 12/03/29 16:20:22 INFO manager.SqlManager: Executing SQL statement: SELECT TOP 1 * FROM [tmptempmeasurereport]
  13. 12/03/29 16:20:22 WARN mapreduce.ExportJobBase: IOException checking SequenceFile header: java.io.EOFException
  14. 12/03/29 16:20:23 INFO input.FileInputFormat: Total input paths to process : 2
  15. 12/03/29 16:20:23 INFO input.FileInputFormat: Total input paths to process : 2
  16. 12/03/29 16:20:23 INFO mapred.JobClient: Running job: job_201203291108_0645
  17. 12/03/29 16:20:24 INFO mapred.JobClient: map 0% reduce 0%
  18. 12/03/29 16:20:29 INFO mapred.JobClient: Task Id : attempt_201203291108_0645_m_000000_0, Status : FAILED
  19. java.util.NoSuchElementException
  20. at java.util.AbstractList$Itr.next(AbstractList.java:350)
  21. at tmptempmeasurereport.__loadFromFields(tmptempmeasurereport.java:383)
  22. at tmptempmeasurereport.parse(tmptempmeasurereport.java:332)
  23. at com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:79)
  24. at com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:38)
  25. at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
  26. at com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:187)
  27. at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
  28. at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
  29. at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
  30. at java.security.AccessController.doPrivileged(Native Method)
  31. at javax.security.auth.Subject.doAs(Subject.java:396)
  32. at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
  33. at org.apache.hadoop.mapred.Child.main(Child.java:264)
  34.  
  35. 12/03/29 16:20:34 INFO mapred.JobClient: Task Id : attempt_201203291108_0645_m_000000_1, Status : FAILED
  36. java.util.NoSuchElementException
  37. at java.util.AbstractList$Itr.next(AbstractList.java:350)
  38. at tmptempmeasurereport.__loadFromFields(tmptempmeasurereport.java:383)
  39. at tmptempmeasurereport.parse(tmptempmeasurereport.java:332)
  40. at com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:79)
  41. at com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:38)
  42. at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
  43. at com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:187)
  44. at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
  45. at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
  46. at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
  47. at java.security.AccessController.doPrivileged(Native Method)
  48. at javax.security.auth.Subject.doAs(Subject.java:396)
  49. at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
  50. at org.apache.hadoop.mapred.Child.main(Child.java:264)
  51.  
  52. 12/03/29 16:20:38 INFO mapred.JobClient: Task Id : attempt_201203291108_0645_m_000000_2, Status : FAILED
  53. java.util.NoSuchElementException
  54. at java.util.AbstractList$Itr.next(AbstractList.java:350)
  55. at tmptempmeasurereport.__loadFromFields(tmptempmeasurereport.java:383)
  56. at tmptempmeasurereport.parse(tmptempmeasurereport.java:332)
  57. at com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:79)
  58. at com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:38)
  59. at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
  60. at com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:187)
  61. at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
  62. at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
  63. at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
  64. at java.security.AccessController.doPrivileged(Native Method)
  65. at javax.security.auth.Subject.doAs(Subject.java:396)
  66. at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
  67. at org.apache.hadoop.mapred.Child.main(Child.java:264)
  68.  
  69. 12/03/29 16:20:43 INFO mapred.JobClient: Job complete: job_201203291108_0645
  70. 12/03/29 16:20:43 INFO mapred.JobClient: Counters: 7
  71. 12/03/29 16:20:43 INFO mapred.JobClient: Job Counters
  72. 12/03/29 16:20:43 INFO mapred.JobClient: SLOTS_MILLIS_MAPS=18742
  73. 12/03/29 16:20:43 INFO mapred.JobClient: Total time spent by all reduces waiting after reserving slots (ms)=0
  74. 12/03/29 16:20:43 INFO mapred.JobClient: Total time spent by all maps waiting after reserving slots (ms)=0
  75. 12/03/29 16:20:43 INFO mapred.JobClient: Launched map tasks=4
  76. 12/03/29 16:20:43 INFO mapred.JobClient: Data-local map tasks=4
  77. 12/03/29 16:20:43 INFO mapred.JobClient: SLOTS_MILLIS_REDUCES=0
  78. 12/03/29 16:20:43 INFO mapred.JobClient: Failed map tasks=1
  79. 12/03/29 16:20:43 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 21.0326 seconds (0 bytes/sec)
  80. 12/03/29 16:20:43 INFO mapreduce.ExportJobBase: Exported 0 records.
  81. 12/03/29 16:20:43 ERROR tool.ExportTool: Error during export: Export job failed!
Add Comment
Please, Sign In to add comment