We have an internal BI group in our company who wrote a 'black box' app (API ?) to connect to Hadoop from SQL Server therefore I never utilized the solution listed in the link above.  Sorry I cannot be of more help.  This was a frustrating issue!