Problem Note 61877: The LIBNAME connection to Hadoop fails with java.util.concurrent.TimeoutException errors
The LIBNAME connection to Hadoop and Hive creates a primary connection that is retained until the LIBNAME connection is cleared or the SAS® session ends. When the LIBNAME connection is used, a 'utility' connection is also created and retained until the LIBNAME connection is cleared or the SAS session ends.
When the maximum number of connection threads that are available in Hadoop or Hive has been reached, the LIBNAME connection fails with errors similar to the following:
ERROR: java.util.concurrent.TimeoutException
ERROR: Could not open connection to
jdbc:hive://hdp01.us.com:10000/schema1;
principal=hive/_HOST@HDP01.US.COM. Check your Hive server status and
also set option SUBPROTOCOL= appropriately. Set SUBPROTOCOL=hive2 if
you are running HiveServer2. Set SUBPROTOCOL=hive if you are running
Hive1.
ERROR: Error trying to establish connection.
ERROR: Error in the LIBNAME statement.
The hive.server2.thrift.max.worker.threads property controls the maximum number of connections allowed to the Hive server. The property is documented in the Hive configuration documentation. Hadoop administrators must determine the maximum number of connections that are allowed at their site. If the number of allowed connections is greater than the default or current value of the hive.server2.thrift.max.worker.threads property, the administrators need to increase value for the property.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Hadoop | Microsoft® Windows® for x64 | | |
| Microsoft Windows 10 | | |
| Microsoft Windows Server 2008 | | |
| Microsoft Windows Server 2008 R2 | | |
| Microsoft Windows Server 2008 for x64 | | |
| Microsoft Windows Server 2016 | | |
| 64-bit Enabled AIX | | |
| 64-bit Enabled Solaris | | |
| HP-UX IPF | | |
| Linux for x64 | | |
| Solaris for x64 | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-01-16 13:35:50 |
| Date Created: | 2018-02-21 08:18:18 |