Support Questions
Find answers, ask questions, and share your expertise

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

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

Re: Sqoop Duplicates Exadata Golden Gate

New Contributor

Hey- Did this issue got solved?