Uploaded image for project: 'Talend DI components'
  1. Talend DI components
  2. TDI-44773

tSnowflakeInput--->tAzureAdlsGen2Output with dynamic column produce wrong data for Integer, Byte, Short, Long

Apply templateInsert Lucidchart Diagram
    XMLWordPrintable

Details

    • Bug
    • Status: Done
    • Minor
    • Resolution: Fixed
    • None
    • 7.3.1-R2020-09
    • Components

    Description

      Check the attachment job 'TDI44626_tAzureAdlsGen2_tSnowflakeInput_dynamic.zip'
      tSnowflakeInput output:

      .------------------------------------------------------------------------.
      |                               tLogRow_3                                |
      |=----------------------------------------------------------------------=|
      |newColumn                                                               |
      |=----------------------------------------------------------------------=|
      |1 - paddle - a - 1 - 3 - 23 - 1.2300000190734863 - 2.05 - 3 - 2020-07-29|
      |2 - pickle - a - 1 - 3 - 23 - 2.3399999141693115 - 3.26 - 4 - 2020-07-29|
      |3 - scheme - a - 1 - 3 - 23 - 3.549999952316284 - 4.36 - 6 - 2020-07-29 |
      '------------------------------------------------------------------------'

      tGen2AdlsGen2Output generate data

      newColumn;newColumn1;newColumn2;newColumn4;newColumn5;newColumn7;newColumn8;newColumn9;newColumn6;newColumn10
      1.0;paddle;a;1.0;3.0;23.0;1.2300000190734863;2.05;3.0;2020-07-28T16:00Z[UTC]
      2.0;pickle;a;1.0;3.0;23.0;2.3399999141693115;3.26;4.0;2020-07-28T16:00Z[UTC]
      3.0;scheme;a;1.0;3.0;23.0;3.549999952316284;4.36;6.0;2020-07-28T16:00Z[UTC]

      After emmanuel_g investigating, he said

      all numeric types are translated to id_BigDecimal, so azure-dls-gen2 component receives only bigdec for all numeric types...
      The problem is tough coming from incoming data...

      in TDI-44626

      Attachments

        Issue Links

          Activity

            People

              pteyssier pierre teyssier
              qyliu qiyan liu
              emmanuel gallois, qiyan liu
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: