How to export selective data from HDFS/Hive to MySQL/DB2 using Sqoop
- qoop export --connect "jdbc:mysql://quickstart.cloudera:3306/retail_rpt_db" \
- --username retail_dba \
- --password cloudera \
- --table departments \
- --export-dir /user/hive/warehouse/retail_ods.db/departments \
- --input-fields-terminated-by '|' \
- --input-lines-terminated-by '