天天看點

[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'