[SQOOP-1388] One of Export scenario fails with an error : java.sql.SQLException: Unable to perform an "exchange subpartition" operation for the table ...

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved

Environment

" sqoop-1.4.5-SNAPSHOT.bin__hadoop-2.0.4-alpha.tar.gz " on CDH4 (melhadoop 01).

• Assignee: David Robson
• Reporter: Vidya Iyengar
• Created: 17/Jul/14 23:38
• Updated: 23/Jul/14 14:37

Description

Ran Export Scenario 13 from the Guy Ley Mar document on SASDB01.

These are the steps I followed for CASE 13.

drop table junk;
drop table junk13;
create table junk as select * from dba_objects;

sqoop import --direct --connect jdbc:oracle:thin:@melsasdb01:1521:sasdb01 --username oraoop --password oraoop --table junk --where "OBJECT_ID<100" --target-dir junk_a

sqoop import --direct --connect jdbc:oracle:thin:@melsasdb01:1521:sasdb01 --username oraoop --password oraoop --table junk --where "OBJECT_ID>= 100 and OBJECT_ID < 200" --target-dir junk_b

sqoop export -D oraoop.drop.table=true -Doraoop.template.table=oraoop.junk -Doraoop.nologging=true -Doraoop.partitioned=true -Doraoop.export.merge=false --direct --connect jdbc:oracle:thin:@melsasdb01:1521:sasdb01 --username oraoop --password oraoop --table junk13 --export-dir junk_a

sqoop export -Doraoop.export.merge=false --direct --connect jdbc:oracle:thin:@melsasdb01:1521:sasdb01 --username oraoop --password oraoop --table junk13 --export-dir junk_b

Note: Failed when i ran the first export.
On the Hadoop file system, only one file contains data remaining 3 files are with size 0.
Removing empty files export worked ok.
Imported folders are available junk_a_bug , junk_b_bug for debugging.

Attached file contains the output error.