Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2017
377
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.73 KB | None | 0 0
  1. sqoop job
  2. --create spacex_import_job -- import
  3. --connect jdbc:mysql://quickstart.cloudera:3306/spacex
  4. --driver com.mysql.jdbc.Driver --username root
  5. --password cloudera --table spacex_missions_w
  6. --hive-import --create-hive-table --hive-table spacex.missions_inc -m 1
  7. --check-column Record_TS --incremental lastmodified
  8. --last-value "2017-03-22 03:40:00"
  9.  
  10. sqoop job --exec spacex_import_job
  11.  
  12. job --exec spacex_import_job
  13.  
  14. 5238 [main] WARN org.apache.sqoop.tool.SqoopTool - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
  15. 5281 [main] INFO org.apache.sqoop.Sqoop - Running Sqoop version: 1.4.6-cdh5.8.0
  16. 6015 [main] ERROR org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage - Cannot restore job: spacex_import_job
  17. 6016 [main] ERROR org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage - (No such job)
  18. 6018 [main] ERROR org.apache.sqoop.tool.JobTool - I/O error performing job operation: java.io.IOException: Cannot restore missing job spacex_import_job
  19. at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.read(HsqldbJobStorage.java:256)
  20. at org.apache.sqoop.tool.JobTool.execJob(JobTool.java:198)
  21. at org.apache.sqoop.tool.JobTool.run(JobTool.java:268)
  22. at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
  23. at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
  24. at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
  25. at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
  26. at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
  27. at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
  28. at org.apache.oozie.action.hadoop.SqoopMain.runSqoopJob(SqoopMain.java:197)
  29. at org.apache.oozie.action.hadoop.SqoopMain.run(SqoopMain.java:177)
  30. at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:49)
  31. at org.apache.oozie.action.hadoop.SqoopMain.main(SqoopMain.java:46)
  32. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  33. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  34. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  35. at java.lang.reflect.Method.invoke(Method.java:606)
  36. at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:236)
  37. at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
  38. at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453)
  39. at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
  40. at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)
  41. at java.security.AccessController.doPrivileged(Native Method)
  42. at javax.security.auth.Subject.doAs(Subject.java:415)
  43. at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1693)
  44. at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement