Sqoop allows to Export and Import the data from the data table based on the where clause. The syntax is
--columns
<col1,col2……> --where
--query
Example:
sqoop import –connect jdbc:mysql://db.one.com/corp --table INTELLIPAAT_EMP --where “start_date> ’2016-07-20’ ”
sqoopeval --connect jdbc:mysql://db.test.com/corp --query “SELECT * FROM intellipaat_emp LIMIT 20”
sqoop import –connect jdbc:mysql://localhost/database --username root --password aaaaa –columns “name,emp_id,jobtitle”
Sqoop supports data imported into following services:
HDFS
- Hive
- Hbase
- Hcatalog
- Accumulo
