Advertisement
Guest User

Untitled

a guest
Jan 12th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. mysql> create database hadoop;
  2. Query OK, 1 row affected (0.08 sec)
  3.  
  4. mysql> use hadoop;
  5. Database changed
  6. mysql> CREATE TABLE pet (id int, name VARCHAR(20));
  7. Query OK, 0 rows affected (0.11 sec)
  8.  
  9. mysql> insert into pet values (1,'anurag');
  10. Query OK, 1 row affected (0.00 sec)
  11.  
  12. mysql> insert into pet values (2,'test');
  13. Query OK, 1 row affected (0.00 sec)
  14.  
  15. mysql> insert into pet values (3,'user');
  16. Query OK, 1 row affected (0.00 sec)
  17.  
  18. First Import -
  19. sqoop import \
  20. --connect jdbc:mysql://localhost/hadoop \
  21. --username root -P \
  22. --table pet \
  23. --m 1 \
  24. --target-dir /sqoop-bosch
  25.  
  26. mysql> insert into pet values (4,'user4');
  27. Query OK, 1 row affected (0.14 sec)
  28.  
  29. mysql> insert into pet values (5,'user5');
  30. Query OK, 1 row affected (0.07 sec)
  31.  
  32. $ sqoop import \
  33. --connect jdbc:mysql://localhost/hadoop \
  34. --username root -P \
  35. --table pet \
  36. --m 1 \
  37. --target-dir /sqoop-bosch \
  38. --incremental append \
  39. --check-column id \
  40. --last-value 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement