sqoop import
–connect “jdbc:mysql://quickstart.cloudera:3306/retail_db”
–username retail_dba
–password cloudera
–table departments
–hive-home /user/hive/warehouse
–hive-import
–hive-overwrite
–hive-table sqoop_import.departments
–outdir java_files

sqoop import
–connect “jdbc:mysql://quickstart.cloudera:3306/retail_db”
–username retail_dba
–password cloudera
–table departments
–target-dir=/user/hive/warehouse/department_test
–append