search

microsoft / Kusto-Query-Language

Kusto Query Language is a simple and productive language for querying Big Data.
Apache License 2.0
510 stars 97 forks source link

Aggregation over string column exceeded the memory budget of 8GB during evaluation #140

Closed dipendra-singh closed 1 month ago

dipendra-singh commented 2 months ago

I am using a query where there are no summarizations and set I have set max_memory_consumption_per_query_per_node=68719476736; set maxmemoryconsumptionperiterator = 68719476736; set notruncation; but still I am recieving this error:

azure.kusto.data.exceptions.KustoApiError: An admin command cannot be executed due to a failure in the distributed ingestion: Details='-2133196799:{"Count":1,"Text":"Partial query failure: Runaway query (E_RUNAWAY_QUERY). (message: Aggregation over string column exceeded the memory budget of 8GB during evaluation (see https://aka.ms/kustoquerylimits): )"}'

Can someone help me with this?

mattwar commented 1 month ago

You will need to open an azure support ticket to get help on this issue. https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request