Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sqoop job -libjars /path/to/lib/tdgssconfig.jar,/path/to/lib/terajdbc4.jar --create job_id1 -- import --driver "com.teradata.jdbc.TeraDriver" --connection-manager "org.apache.sqoop.manager.GenericJdbcManager" --connect jdbc:teradata://xxxxxxx/DATABASE=xxxxx --username xxxx --password-file /tmp/sqoop/7b99fe83d035aadcbc4e8e7d2a54989e-30596-asdfg.txt --fetch-size 20000 --query 'select * FROM DATABASE.TABLE WHERE cast(EXP_DTE AS INT) = 80991231 AND $CONDITIONS' --hive-drop-import-delims --null-string "" --target-dir /tmp/sqoop/location1 --num-mappers 1 --check-column EFF_DTE --incremental append --last-value "1600-01-01" --fields-terminated-by "