sqoop Connecting Sqoop to other databases/datastores Import the results of a query from a relational database into HDFS:
Example
Query can be used instead of table in import operation:
sqoop import --query 'select Id,Message from TestTable where $CONDITIONS'
--where 'id>100'
--connect "jdbc:sqlserver://192.168.1.100:1433;database=Test_db
--username user
-–password password
--split-by id
--target-dir /user/test/
--fields-terminated-by '\t'
- where $CONDITIONS - mandatory even if where condition does not exist
- split-by - mandatory, specifies the column for the split operation. Used to split tasks in import MapReduce job
