天天看点

[Sqoop基础]-- sqoop导出hive表到mysql中

一、sqoop导出hive表到mysql中:

实现语句:

sqoop export --connect jdbc:mysql://ip:3306/application?characterEncoding=utf-8  --username root --password secret_password

 --table uv_info --export-dir   /user/hive/warehouse/origin_ennenergy_energytrade.db/m_bd_t_chang_status_h  --input-fields-terminated-by '\t'