Problem Note 61251: LIBNAME HADOOP statements that require a custom URI option fail in SAS® Data Loader for Hadoop
 |  |  |  |  |
SAS Data Loader for Hadoop generates SAS code to execute directives requested by the user. Currently, there is no way to specify a URI option for inclusion in LIBNAME HADOOP statements generated by SAS Data Loader for Hadoop. If a URI option is needed to connect to your Hadoop system, the LIBNAME HADOOP statement will fail.
For example, the URI option might be necessary to specify SSL truststore information if the Hiveserver2 is secured with SSL, as shown below:
Click the Hot Fix tab in this note to access the hot fix for this issue.
After You Have Installed the Hot Fix
With the hot fix installed, any URI string set in a connection.jdbc.url Extended Attribute on the SAS Data Loader - Hadoop Server entry in SAS® Management Console will be used as the URI option in LIBNAME HADOOP statements generated by SAS Data Loader for Hadoop.
For more information about connection.jdbc.url, see Define Data Sources in the SAS® Data Loader 3.1 for Hadoop: Installation and Configuration Guide.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Loader for Hadoop | Microsoft® Windows® for x64 | 3.1 | 9.4 TS1M4 | ||
| Linux for x64 | 3.1 | 9.4 TS1M4 | ||||