3 Replies Latest reply on Feb 14, 2018 2:49 PM by Steven Hawkins

    In clause on dependent joins not splitting into parallel queries

    vijayvenkatsr Newbie

      Have a custom JDBC translator and resource adapter implemented.

      The Execution factory has the following values set:

      MaxInCriteriaSize =  1000

      MaxDependentInPredicates =1

       

      On execution of a query with an inner join between two tables and an IN clause of over 1000 values results in Teiid removing the in clause and executing the full query (no pushdown)

      Tables:

      State: Name (Primary key), Capital

      City : Seq_ID(Primary Key), Name, State_Name (Foreign key), Area

       

      Query

      SELECT City.Name, State.Name FROM City, State WHERE City.State_Name = State.Name AND Seq_ID IN (1,2,3…2000)

       

      Expecting Teiid to split this query into the following 2 queries:

      SELECT City.Name, State.Name FROM City, State WHERE City.State_Name = State.Name AND Seq_ID IN (1,2,3…1000)

      SELECT City.Name, State.Name FROM City, State WHERE City.State_Name = State.Name AND Seq_ID IN (1001,1002,1003…2000)

       

      Actual query being executed is

      SELECT City.Name, State.Name FROM City, State WHERE City.State_Name = State.Name AND

       

      Please help clarify how to configure Teiid for the execution of parallel/split queries