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

join rows cartesian product behavior in different versions

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Duplicate
    • Affects Version/s: 9.1.0 GA, 9.2.0 GA
    • Fix Version/s: None
    • Component/s: Step
    • Labels:
      None
    • 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.
    • Operating System/s:
      Windows 10
    • Steps to Reproduce:
      Hide

      Working Scenario

      1. Open spoon 8.3
      2. Locate the following file under Samples:
        \data-integration\samples\transformations\Join Rows - adding fields to a stream.ktr
      3. Run the transformation
      4. Preview the data and notice all 4 streams are joined on a cartesian join
      5. Close Spoon 8.3

      Broken Scenario

      1. Open Spoon 9.1
      2. Locate the following file under Samples:
        \data-integration\samples\transformations\Join Rows - adding fields to a stream.ktr
      3. Run the transformation
      4. Preview the data and notice the join step is empty
      Show
      Working Scenario Open spoon 8.3 Locate the following file under Samples: \data-integration\samples\transformations\Join Rows - adding fields to a stream.ktr Run the transformation Preview the data and notice all 4 streams are joined on a cartesian join Close Spoon 8.3 Broken Scenario Open Spoon 9.1 Locate the following file under Samples: \data-integration\samples\transformations\Join Rows - adding fields to a stream.ktr Run the transformation Preview the data and notice the join step is empty

      Description

      Observing inconsistent /odd behavior with Join rows (cartesian join) step, simply running the sample transform provided with PDI download called "join rows test".
      If I run this transformation in version 8.3, rows are read by the "dummy" step.

      In 9.1, and 9.2 I'm seeing no rows leave the join rows step. Zero rows arrive at dummy step.

        Attachments

        1. pdi_join_no_rows.png
          pdi_join_no_rows.png
          101 kB
        2. PreviewData83.PNG
          PreviewData83.PNG
          172 kB
        3. PreviewData91.PNG
          PreviewData91.PNG
          83 kB

          Issue Links

            Activity

              People

              Assignee:
              project admin Triage
              Reporter:
              jlawmi James Law
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: