v.24.5New Feature
Added CROSS JOIN Support for Temporary Files Exceeding Size Limits
Added possibility to do CROSS JOIN in temporary files if the size exceeds limits. #63432 (p1rattttt).Why it matters
This feature addresses the problem of memory limitations during largeCROSS JOIN operations by enabling the use of temporary files. It allows queries involving large CROSS JOIN sets to complete successfully without running out of memory, improving stability and enabling more complex analytical queries.How to use it
Users can automatically benefit from this feature when performingCROSS JOIN operations that exceed memory limits. The system will transparently switch to using temporary files to handle the join. No additional configuration is required.