THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Note: Teradata connector is required.
sqoopsqoop 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 ','
...
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
...
Sqoop does not have a notion of custom schemas. You need to specify the parameter --schema with a schema name if your table is stored in a different schema. Please note that the Hive schema must have the same name as the Postgres one. The --schema parameter must be separated from the rest of the parameters with an extra set of dashes (i.e. -- ) and the --schema parameter must come last.
sqoop export --connect jdbc:postgresql://postgresql.example.com/database --username sqoop --password sqoop --table cities --export-dir cities -- \
--schema us