查询结果集已超过内部限制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:

  • 记录数的限制(record count limit,默认设置为 500,000)A limit on the number of records (record count limit, set by default to 500,000)
  • 总数据量的限制(data size limit,默认设置为 67,108,864 (64MB))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:

备注

建议你不要提高查询限制,因为设置这些限制是为了保护群集。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.