Problem Note 61608: The "...No more data to read..." error occurs when you run the RANK procedure with SAS/ACCESS® Interface to Impala
 |  |  |  |  |
When you use PROC RANK with IMPALA tables, you can receive an error similar to the following:
proc rank data=x.test1 out=work.sortme;
var age height weight;
ranks rankage rankheig rankweig;
run;
ERROR: CLI error trying to establish connection:
[unixODBC][Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: No more
data to read.
ERROR: Connection to the IMPALA DBMS does not exist.
var age height weight;
ranks rankage rankheig rankweig;
run;
ERROR: CLI error trying to establish connection:
[unixODBC][Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: No more
data to read.
ERROR: Connection to the IMPALA DBMS does not exist.
You encounter this issue when you run code similar to the following:
libname x sasioimp server=your_server impala_principal=yourkerberoscredentials@company.com ;
Other procedures and DATA steps run correctly with this same LIBNAME statement. The problem occurs because the IMPALA_PRINCIPAL is not passed to the procedure correctly.
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 | Microsoft® Windows® for x64 | 9.43 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 9.43 | 9.4 TS1M4 | ||||
| Linux for x64 | 9.43 | 9.4 TS1M4 | ||||
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#61608A 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#61608
When running PROC RANK against IMPALA tables using SAS/ACCESS Interface to Impala, you can receive a "...No more data to read..." error.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-12-22 11:28:16 |
| Date Created: | 2017-12-20 08:45:24 |