sqoop - sqoop Import RDBMS Table to HDFS - apache sqoop - sqoop tutorial - sqoop hadoop
sqoop Import RDBMS Table to HDFS
sqoop import \
--connect <rdbms-jdbc-url> \
--username <username> \
--password <password> \
--table <table-name>
Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team
sqoop import \
--connect jdbc:mysql://mysql.example.com/testdb \
--username root \
--password root \
--table employees
Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team
hadoop fs -cat <hdfs-home-dir>/employees/part-m-*
Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team
sqoop import \
--connect jdbc:mysql://mysql.example.com/testdb \
--username root \
--password root \
--table emplyoees \
--target-dir /dev/data/employees
Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team
sqoop import \
--connect jdbc:mysql://mysql.example.com/testdb \
--username root \
--password root \
--table emplyoees \
--warehouse-dir /dev/warehouse/
Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team
Import subset of RDBMS Table to HDFS
sqoop import \
--connect <rdbms-jdbc-url> \
--username <username> \
--password <password> \
--table <table-name> \
--where "<condition>"
Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team
sqoop import \
--connect jdbc:mysql://mysql.example.com/testdb \
--username root \
--password root \
--table employees \
--where "country = 'INDIA'"
Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team
Using Free Form Query
sqoop import \
--connect <rdbms-jdbc-url> \
--username <username> \
--password <password> \
--query <sql-query> \
--target-dir <target-dir>