I was trying to solve the following problem using sqoop import. The problem doesn’t have any requirement about boundary conditions or output-dir. but arun teaches blog solution has these two things as argument. boundary conditions argument, is it mandatory?
- Using sqoop, import products_replica table from MYSQL into hdfs such that fields are separated by a ‘|’ and lines are separated by ‘\n’. Null values are represented as -1 for numbers and “NOT-AVAILABLE” for strings. Only records with product id greater than or equal to 1 and less than or equal to 1000 should be imported and use 3 mappers for importing. The destination file should be stored as a text file to directory /user/cloudera/problem5/products-text .