How can I use Pass allowDiskUse:true in redash for mongo query.
What I am doing is :
“collection”: “collection_name”,
“aggregate”: [
required function
“allowDiskUse”: true

Does this not work when you execute it?

no, It doesn’t work.
It shows the same error.
Error running query: Exceeded memory limit for $group, but didn’t allow external sort. Pass allowDiskUse:true to opt in.

What version of Redash are you using?

I was using 2.0 but this week I move to 6.0.

I’m not sure if this was supported in 2.0, but it is supported in 6.0.

okay, Thanks.
I will try the same syntax on 6.0.
But the syntax that I mentioned above is correct, right?

Getting the same error, not sure how to rectify this. Any suggestions are welcome

Thanks for bumping this topic. What have you tried so far? I don’t use MongoDB but can perhaps provide pointers.

The current query runner still supports the allowDiskUse flag.