Sqoop Notes

Sqoop Notes

Sqoop ALL tOPIC

sqoop import --connect jdbc:mysql://nn01.itversity.com/retail_db --username retail_dba -P --table sample --m 1 sqoop import --connect jdbc:mysql://nn01.itversity.com/retail_db --username retail_dba -P --table products --m 1 products mysql Details :=> mysql -u retail_dba -h nn01.itversity.com -p password :=> itversity sqoop import-all-tables --connect jdbc:mysql://nn01.itversity.com/retail_db --username retail_dba -P sqoop command --connect jdbc:url/database_name --username username -P sqoop,--connect,jdbc,--username and -P :=> flag command , url , database_name , usernmae :=> user give a.) All import multiple Tables (In Indivisual directory):=> sqoop import-all-tables --connect jdbc:mysql://nn01.itversity.com/retail_db --username retail_dba -P b.) All import multiple Tables (In One directory):=> sqoop import-all-tables --connect jdbc:mysql://nn01.itversity.com/retail_db --username retail_dba -P --warehouse-dir /user/aakashkumar/AllTables c.) Execulding Few Tables sqoop import-all-tables --connect jdbc:mysql://nn01.itversity.com/retail_db --username retail_dba -P --warehouse-dir /user/aakashkumar/fewtables --exclude-tables categories,customers,departments,order_items,orders ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1.) Sqoop - Export mysql -u retail_user -h ms.itversity.com -p use retail_export; sqoop export --connect jdbc:mysql://ms.itversity.com/retail_export --username retail_user --table test -P --export-dir /user/aakashkumar/datatomysql the data is present in same folder and File name is Sqoop_data