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