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

Table Output step ignores Time zone for DATE datatype

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 5.0.0 GA (5.0.0 GA Suite Release)
    • Fix Version/s: 5.1.0 GA
    • Component/s: Step
    • Labels:
      None
    • Story Points:
      3
    • PDI Sub-component:
    • 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:
      Pervach

      Description

      Table Output Step ignores metadata timezone.

      With version 5 time zones were introduced for the Date datatype.

      This is a very important development for cloud enablement.

      Yet some components are still ignoring this parameter.

      Table Output is one of them, and probably is one of the most critical ones.

      Attaching DDL and the demo workflow.

      Please ensure that Spoon uses timezone different from the UTC/GMT.

      Enforce if necessary by setting option in Spoon.bat:

      "-Duser.timezone=Asia/Colombo"

      As you can see the Date taken into account is correctly parsed as UTC

      2013-10-06 02:23:37

      Yet TIMESTAMP value (and Oracle Value for Date, as it is converted into Timestamp) are

      2013-10-06 07:53:37

      Which is incorrect, as the TIMESTAMP in Oracle is Time Zone agnostic.

        Attachments

        1. ddl.sql
          0.1 kB
        2. ddl2.sql
          0.2 kB
        3. ignore_timezone_No.PNG
          ignore_timezone_No.PNG
          94 kB
        4. ignore_timezone_Yes.PNG
          ignore_timezone_Yes.PNG
          61 kB
        5. patch_concept.diff
          3 kB
        6. tableoutput_timezone.ktr
          18 kB
        7. tblout_convert_values_5.ktr
          18 kB

          Issue Links

            Activity

              People

              Assignee:
              adoudkina Antonina Doudkina (Inactive)
              Reporter:
              ev.min Evgeny Minkevich
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: