Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> create database hadoop;
- Query OK, 1 row affected (0.08 sec)
- mysql> use hadoop;
- Database changed
- mysql> CREATE TABLE pet (id int, name VARCHAR(20));
- Query OK, 0 rows affected (0.11 sec)
- mysql> insert into pet values (1,'anurag');
- Query OK, 1 row affected (0.00 sec)
- mysql> insert into pet values (2,'test');
- Query OK, 1 row affected (0.00 sec)
- mysql> insert into pet values (3,'user');
- Query OK, 1 row affected (0.00 sec)
- First Import -
- sqoop import \
- --connect jdbc:mysql://localhost/hadoop \
- --username root -P \
- --table pet \
- --m 1 \
- --target-dir /sqoop-bosch
- mysql> insert into pet values (4,'user4');
- Query OK, 1 row affected (0.14 sec)
- mysql> insert into pet values (5,'user5');
- Query OK, 1 row affected (0.07 sec)
- $ sqoop import \
- --connect jdbc:mysql://localhost/hadoop \
- --username root -P \
- --table pet \
- --m 1 \
- --target-dir /sqoop-bosch \
- --incremental append \
- --check-column id \
- --last-value 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement