When you use PROC FREQ and other in-database procedures, you can receive the following error when using SAS/ACCESS Interface to Impala:

You encounter this problem when you run code similar to the following:

The problem occurs because the PORT value that is passed is an incorrect value.

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

* 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.

---

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#61604

---

A 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#61604

---

A 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