1

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
}

2

Does this not work when you execute it?

3

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.

4

What version of Redash are you using?

5

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

6

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

7

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

8

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

9

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

The current mongo.py query runner still supports the allowDiskUse flag.