Created 07-10-2016 05:40 AM
Hi,
Is it possible to sqoop from sql db to edge node/unix local path, instaed of HDFS??
Regards
Mamta Chawal
Created 07-10-2016 07:35 AM
Here is the command to import data from mysql to local FS (documentation) :
sqoop import -fs local -jt local --connect jdbc:mysql://<host>/sqoop --username <user> --password <password> --table <table-name>
Created 07-10-2016 05:50 AM
No, Sqoop will import the data to HDFS directories only either default directory [/apps/warehouse/hive/] or other specified hdfs location.
Then you can move the data to your local directories or you can access hdfs data using nfs mount from your unix local directory.
Created 07-10-2016 07:35 AM
Here is the command to import data from mysql to local FS (documentation) :
sqoop import -fs local -jt local --connect jdbc:mysql://<host>/sqoop --username <user> --password <password> --table <table-name>