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.