We recently upgraded our HW Hadoop install to the latest release. Afterwards, we immediately began experiencing an issue with the Hortonworks ODBC connections in our SSIS packages, where on all subsequent connections beyond the first in the package, the dataflows hang trying to validate the connection - no error message or timeout occurs. We use the SSIS "reuse connection" option and I've isolated it failing when this is turned on vs off, which had no issue prior to the upgrade. HW/Simba support haven't been able to figure out why. To summarize - upgraded Hadoop, post-upgrade all our SSIS packages hang with the Hortonworks ODBC driver after an initial connection.
... View more