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.

Sqoop Duplicates Exadata Golden Gate

Sqoop Duplicates Exadata Golden Gate

New Contributor

I'm having a weird issue with sqoop/oraoop. When i am importing tables from oracle exadata I have duplicated rows only in the tables where the rows are updated/inserted very fast (golden gate replication) in the others table the import process is normal. Some one can help me please?

 

sqoop import \
--direct \
--connect jdbc:oracle:thin:@//******** \
--username username \
--password password \
--table schema.table \
--delete-target-dir \
--target-dir /path/landing/ \
--hive-delims-replacement '' \
--fields-terminated-by '|' \
--as-textfile \
--m 20 \

 

Thank you all!

2 REPLIES 2
Highlighted

Re: Sqoop Duplicates Exadata Golden Gate

Guru
@aleesmin ,

Couple of questions:

1. I am not familiar with golden gate , but are those inserts and updates run inside transactions?
2. have you checked if the duplicate data in the same resulted text file in HDFS or on different files?
3. I see that you used "--direct", have you tried non-direct mode?

Cheers
Eric
Highlighted

Re: Sqoop Duplicates Exadata Golden Gate

New Contributor

Hey- Did this issue got solved?

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