You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

This document is a collection of examples of Sqoop commands and arguments that are commonly used together. Its a good starting place for those overwhelmed by all the Sqoop configuration options and want to start exploring with something tried and true.

Exporting data from CSV file to Teradata:

Note: Teradata connector is required.

 sqoop export --connect jdbc:teradata://terahost/DATABASE=MYDB     --username myuser   --password mypass     --export-dir /user/hive/warehouse/mydb.db/data_stg    
--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
  • No labels