Usage Note 61286: The "...PROC SQL requires each of its tables to have at least 1 column..." error occurs when using the SELECT COUNT statement from an Impala table
 |  |  |  |
When using SAS/ACCESS® Interface to Impala with the SQL procedure and a SELECT COUNT statement, you receive the following error:
ERROR: Table doesn't have any columns. PROC SQL requires each of its tables to have at least 1 column.
ERROR: Error trying to read from a DBMS table. At least one column must be selected.
ERROR: Error trying to read from a DBMS table. At least one column must be selected.
The problem occurs when you are using Unicode SAS® but the delimiter expected is a Latin character. To circumvent the problem, add the following environment variable to your sasenv_local file:
export EASYSOFT_UNICODE=YES
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Impala | 64-bit Enabled AIX | ||
| Linux for x64 | ||||
The SQL procedure requires any created table to have at least one column. Errors can occur when using a SELECT COUNT statement from an Impala table. To circumvent the problem, add the environment variable EASYSOFT_UNICODE=YES.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2017-11-03 09:50:32 |
| Date Created: | 2017-10-24 09:28:12 |