SUPPORT / SAMPLES & SAS NOTES
Problem Note 62828: The Parallel Group-By facility produces an incorrect count for a composite index when the COUNT(distinct value) function is used
 |  |  |  |  |
When the Parallel Group-By facility is used with the COUNT(distinct value) function in SAS® Scalable Performance Data Server, you might see an incorrect count result for a composite index in your SAS log.
The error occurs because the metadata scan logic, when determining the distinct count for a value, counts the number of unique composite keys in an index instead of counting the distinct values that compose the keys.
To work around the problem, disable the Parallel Group-By facility index metadata scan.
To disable the scan, use one of the following SQL reset options:
%let spdssqlr=noscangrpsel; /* in implicit pass-through SQL */
execute (reset noscangrpsel) by sasspds; /* in explicit pass-through SQL */
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* | |||
| SPDS | SAS Scalable Peformance Data Server | Microsoft® Windows® for x64 | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |
| 64-bit Enabled AIX | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||
| 64-bit Enabled Solaris | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||
| HP-UX IPF | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||
| Linux for x64 | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||
| Solaris for x64 | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||