Using Sqoop to import MySQL data into hive

Reference

Http://www.cnblogs.com/iPeng0564/p/3215055.html

Http://www.tuicool.com/articles/j2yayyj

http://blog.csdn.net/jxlhc09/article/details/16856873

1.list databases

Sqoop list-databases--connect jdbc:mysql://192.168.2.1:3306/--username sqoop--password sqoop

2. Create a hive table with Sqoop

Sqoop create-hive-table--connect jdbc:mysql://xx:3306/test?characterencoding=utf-8--table employee--userna Me Root-password ' xx '--hive-database db_hive_edu

3.import data

#sqoop Import--connect jdbc:mysql://xx:3306/test?characterencoding=utf-8--table employee--username Root-password ' xx '--fields-terminated-by ', '--hive-import--hive-database db_hive_edu-m 1

--fields-terminated-by ', ' causes data to become null

Sqoop import--connect jdbc:mysql://xx:3306/test?characterencoding=utf-8--username root-password ' xx '--table Employee--hive-import--hive-database db_hive_edu-m 1

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M00/9A/07/wKioL1lQh__waDjzAABs9h_1ukc926.png-wh_500x0-wm_ 3-wmp_4-s_219995857.png "style=" float:left; "title=" Sogou 20170626120236.png "alt=" Wkiol1lqh__wadjzaabs9h_ 1ukc926.png-wh_50 "/>

This article from "Want to have a dream, in case the realization of" blog, declined reprint!

Using Sqoop to import MySQL data into hive