Sqoop1: commands - import
Sqoop1: commands -- import
Import
import --connect jdbc:mysql://192.168.122.1:3306/sample
--username zhj --password 123456
--table actor
--columns "id, name, birthday"
--where "id>40"
--m 3
--target-dir /user/zhj/sqoop/actor // or --warehouse-dir /user/zhj/sqoop
import --query 'SELECT a.*, b.* FROM a JOIN b on (a.id == b.id) WHERE $CONDITIONS'
--split-by a.id --target-dir /user/foo/joinresults