- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Unable to import data from mysql to hive using sqoop
- Labels:
-
Apache Hive
-
Apache Sqoop
Created on 04-22-2016 12:23 PM - edited 09-16-2022 03:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 05-04-2016 02:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 04-22-2016 02:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 04-23-2016 01:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 05-04-2016 02:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 06-01-2017 01:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have the same issue in real QA environment, please let me know any workaround?
