sqoop 并行读取oracle

报错信息

2020-06-19 16:57:44: ==〇^^^L\ = =
Sqoop执行不成功！
Warning: /usr/hdp/2.5.3.0-37/accumulo does not exist! Accumulo imports will
fail.
Please set SACCUMULO_HOME to the root of your Accumulo installation.
20/06/19 16:57:42 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
20/06/19 16:57:42 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
20/06/19 16:57:43 WARN oracle.OraOopManagerFactory: Unable to determine
the Oracle-type of the object named table123 owned by DATABASE123.
Error:
ORA-00942: table or view does not exist
20/06/19 16:57:43 WARN oracle.OraOopManagerFactory: Unable to determine
whether the Oracle table "DATABASE123."table123 is an index-organized table.
Error:
ORA-00942: table or view does not exist
20/06/19 16:57:43 INFO oracle.OraOopManagerFactory:

---

*** Using Data Connector for Oracle and Hadoop ***

原因

oracle 没有开启并行读取权限

开启oracle并行权限

grant create session to sqooptest;
grant alter session to sqooptest;
grant select on v_$instance to sqooptest;
grant select on dba_tables to sqooptest;
grant select on dba_tab_columns to sqooptest;
grant select on dba_objects to sqooptest;
grant select on dba_extents to sqooptest;
grant select on dba_segments to sqooptest;
grant select on dba_constraints to sqooptest;
grant select on v_$database to sqooptest;
grant select on v_$parameter to sqooptest;
grant select on v_$session to sqooptest;
grant select on v_$sql to sqooptest;