Problem Note 61604: The "Connection refused" error occurs when you use SAS/ACCESS® Interface to Impala with the FREQ and several other in-database procedures
 |  |  |  |  |
When you use PROC FREQ and other in-database procedures, you can receive the following error when using SAS/ACCESS Interface to Impala:
ERROR: ERROR: [unixODBC][Cloudera][ImpalaODBC] (100) Error from the Impala
Thrift API: connect() failed: Connection refused
Thrift API: connect() failed: Connection refused
You encounter this problem when you run code similar to the following:
proc freq data=PMQAREF.peteclass8;
tables sex/outexpect sparse;
run;
tables sex/outexpect sparse;
run;
To circumvent the problem, do one of the following:
- Specify OPTIONS SQLGENERATION=NONE.
- Specify a data source name (DSN) in your LIBNAME statement and set the PORT value in the data source.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Impala | Linux for x64 | 9.43 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 9.43 | 9.4 TS1M4 | ||||
| Microsoft® Windows® for x64 | 9.43 | 9.4 TS1M4 | ||||
A fix for this issue for SAS/ACCESS Interface to Impala 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B7E.html#61604A fix for this issue for SAS/ACCESS Interface to Impala 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B7D.html#61604A fix for this issue for SAS/ACCESS Interface to Impala 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z34.html#61604
When you use SAS/ACCESS Interface to Impala with PROC FREQ and several other procedures, the "...Connection refused..." error can occur. The problem occurs because the PORT value that is passed is an incorrect value.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-12-22 11:23:12 |
| Date Created: | 2017-12-19 13:22:46 |