cherry_202 2021-02-14 17:26 采纳率: 72%
浏览 440
已结题

FileNotFoundException: File does not exist

ubuntu 用sqoop将数据从hive导入mysql时,命令:

  1. cd /usr/local/sqoop
  2. bin/sqoop export --connect jdbc:mysql://localhost:3306/dbtaobao --username root -P root --table user_log --export-dir '/user/hive/warehouse/dbtaobao.db/inner_user_log' --fields-terminated-by ',';结果显示:

    Warning: /usr/local/sqoop/../accumulo does not exist! Accumulo imports will fail.

    Please set $ACCUMULO_HOME to the root of your Accumulo installation.

    Warning: /usr/local/sqoop/../zookeeper does not exist! Accumulo imports will fail.

    Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation.

    21/02/14 17:21:44 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6

    Enter password:

    21/02/14 17:21:45 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.

    21/02/14 17:21:45 INFO tool.CodeGenTool: Beginning code generation

    21/02/14 17:21:46 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `user_log` AS t LIMIT 1

    21/02/14 17:21:46 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `user_log` AS t LIMIT 1

    21/02/14 17:21:46 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/local/hadoop

    注: /tmp/sqoop-hadoop/compile/716352b8f5fd8b50d5e58683cd97b340/user_log.java使用或覆盖了已过时的 API。

    注: 有关详细信息, 请使用 -Xlint:deprecation 重新编译。

    21/02/14 17:21:49 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-hadoop/compile/716352b8f5fd8b50d5e58683cd97b340/user_log.jar

    21/02/14 17:21:49 INFO mapreduce.ExportJobBase: Beginning export of user_log

    21/02/14 17:21:50 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar

    21/02/14 17:21:52 INFO Configuration.deprecation: mapred.reduce.tasks.speculative.execution is deprecated. Instead, use mapreduce.reduce.speculative

    21/02/14 17:21:52 INFO Configuration.deprecation: mapred.map.tasks.speculative.execution is deprecated. Instead, use mapreduce.map.speculative

    21/02/14 17:21:52 INFO Configuration.deprecation: mapred.job.tracker is deprecated. Instead, use mapreduce.jobtracker.address

    21/02/14 17:21:52 INFO Configuration.deprecation: session.id is deprecated. Instead, use dfs.metrics.session-id

    21/02/14 17:21:52 INFO jvm.JvmMetrics: Initializing JVM Metrics with processName=JobTracker, sessionId=

    21/02/14 17:21:53 INFO mapreduce.JobSubmitter: Cleaning up the staging area file:/usr/local/hadoop/tmp/mapred/staging/hadoop765752367/.staging/job_local765752367_0001

    21/02/14 17:21:53 ERROR tool.ExportTool: Encountered IOException running export job: java.io.FileNotFoundException: File does not exist: hdfs://localhost:9000/usr/local/sqoop/lib/parquet-avro-1.4.1.jar

  • 写回答

1条回答 默认 最新

  • SoftwareTeacher 《编程之美》作者 2021-02-15 14:40
    关注
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

问题事件

  • 系统已结题 9月11日
  • 已采纳回答 9月3日

悬赏问题

  • ¥20 keepalive配置业务服务双机单活的方法。业务服务一定是要双机单活的方式
  • ¥50 关于多次提交POST数据后,无法获取到POST数据参数的问题
  • ¥15 win10,这种情况怎么办
  • ¥15 如何在配置使用Prettier的VSCode中通过Better Align插件来对齐等式?(相关搜索:格式化)
  • ¥100 在连接内网VPN时,如何同时保持互联网连接
  • ¥15 MATLAB中使用parfor,矩阵Removal的有效索引在parfor循环中受限制
  • ¥20 Win 10 LTSC 1809版本如何无损提升到20H1版本
  • ¥50 win10 LTSC 虚拟键盘不弹出
  • ¥30 微信小程序请求失败,网页能正常带锁访问
  • ¥15 Matlab求解微分方程,如何用fish2d进行预优?