SUPPORT / SAMPLES & SAS NOTES
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:
proc cas;
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.
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 | |||||