Please enable JavaScript.
Coggle requires JavaScript to display documents.
Sqoop (Cautions (Destination Directory (Target Directory (…
Sqoop
Cautions
1) Dont use "localhost" as connect string for distribured cluster as Local nodes cannot connect to The required DB
use the full hostname or IP address of the database host
-
-
Always Specify the Target-dir when using - - Split-by command [As this is free form import by some way]
When using free form query specify the $Conditions in the Query for sqoop to infer query and get results back on Maptasks
-
To preserve Null value in Hive use the - - null - string and
-
-
-
$Condtions
To generate "query conditions" equally for all the mappers
ex:- select from boo where id > 10 and <20 - Mapper1
select from boo where id > 20 and <40 - Mapper2
mysql-connector-java-5.1.31.jar, it is compatable with sqoop 1.4.5.
-
-