Advertisement
Guest User

Untitled

a guest
Jun 13th, 2016
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. --query "SELECT $query_select FROM $table where $CONDITIONS"
  2.  
  3. --boundary-query "select 176862848, 172862848"
  4.  
  5. 16/06/13 14:24:44 INFO tool.ImportTool: Lower bound value: 170581647
  6. 16/06/13 14:24:44 INFO tool.ImportTool: Upper bound value: 172909234
  7.  
  8. sqoop-import -fs hdfs://xxxxxxxxx/ -D mapreduce.map.java.opts=" -Duser.timezone=Europe/Paris" -m $nodes_number
  9. --connect jdbc:mysql://$server:$port/$database --username $username --password $password
  10. --target-dir $destination_dir --boundary-query "select 176862848, 172862848"
  11. --incremental append --check-column $id_column_name --last-value $last_value
  12. --split-by $id_column_name --query "SELECT $query_select FROM $table where $CONDITIONS"
  13. --fields-terminated-by , --escaped-by \ --enclosed-by '"'
  14.  
  15. --incremental append --check-column $id_column_name --last-value $last_value
  16.  
  17. --boundary-query "select 176862848, 172862848 from tablename limit 1"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement