Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

please help with this sqoop errror

Highlighted

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

Re: please help with this sqoop errror

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

Don't have an account?
Coming from Hortonworks? Activate your account here