07-08-2014 12:17 AM
I am trying to transfer data from Oracle into HDFS. I copied JDBC driver (ojdbc6.jar) into /var/lib/sqoop2 and also
/opt/cloudera/parcels/CDH-5.0.2-1.cdh5.0.2.p0.13/lib/sqoop2 for sure. But when I create job and start it, message - Error, could not start job is shown. I also tried to run job from CLI:
start job --jid 4
But got this message:
Exception has occurred during processing command Exception: org.apache.sqoop.common.SqoopException Message: CLIENT_0001:Server has returned exception
This error message doesn't help me, it is not too verbose. Do you know where the problem should be? Connection should be ok, and table and schema exists in oracle database. Here is connection and job info:
Job with id 4 and name Test job (Enabled: true, Created by rtomsej at 7/8/14 8:42 AM, Updated by rtomsej at 7/8/14 8:42 AM) Using Connection id 5 and Connector id 1 Database configuration Schema name: ibp Table name: open_nl_cnt Table SQL statement: Table column names: Partition column name: Nulls in partition column: true Boundary query: Output configuration Storage type: HDFS Output format: TEXT_FILE Compression format: NONE Output directory: /user/rtomsej/ibp Throttling resources Extractors: Loaders:
Connection with id 5 and name Oracle-Web (Enabled: true, Created by rtomsej at 7/8/14 8:41 AM, Updated by rtomsej at 7/8/14 8:53 AM) Using Connector id 1 Connection configuration JDBC Driver Class: oracle.jdbc.driver.OracleDriver JDBC Connection String: jdbc:oracle:thin:@localhost:1521 Username: localhost Password: JDBC Connection Properties: Security related configuration options Max connections:
We are using CDH5.0.2 with parcels.
07-08-2014 08:42 AM
Would you mind setting the verbosity option and running your job?
set option --name verbose --value true
Also, /var/log/sqoop2/sqoop.log should have errors. Could you please dig for any errors there and post them to this thread?
07-09-2014 07:23 AM
Thank you Abe, it seams that problem was missing partition columns. So I tried to add one column and job started. But it would be great to receive this information also from Hue.