S02025
Error Code
S02025
Error Message
The where clause <xxx> of a distributed query should not use any aggregate
or order-sensitive function. RefId: S02025
Probable Causes
This error occurs when the
where
clause uses an aggregate or
order-sensitive function in a partitioned DFS table query. For
example:SELECT SearchPhrase FROM hits WHERE min(UserID) > 0 => The where clause [min(UserID) > 0] of a distributed query should not use any aggregate or order-sensitive function.
Solutions
- Use the
having
clause to filter the aggregate results:SELECT SearchPhrase FROM hits GROUP BY SearchPhrase HAVING min(UserID) > 0;
- If no filtering is needed, delete the
where
clause. - If the queried table is not too large, load the table into memory and perform
the query on the in-memory
table:
t = SELECT * FROM hits // Load the the content of the partitioned table hits into the in-memory table t SELECT SearchPhrase FROM t WHERE min(UserID) > 0