question Re: Which nodes port to open in hadoop cluster for Sqoop export? in Archives of Support Questions (Read Only)

Which nodes port to open in hadoop cluster for Sqoop export?

pratik_vagyani2 — Mon, 20 Mar 2017 13:28:57 GMT

Usecase : Export data from Hadoop cluster using Sqoop.

Question : From which node Sqoop exports data ? is it Name node or any data node?

Re: Which nodes port to open in hadoop cluster for Sqoop export?

jsensharma — Mon, 20 Mar 2017 13:33:49 GMT

An example of Sqoop’s export process will be to read a set of delimited text files from HDFS in parallel, parse them into records, and insert them as new rows in a target database table, for consumption by external applications or users.

So ideally it can be any node in your HDP cluster where you have the sqoop installed and can access the HDFS.

Re: Which nodes port to open in hadoop cluster for Sqoop export?

pratik_vagyani2 — Mon, 20 Mar 2017 13:45:27 GMT

Thanks Jay.

Re: Which nodes port to open in hadoop cluster for Sqoop export?

rajsyrus — Mon, 20 Mar 2017 18:00:43 GMT

@pratik vagyani

https://community.hortonworks.com/questions/81286/how-sqoop-talks-to-external-world.html#comment-82100