You have been given following MySQL database details as well as other info. username=cloudera password=cloudera database=retail_db jdbc URL = jdbc:mysql://localhost/retail_db output directory location is /user/cloudera/departments Please accomplish following by writing sqoop command. 1. import departments table into same directory (However, directory already exist hence it should not override and append the results) 2. Also make sure your results fields are terminated by '|'