Running a SQL query with a JOIN I get the following error. How can I get past this.
Use aggregation chain method, allowDiskUse.
Pipeline stages have a limit of 100 megabytes of RAM. If a stage exceeds this limit, MongoDB will produce an error. To allow for the handling of large datasets, use the allowDiskUse option to enable aggregation pipeline stages to write data to temporary files.
SELECT * FROM collection
.allowDiskUse(); //chain method, allowDiskUse
Thanks - No error now, but running for a long time without getting any data back.
Without sample data and reproduction steps, it's hard for me to guess what the problem is, and it's hard to help you
Replies have been locked on this page!