如何将MySql表导入hive中的目标数据库？-HowtoimportMySqltableintoatargeteddatabaseinhive?

Import a MySQL table into Hive:

将MySQL表导入Hive:

sqoop import --connect jdbc:mysql://localhost:3306/mysqldatabase --table mysqltablename --username mysqlusername --password mysqlpassword --hive-import --hive-table hivedatabase.hivetablename --warehouse-dir /user/hive/warehouse

Changes to be made:

要做的更改:

mysqldatabase -- Your mysql database name from which the table is to be imported to hive.

mysqldatabase - 要将表导入到配置单元的mysql数据库名称。

mysqltablename -- Your mysql table name to be imported

mysqltablename - 要导入的mysql表名

mysqlusername and mysqlpassword -- mysql username and password respectively.

mysqlusername和mysqlpassword - 分别是mysql的用户名和密码。

hivedatabase -- Your hive database name

hivedatabase - 您的配置单元数据库名称

hivetablename -- Table name to be created in hive.

hivetablename - 要在配置单元中创建的表名。

Try this:

sqoop import --connect jdbc:mysql://ip_Address:port_no/MySQL_database_name --username user --password passwd --table tblSystem -m 1 --hive-import --hive-table myHiveImport.tblSystem --warehouse-dir /user/hive/warehouse

Change --warehouse-dir location to point to your HDFS hive storage path.

更改--warehouse-dir位置以指向您的HDFS配置单元存储路径。