How can I use **Pass allowDiskUse:true** in redash for mongo query

#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?