sqooping to edge node

[#1]

Hi,

Is it possible to sqoop from sql db to edge node/unix local path, instaed of HDFS??

Regards

Mamta Chawal

[#2]

@Mamta Chawla

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.

[#3 · Accepted solution]

@Mamta Chawla

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>