Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-19105

Cartesian Join Results In: org.pentaho.di.core.BlockingBatchingRowSet cannot be cast to org.pentaho.di.core.BlockingRowSet

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 9.1.0.3 GA, 9.2.0 GA, 8.3.0.23 GA
    • Fix Version/s: 9.3 GA
    • Component/s: Step
    • Labels:
    • Environment:
      Windows 10, openjdk-8u282-b08-jre
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide

      Create two data-grids.  One with columnA, one with columnB; strings.

      Connect both to the cartesian-join; with the expectation of having all of columnB repeat for all values of columnA; or visa-versa depending whichever is nominated as the primary.  No join condition.

      Connect a dummy step to the output of the cartesian-join, execute.

      Show
      Create two data-grids.  One with columnA, one with columnB; strings. Connect both to the cartesian-join; with the expectation of having all of columnB repeat for all values of columnA; or visa-versa depending whichever is nominated as the primary.  No join condition. Connect a dummy step to the output of the cartesian-join, execute.

      Description

      This worked fine on 8.3 as you can see here:

      In 9.1 we get the following stack trace:

      2021/03/08 11:50:47 - cross-join.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Unexpected error
      2021/03/08 11:50:47 - cross-join.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : org.pentaho.di.core.exception.KettleException: 
      2021/03/08 11:50:47 - cross-join.0 - Error creating temporary file(s) : 
      2021/03/08 11:50:47 - cross-join.0 - org.pentaho.di.core.BlockingBatchingRowSet cannot be cast to org.pentaho.di.core.BlockingRowSet
      2021/03/08 11:50:47 - cross-join.0 - 
      2021/03/08 11:50:47 - cross-join.0 - at org.pentaho.di.trans.steps.joinrows.JoinRows.initialize(JoinRows.java:124)
      2021/03/08 11:50:47 - cross-join.0 - at org.pentaho.di.trans.steps.joinrows.JoinRows.processRow(JoinRows.java:257)
      2021/03/08 11:50:47 - cross-join.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      2021/03/08 11:50:47 - cross-join.0 - at java.lang.Thread.run(Thread.java:748)
      2021/03/08 11:50:47 - cross-join.0 - Caused by: java.lang.ClassCastException: org.pentaho.di.core.BlockingBatchingRowSet cannot be cast to org.pentaho.di.core.BlockingRowSet
      2021/03/08 11:50:47 - cross-join.0 - at org.pentaho.di.trans.step.BaseStep.swapFirstInputRowSetIfExists(BaseStep.java:3464)
      2021/03/08 11:50:47 - cross-join.0 - at org.pentaho.di.trans.steps.joinrows.JoinRows.initialize(JoinRows.java:84)
      2021/03/08 11:50:47 - cross-join.0 - ... 3 more*
      

      The transformation runs successfully but no data is shown on the join step:

      Notice that in later versions where a service pack is applied the exception is not shown and the transformation finalizes without errors

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brana Bhupendra Rana
              Reporter:
              mr_thwibble Mr Thwibble
              Votes:
              1 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: