Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.2.0
-
Fix Version/s: 1.2.1
-
Component/s: mcsapi, Pentaho Kettle Adapter
-
Labels:None
-
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
- relates to
-
MCOL-1516 DateTime ingestion corner case - wrong handling - "0001-01-01 00:00:01"
-
- Closed
-