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

IfNull step does not work with Date fields

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Duplicate
    • Affects Version/s: 3.2.2
    • Fix Version/s: 3.2.3, 4.0.0 GA
    • Component/s: Step
    • Labels:
      None
    • 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.

      Description

      In PDI 3.2.2, the IfNull step terminates when checking Date fields for NULL values with the following error message:

      Error in step : Unable to verify if [date String] is null or not because of an error:java.lang.ClassCastException: java.util.Date cannot be cast to java.lang.String

      This is easily reproduced with a GenerateRows step that produces a few rows containing a Date, followed by an IfNull step that checks this Date field.

      This works in 3.2.0, btw.

        Attachments

          Activity

            People

            • Assignee:
              project admin Triage
              Reporter:
              alx Alexander Thiel
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: