无法使用sqoop导入mysql数据库

zqdjd7g9  于 2021-06-01  发布在  Hadoop
关注(0)|答案(0)|浏览(315)

我使用mysql创建了一个名为'dz'的数据库,其中有两个表。然后我尝试使用apachesqoop导入表。我得到以下错误。

Warning: /usr/local/hadoop/sqoop/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /usr/local/hadoop/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/local/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/hadoop/hbase/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
17/11/30 15:47:40 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
17/11/30 15:47:40 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/11/30 15:47:40 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
17/11/30 15:47:40 INFO tool.CodeGenTool: Beginning code generation
17/11/30 15:47:40 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `sqoop_import` AS t LIMIT 1
17/11/30 15:47:40 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Base table or view not found message from server: "Table 'dz.sqoop_import' doesn't exist"
java.sql.SQLException: Base table or view not found message from server: "Table 'dz.sqoop_import' doesn't exist"
....

有人能帮我修一下吗?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题