Sqoop Command

1. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password 'root123' --table emp --m 1

2  sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password '' --table emp --target-dir /user/root/sqoop

2. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password '' --table emp --where "sex='f'"

3. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --table emp -P

4. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password '' --table emp --as-sequencefile

5. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password '' --table emp --as-avrodatafile

6. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password '' --table emp --compress

7. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password '' --table emp --direct

8. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password '' --table emp --map-column-java id=Long

9. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password '' --table emp --num-mappers 10

10. sqoop import --connect jdbc:mysql://localhost/sqoop --username root --password '' --table emp --null-string '\\N' \
--null-non-string '\\N'

11. sqoop import-all-tables --connect jdbc:mysql://localhost/sqoop --username root --password ''