API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2016
145
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.85 KB | None | 0 0
raw download clone embed print report
  1. hduser@master:/usr/local/sqoop/conf$ sqoop list-databases --connect "jdbc:mysql://kala:3306" --username **** --password ****
  2. Warning: /usr/local/sqoop/../hbase does not exist! HBase imports will fail.
  3. Please set $HBASE_HOME to the root of your HBase installation.
  4. Warning: /usr/local/sqoop/../hcatalog does not exist! HCatalog jobs will fail.
  5. Please set $HCAT_HOME to the root of your HCatalog installation.
  6. Warning: /usr/local/sqoop/../accumulo does not exist! Accumulo imports will fail.
  7. Please set $ACCUMULO_HOME to the root of your Accumulo installation.
  8. Warning: /usr/local/sqoop/../zookeeper does not exist! Accumulo imports will fail.
  9. Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation.
  10. 16/08/02 17:30:05 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5
  11. 16/08/02 17:30:05 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
  12. 16/08/02 17:30:05 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  13. information_schema
  14. employees
  15. mysql
  16. performance_schema
  17. sys
  18. world
  19. hduser@master:/usr/local/sqoop/conf$
  20.  
  21. hduser@master:/usr/local/sqoop/conf$ sqoop list-tables --connect "jdbc:mysql://kala:3306/world" --username ****--password ****
  22. Warning: /usr/local/sqoop/../hbase does not exist! HBase imports will fail.
  23. Please set $HBASE_HOME to the root of your HBase installation.
  24. Warning: /usr/local/sqoop/../hcatalog does not exist! HCatalog jobs will fail.
  25. Please set $HCAT_HOME to the root of your HCatalog installation.
  26. Warning: /usr/local/sqoop/../accumulo does not exist! Accumulo imports will fail.
  27. Please set $ACCUMULO_HOME to the root of your Accumulo installation.
  28. Warning: /usr/local/sqoop/../zookeeper does not exist! Accumulo imports will fail.
  29. Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation.
  30. 16/08/02 17:31:46 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5
  31. 16/08/02 17:31:46 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
  32. 16/08/02 17:31:47 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  33. City
  34. Country
  35. CountryLanguage
  36. hduser@master:/usr/local/sqoop/conf$ sqoop import-all-tables --connect "jdbc:mysql://kala:3306/world" --username ****--password ****
  37. Warning: /usr/local/sqoop/../hbase does not exist! HBase imports will fail.
  38. Please set $HBASE_HOME to the root of your HBase installation.
  39. Warning: /usr/local/sqoop/../hcatalog does not exist! HCatalog jobs will fail.
  40. Please set $HCAT_HOME to the root of your HCatalog installation.
  41. Warning: /usr/local/sqoop/../accumulo does not exist! Accumulo imports will fail.
  42. Please set $ACCUMULO_HOME to the root of your Accumulo installation.
  43. Warning: /usr/local/sqoop/../zookeeper does not exist! Accumulo imports will fail.
  44. Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation.
  45. 16/08/02 17:32:34 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5
  46. 16/08/02 17:32:34 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
  47. 16/08/02 17:32:34 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  48. 16/08/02 17:32:35 INFO tool.CodeGenTool: Beginning code generation
  49. 16/08/02 17:32:35 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `City` AS t LIMIT 1
  50. 16/08/02 17:32:35 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `City` AS t LIMIT 1
  51. 16/08/02 17:32:35 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/local/hadoop
  52. Note: /tmp/sqoop-hduser/compile/706b5388186e76e8e2b05403a16cb607/City.java uses or overrides a deprecated API.
  53. Note: Recompile with -Xlint:deprecation for details.
  54. 16/08/02 17:32:38 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-hduser/compile/706b5388186e76e8e2b05403a16cb607/City.jar
  55. 16/08/02 17:32:38 WARN manager.MySQLManager: It looks like you are importing from mysql.
  56. 16/08/02 17:32:38 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
  57. 16/08/02 17:32:38 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
  58. 16/08/02 17:32:38 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
  59. 16/08/02 17:32:38 INFO mapreduce.ImportJobBase: Beginning import of City
  60. 16/08/02 17:32:38 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
  61. 16/08/02 17:32:38 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar
  62. 16/08/02 17:32:39 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps
  63. 16/08/02 17:32:39 INFO client.RMProxy: Connecting to ResourceManager at master/192.168.1.51:8050
  64. 16/08/02 17:32:43 INFO db.DBInputFormat: Using read commited transaction isolation
  65. 16/08/02 17:32:43 INFO mapreduce.JobSubmitter: Cleaning up the staging area /tmp/hadoop-yarn/staging/hduser/.staging/job_1470138335048_0001
  66. Exception in thread "main" java.lang.IncompatibleClassChangeError: Found interface org.apache.hadoop.mapreduce.JobContext, but class was expected
  67. at org.apache.sqoop.config.ConfigurationHelper.getJobNumMaps(ConfigurationHelper.java:53)
  68. at com.cloudera.sqoop.config.ConfigurationHelper.getJobNumMaps(ConfigurationHelper.java:36)
  69. at org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:121)
  70. at org.apache.hadoop.mapreduce.JobSubmitter.writeNewSplits(JobSubmitter.java:301)
  71. at org.apache.hadoop.mapreduce.JobSubmitter.writeSplits(JobSubmitter.java:318)
  72. at org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:196)
  73. at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1290)
  74. at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1287)
  75. at java.security.AccessController.doPrivileged(Native Method)
  76. at javax.security.auth.Subject.doAs(Subject.java:422)
  77. at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
  78. at org.apache.hadoop.mapreduce.Job.submit(Job.java:1287)
  79. at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:1308)
  80. at org.apache.sqoop.mapreduce.ImportJobBase.doSubmitJob(ImportJobBase.java:186)
  81. at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:159)
  82. at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:247)
  83. at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:665)
  84. at org.apache.sqoop.manager.MySQLManager.importTable(MySQLManager.java:118)
  85. at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:497)
  86. at org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:105)
  87. at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
  88. at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
  89. at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
  90. at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
  91. at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
  92. at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
  93. hduser@master:/usr/local/sqoop/conf$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!