Advertisement
Guest User

Untitled

a guest
Mar 1st, 2016
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. 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 "01"
  2.  
  3. sqoop job -libjars /path/to/lib/tdgssconfig.jar,/path/to/lib/terajdbc4.jar --create job_id2 -- import --driver "com.teradata.jdbc.TeraDriver" --connection-manager "org.apache.sqoop.manager.GenericJdbcManager" --connect jdbc:teradata://xxxxxxx/DATABASE=xxxx --username xxxx --password-file /tmp/sqoop/7b99fe83d035aadcbc4e8e7d2a54989e-18578-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 "01"
  4.  
  5. nohup sh test1.sh > output1 2>&1 & nohup sh test2.sh > output2 2>&1 &
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement