Query result set has exceeded the internal ... limit

A query result set has exceeded the internal ... limit is a kind of partial query failure that happens when the query's result has exceeded one of two limits:

  • A limit on the number of records (record count limit, set by default to 500,000)
  • A limit on the total amount of data (data size limit, set by default to 67,108,864 (64MB))

There are several possible courses of action:

Note

We don't recommend that you increase the query limit, since the limits exist to protect the cluster. The limits make sure that a single query doesn't disrupt concurrent queries running on the cluster.