Problem Note 63249: Some FedSQL queries fail in SAS® Cloud Analytic Services when it is running in distributed mode
 |  |  |  |  |
The following combination of factors results in an error when executing the fedSql.execDirect action:
- SAS Cloud Analytic Services (CAS) runs in distributed mode.
- The queried CAS table contains an indexed variable.
- The indexed variable appears in a WHERE clause.
- You use one or more of the following:
- Table joins
- LIMIT
- ORDER BY
- SELECT DISTINCT
- A GROUP BY clause that contains computed expressions rather than simple column references
There might be additional scenarios in which this problem occurs.
A simple example is shown here:
table.index /
table="zipcode",
casOut={
name="where_var_indexed",
indexVars={"zip", "y"},
promote=true
};
run;
fedSql.execDirect / query=
"create table newtable{options replace=true} as select distinct zip from where_var_indexed where (y between 34 and 39)";
run;
NOTE: Added action set 'fedSql'.
ERROR: General Error - invalid Exception
ERROR: The action stopped due to errors.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.4 | |||
| Microsoft® Windows® for x64 | 3.4 | |||||
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesWinAn update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesViya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-11-26 11:09:09 |
| Date Created: | 2018-11-20 16:48:13 |