Dandandan opened a new issue #78: URL: https://github.com/apache/arrow-datafusion/issues/78
**Describe the bug** TPC-H Query 9 consumes a lot of memory and takes forever in memory on a 8 core machine on SF=1 in memory (with 100%cpu usage across cores) to execute. That likely has to do with the plan misses a equi-join and turns it into a cross join. **To Reproduce** Run query 19, check plan and execution time. **Expected behavior** The query is expected to finish faster (<1s) and shouldn't need a cross join. **Additional context** N/A -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org
