Sree Harsha Ramanavarapu created CALCITE-6809:
-------------------------------------------------

             Summary: 8 table join with jdbc connections hangs
                 Key: CALCITE-6809
                 URL: https://issues.apache.org/jira/browse/CALCITE-6809
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Sree Harsha Ramanavarapu
         Attachments: 8-join-plan.txt, bug-with8-join.png

We are trying to generate a plan with an eight table join. This results in a 
hang. Please see the attached plans.

We are retreiving data from two different sources, one is a custom local memory 
table (MemoryTableScan) and others are JdbcTableScans.  Caclite is waiting for 
EnumerableNestedLoop's  inner table to respond. But it has already exhausted 
the connection pool and is just waiting for a new connection. 

The problem we are facing is similar to the one described in 
https://issues.apache.org/jira/browse/CALCITE-1739 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to