Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

please help with this sqoop errror

Master Collaborator

the command and error are as follows: I have the jar file present in the directory and the JAVA_HOME path is set .

sqoop job --create incjob2 -- import --connect "jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=patronQA)(port=1526))(connect_data=(service_name=patron)))" --username PATRON --hive-import --hive-table pa_lane_txn --check-column TXN_PROCESS_DATE --incremental lastmodified  --merge-key TXN_ID --table PATRON.TAB1 --columns 'TXN_ID,TXN_PROCESS_DATE,TRANSP_ID,TRANSP_CLASS,EXT_PLAZA_ID,EXT_LANE_ID,EXT_LANE_TYPE_CODE,EXT_DATE_TIME,TRANSP_CUR_BAL,AVC_CLASS,TOLL_AMT_CHARGED,TOLL_AMT_COLLECTED,TOLL_AMT_FULL,CREDIT_LIST_UPDATE_FLAG,TRANS_SOURCE,REVCLASS_REV_CLASS_CODE,PAYMENT_METHOD_CODE,ENT_PLAZA_ID,ENT_DATE_TIME,ENT_LANE_ID,ENT_LANE_TYPE_CODE,AGENCY_REJECT_CODE,MSG_ID,TRANSP_INTERNAL_NUM,UFM_PAYMENT_CODE,VEH_LIC_NUM,STATE_ID_CODE,ORIG_TXN_ID'

error:

18/01/16 22:49:00 INFO mapreduce.ImportJobBase: Transferred 9.1112 MB in 175.8448 seconds (53.0577 KB/sec)
18/01/16 22:49:00 INFO mapreduce.ImportJobBase: Retrieved 54607 records.
18/01/16 22:49:00 INFO mapreduce.ImportJobBase: Publishing Hive/Hcat import job data to Listeners
18/01/16 22:49:00 INFO tool.ImportTool: Final destination exists, will run merge job.
18/01/16 22:49:00 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Could not load jar /tmp/sqoop-hdfs/compile/242e347c38648f646006f8c7405bb806/PATRON.TAB1.jar into JVM. (Could not find class PATRON.TAB1.)
1 REPLY 1

can you try keeping this parameter as well --driver oracle.jdbc.driver.oracledriver and try running it

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.