Timestamp truncation

Problem

We noticed that timestamps got truncated such that they were missing their second fractions. All the columns were set to timestamp with precision 26 and scale 6, however.

Solution

Some stages were missing the "Microsecond" setting in the extended field of the column definition. After setting these, the truncation stopped.

Kommentare

Beliebte Posts aus diesem Blog

Missing record delimiter "\n", saw EOF instead

Error when checking operator: Could not find input field 'field_name'

Error calling DSSetParam code=-4 [ParamValue/Limitvalue is not appropriate]