Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1792

Timestamp --> Datetime insert: milliseconds are wrongly inserted in CS

    XMLWordPrintable

    Details

    • Sprint:
      2018-20

      Description

      Using PDI bulk adapter the following issue is found:
      1. PDI type Timstamp is loaded into CS Datetime field using CSV file.
      2. The value of the field is 2018-01-01 00:00:01.220
      and this field should be loaded in CS DATETIME (6) field.

      Result observed in CS after load is:
      2018/01/01 00:00:01.000022000

      Expected:
      2018/01/01 00:00:01.220000000

      Notes:
      I tried with direct insert into CS and this works correctly.
      So issue lays somewhere in PDI adapter or api.

      PDI job script is attached.
      @Jens, could you please add it to automated tests?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              elena.kotsinova Elena Kotsinova
              Reporter:
              elena.kotsinova Elena Kotsinova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration