Pentaho - Group By step does not return timestamp value

I use the "Group by" step in my conversion, and I group the field and pass some other fields as output to Aggregates. Among these output fields, there is a timestamp field that does not return the timestamp value that I pass as input, instead it returns a null value. The type that I used for the timestamp field is First Value.

Here is my conversion:

enter image description here

Previewing rows in a table:

enter image description here

Group step:

enter image description here

Group preview line by step:

enter image description here

Can someone help me fix this?

Thanks in advance!

+5
source share
1 answer

I just turned off the "Supports timestamp data type" option in connection with the database in the table entry step. Then, the timestamp value is returned in turn.

I do not know if this is correct, but it worked for me.

0
source

Source: https://habr.com/ru/post/1243191/


All Articles