You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Sree Harsha Ramanavarapu (Jira)" <ji...@apache.org> on 2025/01/28 20:11:00 UTC

[jira] [Created] (CALCITE-6809) 8 table join with jdbc connections hangs

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)