question sqooping to edge node in Archives of Support Questions (Read Only)

sqooping to edge node

colorsoflife — Sun, 10 Jul 2016 12:40:12 GMT

Hi,

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

Regards

Mamta Chawal

divakarreddy_a — Sun, 10 Jul 2016 12:50:04 GMT

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.

sandyy006 — Sun, 10 Jul 2016 14:35:20 GMT

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>