LIST OF SQOOP COMMANDS

1.sqoop-import --connect jdbc:mysql://localhost/srini -username root -password sql -table ran -m 1

2.sqoop-import --connect jdbc:mysql://localhost/srini -username root -password sql -table ran50 --where "name='nagu'" -m 1;

3.sqoop-import --connect jdbc:mysql://localhost/srini -username root -password sql -table ran50 --where "name='nagu'" --target-dir /nagu --append -m 1;

4.sqoop-import --connect jdbc:mysql://localhost/srini -username root -password sql -table ran50 --where "age>25" --target-dir /nagu1 -m 1;

5.sqoop-list-tables --connect jdbc:mysql://localhost/srini -username root -password sql

6.sqoop-list-databases --connect jdbc:mysql://localhost/srini -username root -password sql

7.sqoop-codegen --connect jdbc:mysql://localhost/srini --table ran90

8.sqoop-import --connect jdbc:mysql://localhost/srini -username root -password sql -table ran -columns name -m 1

9.sqoop-import --connect jdbc:mysql://localhost/srini -username root -password sql -table ran70 --as-sequencefile -m 1;

10.sqoop-import --connect jdbc:mysql://localhost/srini -username root -password sql -table ran80 --as-textfile -m 1;

11.sqoop export -connect jdbc:mysql://localhost/srini -table ranexport --export-dir /user/ranjith/ran --username root --password sql -m 1 --input-fields-terminated-by ','

12.sqoop-create-hive-table --connect jdbc:mysql://localhost/srini -username root -password sql --table ranexport --fields-terminated-by ','

13.sqoop import --connect jdbc:mysql://localhost/srini -username root -password sql --table ran2 --hive-import -m 1;

14.sqoop import --connect jdbc:mysql://localhost/srini -username root -password sql --table ran3 --hive-import --fields-terminated-by ',' -m 1;

15.sqoop export --connect jdbc:mysql://localhost/srini -username root -password sql --table ran65 --export-dir /user/hive/warehouse/ran3/part-m-00000_copy_2 --input-fields-terminated-by ',';

16.sqoop-import-all-tables --connect jdbc:mysql://localhost/srini -username root -password sql --hive-import -m1;

Reference link is:http://archive.cloudera.com/cdh/3/sqoop/SqoopUserGuide.html#_literal_sqoop_codegen_literal