question Re: Unable to import data from mysql to hive using sqoop in Archives of Support Questions (Read Only)

Unable to import data from mysql to hive using sqoop

GauravB — Fri, 16 Sep 2022 10:15:22 GMT

Hi ,

I have recently set-up VM CDH5.5 on my machine and tried to check commands for importing data into hive from mysql. Job gets stuck after below message in log:

"Loading uploaded data into Hive

Logging initialized using configuration in jar:file:/usr/jars/hive-common-1.1.0-cdh5.5.0.jar!/hive-log4j.properties"

Can someone help why job stuck after this step and have i missed some configuration step.

Command Used:

sqoop import --connect "jdbc:mysql://localhost:3306/retail_db" \

--username retail_db \

-P \

--table customers --target-dir /user/hive/warehouse/sqoop_import --fields-terminated-by "," \

--hive-import --create-hive-table --hive-table sample.customers

Re: Unable to import data from mysql to hive using sqoop

shethsameer — Fri, 22 Apr 2016 21:06:40 GMT

Hi,

Most of the code written is correct except for the username.

Try the username as retail_dba instead

It should work

Regards

Sameer Sheth

Re: Unable to import data from mysql to hive using sqoop

GauravB — Sat, 23 Apr 2016 08:47:25 GMT

Hi Sameer,

I tried to change the user name to retail_dba still having same issue, it works fine till creation of physical file and stuck at

Logging initialized using configuration in jar:file:/usr/jars/hive-common-1.1.0-cdh5.5.0.jar!/hive-log4j.properties

I am not sure if I missed some configuration settings.

Re: Unable to import data from mysql to hive using sqoop

avdheshs — Wed, 04 May 2016 21:14:40 GMT

You can restart the new VM and login from there because once VM is having configuration issue then it will be difficult to get is resolved.

Re: Unable to import data from mysql to hive using sqoop

krshn6 — Thu, 01 Jun 2017 20:59:29 GMT

I have the same issue in real QA environment, please let me know any workaround?