Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

--table MYTABLE    --input-fields-terminated-by ','  

 

Merging data into Oracle with Oraoop:

 
sqoop export -Doraoop.export.merge=true -Doraoop.update.key.extra.columns="period_start_time" -D mapred.map.max.attempts=1  --connect ... --username user --password pass --table table2 --export-dir /user/hive/warehouse/tables/mytable  --verbose -m 16 --update-key co_gid