Tutorial by Examples

sqoop import \ --connect <rdbms-jdbc-url> \ --username <username> \ --password <password> \ --table <table-name> Example with Mysql: sqoop import \ --connect jdbc:mysql://mysql.example.com/testdb \ --username root \ --password root \ --table employees CSV file ...

Using --where tag sqoop import \ --connect <rdbms-jdbc-url> \ --username <username> \ --password <password> \ --table <table-name> \ --where "<condition>" Example with Mysql: sqoop import \ --connect jdbc:mysql://mysql.example.com/testdb \ --userna...

SQOOP provides facility to import all tables sqoop import-all-tables \ --connect <rdbms-jdbc-url> \ --username <username> \ --password <password> \ --hive-import \ --create-hive-table \ --hive-database <dbname> \ --warehouse-dir <warehouse-dir> Important poin...