sqoop import --connect jdbc:mysql://localhost/Edureka --username root -P --query 'SELECT tab1.id,tab1.name,tab2.age FROM tab1 JOIN tab2 USING(id) WHERE $CONDITIONS' --split-by id --target-dir /user/hive/warehouse/jointab




Note: There are four output file has been created since there are four records including the two tables and the result will be two records.




199624