Using Sqoop in a MutiNode environment

Hi Durga,

Thanks for the videos. My question is, in a multinode cluster i.e the MySQL database resides in a different node, can i have access to the database when given only the “hostname” without a port-number. Are their scenarios when a “portnumber” is not required?

For sqoop, default port no is 3306. If you do not mention it in connection string, it will look for default port no. But if the different port no is configured for mysql, then you have to mention that port no in connection string.

2 Likes

Thanks N_Chakote, didn’t know this, it confused me during certification, i wasted a lot of time trying to resolve this.

@N_Chakote I had a similar doubt during the exam so just executed sqoop list-databases and confirmed.