Vidya Iyengar created SQOOP-1388:
------------------------------------
Summary: One of Export scenario fails with an error :
java.sql.SQLException: Unable to perform an "exchange subpartition" operation
for the table ...
Key: SQOOP-1388
URL: https://issues.apache.org/jira/browse/SQOOP-1388
Project: Sqoop
Issue Type: Bug
Environment: " sqoop-1.4.5-SNAPSHOT.bin__hadoop-2.0.4-alpha.tar.gz "
on CDH4 (melhadoop 01).
Reporter: Vidya Iyengar
Assignee: David Robson
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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
