Partager via

Setting up HDINSIGHT cluster with SQOOP MySQL connector

  • Article

As of today HdInsight Hadoop clusters didn’t have SQOOP MySQL connector. Manually setting it up is tedious. HdInsight recommended way of doing it is to use “script action”. To make it simpler I have authored a script action to install MySQL connector on windows clusters.

Script action is currently shared at  https://kkhdiprodonly.blob.core.windows.net/scriptactions/MySqlSqoopConnector.ps1

 

CAUTION:

  1. Above script action is only for testing purposes. Otherwise recommendation is to copy and re-host it.

  2. Update the MySql version according to your needs. Currently Its authored to install mysql-connector-java-5.0.8 version.

 

How to use it:

  1. Select “Custom Create” option

  3. On last screen of the wizard Fill the script URI (NOTE: Make sure “All nodes” is selected for “NODE TYPE”