S02039
Error Code
S02039
Error Message
The number of partitions […] relevant to the query is too large. Please add
more specific filtering conditions on partition columns in WHERE clause, or
consider changing the value of the configuration parameter
maxPartitionNumPerQuery. RefId:S02039
Probable Causes
The maximum number of partitions involved in a single SELECT query is limited by the maxPartitionNumPerQuery configuration parameter. If the number of partitions involved after filtering with the WHERE clause exceeds this limit, an error will occur.
Solutions
-
Change the value of the configuration parameter maxPartitionNumPerQuery.
-
Add more specific filtering conditions on partition columns in WHERE clause.