用sqoop从Hive to Mysql导数

hive和mysql分别建表如下：

 

hive> desc grzx_base_info;

OK

name               string                                  

age                 int  

 

 

mysql> desc grzx_base_info;

+-------+-------------+------+-----+---------+-------+

| Field | Type        | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| name  | varchar(50) | YES  |     | NULL    |       |

| age   | int(11)     | YES  |     | NULL    |       |

+-------+-------------+------+-----+---------+-------+

 

 

 

获取hive表路径desc formatted grzx_base_info;

/user/hive/warehouse/fex.db/grzx_base_info

 

 

拼接sqoop命令

sqoop export --connect jdbc:mysql://localhost:3306/fex --username cloudera --password cloudera --table grzx_base_info --export-dir /user/hive/warehouse/fex.db/grzx_base_info --input-fields-terminated-by '\0001'

 

 

mysql查看数据结果

select * from grzx_base_info