sqoop的import all表不工作

abithluo  于 2021-06-03  发布在  Sqoop
关注(0)|答案(1)|浏览(433)

嗨,我正在尝试将所有表从所有架构从oracledb导入hdfs。
这是我的剧本:
sqoop import all tables-dmapreduce.job.user.classpath.first=true-dhadoop.security.credential.provider.path=jceks://x.jceks --connect jdbc:oracle:thin:@x.x.x.x:1521/yyyy--用户名x--密码x--仓库目录/数据仓库/x--作为avrodatafile--压缩编解码器snappy--自动重置为一个Map器
当我运行这个脚本时,没有得到任何错误,也没有任何作业正在启动。
输出:

Warning: /usr/hdp/2.6.2.0-205/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
find: failed to restore initial working directory: Permission denied
18/08/11 08:32:51 INFO sqoop.Sqoop: Running**Sqoop version: 1.4.6.2.6.2.0-205**
18/08/11 08:32:51 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
18/08/11 08:32:51 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.
18/08/11 08:32:51 INFO manager.SqlManager: Using default fetchSize of 1000
18/08/11 08:32:53 INFO manager.OracleManager: Time zone has been set to IST
6rqinv9w

6rqinv9w1#

在sqoop中配置的用户似乎没有足够的权限从oracle查询和导出数据。请选中“从命令行连接并查询到oracle数据库”。
当做!!!

相关问题