Advertisement
Guest User

Untitled

a guest
Jul 16th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. | Oct-14 | 581 |
  2. | Nov-14 | 519 |
  3. | Dec-14 | 605 |
  4. | Jan-15 | 484 |
  5. | Feb-15 | 584 |
  6. | Mar-15 | 684 |
  7. Mar-15 684
  8.  
  9. sqoop job
  10. --create test13
  11. -- import
  12. --append
  13. --connect jdbc:mysql://localhost/tractor_sales --username root --P
  14. --query 'SELECT t.*,@rownum := @rownum + 1 AS rank FROM tractor_sales t,(SELECT @rownum := 0) r where $CONDITIONS'
  15. --split-by year
  16. --merge-key @rownum
  17. --check-column @rownum
  18. --hive-database salesforecast --hive-table tractor_sales
  19. --incremental append
  20. --last-value 0
  21. --hive-import
  22. --target-dir /user/cloudera/test;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement