MongoDB query error

joelhansen · February 7, 2023, 1:29pm

I’m using Dremio Enterprise in AWS Edition with vendor recommended EC2 coordinator machine.
I’m trying to create a dataset from mongodb collection, but when run (or save) this query, getting this error:
Query failed with error code 16820 and error message 'Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.' on server <ip>:<port>.

How can I pass this parameter (alowDiskUse) to mongodb?

Thanks!

balaji.ramaswamy · February 13, 2023, 4:52am

@joelhansen I would like to see if the push down to MongoDB failed with this error, the profile will also tell us if we pushed down any filters and joins. Could you please upload the profile so we can review?

Topic		Replies	Views
DREMIO - Query was cancelled because it exceeded the memory limits set by the administrator	4	821	August 16, 2023
Dremio x Mongodb - Error	1	1122	February 6, 2020
Query was cancelled planning time exceeded 60 seconds	3	1938	June 7, 2018
Dremio, Mongodb datasource - Command failed with error 11601 (Interrupted)	1	2102	October 30, 2020
The limit 10 appears in the dremio query ES SQL, resulting in a full table scan	4	3706	April 6, 2018

MongoDB query error

Related topics