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

%3CLINGO-SUB%20id%3D%22lingo-sub-1440481%22%20slang%3D%22en-US%22%3EKusto%20-%20Partial%20query%20failure%3A%20Low%20memory%20condition%20(LOW_MEMORY%20CONDITION)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440481%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20getting%20%3CSTRONG%3E%22Partial%20query%20failure%3A%20Low%20memory%20condition%20(LOW_MEMORY%20CONDITION)%22%3C%2FSTRONG%3E%20error%20while%20executing%20simple%20kusto%20query.%20After%20returning%205%20lakh%20rows%20it%20throws%20an%20error.%3C%2FP%3E%0A%3CP%3EI%20have%20followed%20all%20the%20best%20practices.%20I%20tried%20using%20%3CSTRONG%3E%22has%22%2C%20%22%3D%3D%22%3C%2FSTRONG%3E%20in%20filter%20instead%20of%20%3CSTRONG%3E%22contains%22%3C%2FSTRONG%3E%20but%20still%20getting%20the%20same%20error.%3C%2FP%3E%0A%3CP%3Ebelow%20are%20sample%20queries%20which%20I%20have%20used%20-%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3Ecluster('ckustername').database('database').tablename%20%7C%20where%20ColumnName%20has%20%22Test%22%3C%2FLI%3E%0A%3CLI%3Ecluster('ckustername').database('database').tablename%20%7C%20where%20ColumnName%20%3D%3D%20%22Test%22%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSTRONG%3EError%20Details%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%22error%22%3A%20%7B%20%22code%22%3A%20%22Internal%20service%20error%22%2C%20%22message%22%3A%20%22Request%20aborted%20due%20to%20an%20internal%20service%20error.%22%2C%20%22%40type%22%3A%20%22Kusto.Data.Exceptions.KustoDataStreamException%22%2C%20%22%40message%22%3A%20%22Query%20execution%20has%20resulted%20in%20error%20(0x80DA0007)%3A%20Partial%20query%20failure%3A%20Low%20memory%20condition%20(E_LOW_MEMORY_CONDITION).%20(message%3A%20'bad%20allocation'%2C%20details%3A%20'').%22%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20suggest.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1440481%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Microsoft

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.

0 Replies