Sqoop调用存储过程

Sqoop 调用存储过程小编这几天一直在尝试用sqoop直接调用oracle里面的存储过程,玩了2天都没有搞定,一直尝试用 export里面的 call命令去调用存储过程,我需要实现的就是在同步数据之前先将oracle里面这张表的数据清空,在同步.总是出这个错误,这个我在dual表里面放了一条记录，还是不行，对于这个call的用户一直没有得到很好的解决，

​sqoop export --connect jdbc:oracle:thin:@d3epcis.dbdev.paic.com.cn:1526:d3epcis  --call "APPMGR.PKG_TRUNCATE.TRUNCATE_TABLE(pi_table_owner => 'EPCISUDWR',pi_table_name=>'SE_REF_PECCANCY_INFO_EVEN',pi_part_name => null)" --username epciscde --password cde6953 --input-fields-terminated-by '\001' --input-lines-terminated-by '\n' --export-dir /user/hive/warehouse/gbd_dm_pac_safe.db/dual

日志16/03/16 16:38:20 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.16/03/16 16:38:20 INFO manager.SqlManager: Using default fetchSize of 100016/03/16 16:38:20 INFO tool.CodeGenTool: Beginning code generation16/03/16 16:38:24 INFO manager.OracleManager: Time zone has been set to GMT16/03/16 16:38:29 ERROR tool.ExportTool: Encountered IOException running export job: java.io.IOException: No columns to generate for ClassWriter

突然查看sqoop有一个eval 是直接用来执行SQL语句，这个里面有一个—query的参数在，这个一般大家都说写SQL语句，这个地方可以直接写调用存储过程的，格式是

sqoop eval --connect jdbc:oracle:thin:@d3epcis.dbdev.paic.com.cn:1526:d3epcis --username epciscde --password cde6953 --query "begin appmgr.pkg_truncate.truncate_table(pi_table_owner => 'EPCISUDWR',pi_table_name => 'SE_REF_PECCANCY_INFO_EVEN',pi_part_name => null); end; "

运行结果：

 [hduser0102@dev-l002782 sqoop-config]$ sqoop eval \> --connect jdbc:oracle:thin:@d3epcis.dbdev.paic.com.cn:1526:d3epcis \> --username epciscde \> --password cde6953 \> --query "begin appmgr.pkg_truncate.truncate_table(pi_table_owner => 'EPCISUDWR',pi_table_name => 'SE_REF_PECCANCY_INFO_EVEN',pi_part_name => null); end; "

16/03/16 17:06:52 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.16/03/16 17:06:52 INFO manager.SqlManager: Using default fetchSize of 100016/03/16 17:06:54 INFO manager.OracleManager: Time zone has been set to GMT