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

PDI assigns improper data type to a field when using the Get Fields feature on a csv input step.

    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
    • Environment:
      Tested on Nightly #315.
    • 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
    • Operating System/s:
      Ubuntu 12.x (64-bit)

      Description

      When using the Get Fields feature on a CSV input step, PDI assigns Integer to a field that has the values "1a" and "1b" including the quotes.

      To reproduce issue.

      1.) Create a new transformation.
      2.) Add a CSV input step.
      3.) Browse to the attached csv file and open.
      4.) Hit GetFields.

      Expected Result: Fields Id and CreatedById are supposed to have string as their data type.

      Actual Result: They both have integer as their data type and the letter has been truncated from their value.

        Attachments

          Activity

            People

            Assignee:
            alena_khamitsevich Alena Khamitsevich (Inactive)
            Reporter:
            jdorlus John Dorlus (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: