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?