API tools faq
paste
Guest User

sqoop error status 1

a guest
Apr 22nd, 2013
622
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 7.19 KB | None | 0 0
raw download clone embed print report
  1. 13/04/22 18:34:18 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `test` AS t LIMIT 1
  2. 13/04/22 18:34:19 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `test` AS t LIMIT 1
  3. 13/04/22 18:34:19 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /opt/hadoop/hadoop-1.0.4
  4. Note: /tmp/sqoop-diddy/compile/105d22e0b84d34c8700ab99121fe5ad6/test.java uses or overrides a deprecated API.
  5. Note: Recompile with -Xlint:deprecation for details.
  6. 13/04/22 18:34:19 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-diddy/compile/105d22e0b84d34c8700ab99121fe5ad6/test.jar
  7. 13/04/22 18:34:20 WARN manager.MySQLManager: It looks like you are importing from mysql.
  8. 13/04/22 18:34:20 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
  9. 13/04/22 18:34:20 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
  10. 13/04/22 18:34:20 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
  11. 13/04/22 18:34:20 INFO mapreduce.ImportJobBase: Beginning import of test
  12. 13/04/22 18:34:21 INFO mapred.JobClient: Running job: job_201304221824_0005
  13. 13/04/22 18:34:22 INFO mapred.JobClient:  map 0% reduce 0%
  14. 13/04/22 18:34:37 INFO mapred.JobClient:  map 100% reduce 0%
  15. 13/04/22 18:34:42 INFO mapred.JobClient: Job complete: job_201304221824_0005
  16. 13/04/22 18:34:42 INFO mapred.JobClient: Counters: 18
  17. 13/04/22 18:34:42 INFO mapred.JobClient:   Job Counters
  18. 13/04/22 18:34:42 INFO mapred.JobClient:     SLOTS_MILLIS_MAPS=12807
  19. 13/04/22 18:34:42 INFO mapred.JobClient:     Total time spent by all reduces waiting after reserving slots (ms)=0
  20. 13/04/22 18:34:42 INFO mapred.JobClient:     Total time spent by all maps waiting after reserving slots (ms)=0
  21. 13/04/22 18:34:42 INFO mapred.JobClient:     Launched map tasks=1
  22. 13/04/22 18:34:42 INFO mapred.JobClient:     SLOTS_MILLIS_REDUCES=0
  23. 13/04/22 18:34:42 INFO mapred.JobClient:   File Output Format Counters
  24. 13/04/22 18:34:42 INFO mapred.JobClient:     Bytes Written=72
  25. 13/04/22 18:34:42 INFO mapred.JobClient:   FileSystemCounters
  26. 13/04/22 18:34:42 INFO mapred.JobClient:     HDFS_BYTES_READ=87
  27. 13/04/22 18:34:42 INFO mapred.JobClient:     FILE_BYTES_WRITTEN=31031
  28. 13/04/22 18:34:42 INFO mapred.JobClient:     HDFS_BYTES_WRITTEN=72
  29. 13/04/22 18:34:42 INFO mapred.JobClient:   File Input Format Counters
  30. 13/04/22 18:34:42 INFO mapred.JobClient:     Bytes Read=0
  31. 13/04/22 18:34:42 INFO mapred.JobClient:   Map-Reduce Framework
  32. 13/04/22 18:34:42 INFO mapred.JobClient:     Map input records=7
  33. 13/04/22 18:34:42 INFO mapred.JobClient:     Physical memory (bytes) snapshot=88670208
  34. 13/04/22 18:34:42 INFO mapred.JobClient:     Spilled Records=0
  35. 13/04/22 18:34:42 INFO mapred.JobClient:     CPU time spent (ms)=990
  36. 13/04/22 18:34:42 INFO mapred.JobClient:     Total committed heap usage (bytes)=88670208
  37. 13/04/22 18:34:42 INFO mapred.JobClient:     Virtual memory (bytes) snapshot=999899136
  38. 13/04/22 18:34:42 INFO mapred.JobClient:     Map output records=7
  39. 13/04/22 18:34:42 INFO mapred.JobClient:     SPLIT_RAW_BYTES=87
  40. 13/04/22 18:34:42 INFO mapreduce.ImportJobBase: Transferred 72 bytes in 21.8767 seconds (3.2912 bytes/sec)
  41. 13/04/22 18:34:42 INFO mapreduce.ImportJobBase: Retrieved 7 records.
  42. 13/04/22 18:34:42 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `test` AS t LIMIT 1
  43. 13/04/22 18:34:42 INFO hive.HiveImport: Removing temporary files from import process: hdfs://localhost:9000/user/diddy/test/_logs
  44. 13/04/22 18:34:42 INFO hive.HiveImport: Loading uploaded data into Hive
  45. 13/04/22 18:34:43 INFO hive.HiveImport: WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
  46. 13/04/22 18:34:44 INFO hive.HiveImport: Logging initialized using configuration in jar:file:/opt/hadoop/hive-0.10.0/lib/hive-common-0.10.0.jar!/hive-log4j.properties
  47. 13/04/22 18:34:44 INFO hive.HiveImport: Hive history file=/tmp/diddy/hive_job_log_diddy_201304221834_1620199774.txt
  48. 13/04/22 18:34:44 INFO hive.HiveImport: Exception in thread "main" java.lang.NoSuchMethodError: org.apache.thrift.EncodingUtils.setBit(BIZ)B
  49. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.plan.api.Query.setStartedIsSet(Query.java:487)
  50. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.plan.api.Query.setStarted(Query.java:474)
  51. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.QueryPlan.updateCountersInQueryPlan(QueryPlan.java:304)
  52. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.QueryPlan.getQueryPlan(QueryPlan.java:437)
  53. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.QueryPlan.toString(QueryPlan.java:609)
  54. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.history.HiveHistory.logPlanProgress(HiveHistory.java:499)
  55. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1059)
  56. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.Driver.run(Driver.java:935)
  57. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
  58. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
  59. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
  60. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:347)
  61. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:445)
  62. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:455)
  63. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:711)
  64. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
  65. 13/04/22 18:34:44 INFO hive.HiveImport:     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  66. 13/04/22 18:34:44 INFO hive.HiveImport:     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  67. 13/04/22 18:34:44 INFO hive.HiveImport:     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  68. 13/04/22 18:34:44 INFO hive.HiveImport:     at java.lang.reflect.Method.invoke(Method.java:601)
  69. 13/04/22 18:34:44 INFO hive.HiveImport:     at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
  70. 13/04/22 18:34:44 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Hive exited with status 1
  71.     at org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:364)
  72.     at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:314)
  73.     at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:226)
  74.     at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:415)
  75.     at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
  76.     at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
  77.     at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
  78.     at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
  79.     at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
  80.     at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
  81.     at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!