使用sqoop将数据传输到hdfs时出错

wwwo4jvm  于 2021-05-29  发布在  Hadoop
关注(0)|答案(1)|浏览(455)

我使用sqoop在hdfs和oracle之间传输数据,如下所示:

  1. hadoop@jiogis-cluster-jiogis-master-001:~$ sqoop import --connect jdbc:oracle:gis-scan.ril.com/SAT --username=r4g_viewer --password=viewer_123 --table=R4G_OSP.ENODEB --hive-import --hive-table=ENODEB --target-dir=user/hive/warehouse/proddb/JioCenterBoundary -- direct

当我使用如上所示的sqoop时,得到如下所示的错误

  1. Warning: /volumes/disk1/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hbase does not exist! HBase imports will fail.
  2. Please set $HBASE_HOME to the root of your HBase installation.
  3. Warning: /volumes/disk1/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hcatalog does not exist! HCatalog jobs will fail.
  4. Please set $HCAT_HOME to the root of your HCatalog installation.
  5. Warning: /volumes/disk1/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../accumulo does not exist! Accumulo imports will fail.
  6. Please set $ACCUMULO_HOME to the root of your Accumulo installation.
  7. 16/05/09 11:11:19 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
  8. 16/05/09 11:11:19 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
  9. 16/05/09 11:11:19 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
  10. 16/05/09 11:11:19 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
  11. 16/05/09 11:11:19 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.
  12. 16/05/09 11:11:19 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string: jdbc:oracle:gis-scan.ril.com/SAT
  13. at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:191)
  14. at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:256)
  15. at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:89)
  16. at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:593)
  17. at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
  18. at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
  19. at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
  20. at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
  21. at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
  22. at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
mec1mxoz

mec1mxoz1#

您的jdbc连接字符串看起来不正确。你能用这种格式试试吗:

  1. --connect jdbc:oracle:thin:@//hostname:port/servicename

在您的情况下,这可能是:

  1. --connect jdbc:oracle:thin:@//gis-scan.ril.com:1521/SAT

您可能需要再次检查端口号是否正确,因为扫描侦听器可能不在默认的1521端口上。

相关问题