Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

sqooping to edge node

avatar
Rising Star

Hi,

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

Regards

Mamta Chawal

1 ACCEPTED SOLUTION

avatar

@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>

View solution in original post

2 REPLIES 2

avatar
@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.

avatar

@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>