Kusto - Partial query failure: Low memory condition (LOW_MEMORY CONDITION)

[rupeshinpure2301]

I am getting "Partial query failure: Low memory condition (LOW_MEMORY CONDITION)" error while executing simple kusto query. After returning 5 lakh rows it throws an error.

I have followed all the best practices. I tried using "has", "==" in filter instead of "contains" but still getting the same error.

below are sample queries which I have used -

1. cluster('ckustername').database('database').tablename | where ColumnName has "Test"
2. cluster('ckustername').database('database').tablename | where ColumnName == "Test"

Error Details:

"error": { "code": "Internal service error", "message": "Request aborted due to an internal service error.", "@type": "Kusto.Data.Exceptions.KustoDataStreamException", "@message": "Query execution has resulted in error (0x80DA0007): Partial query failure: Low memory condition (E_LOW_MEMORY_CONDITION). (message: 'bad allocation', details: '').",

Please suggest.