Partial query failure for kql query size

Question

I'm getting this goofy error which looks to be related to query size. My working query takes around 3 mins. If I add another few lines (which should take ~3 secs if I have results from previous query), kusto throws partial query error due to query size.

I didn't realize that there was such a limit in https://docs.microsoft.com/en-us/azure/data-explorer/kusto/concepts/resulttruncation. I've removed comments/tweaked some queries to spit out lesser fields but still running into same error.

Any idea about what's going on here?

Here's the error trace

Answer 1

This error may be coming in a scenario of cross-cluster query. In this scenario Kusto (Azure Data Explorer) will generate a query and send to another cluster. The query can become long if it contains in() operator (and arguments of in() are coming from the query partial evaluation). If you provide more details - of what is your scenario / query you're running - you can get more detailed answer.