Survey banner
Share your feedback on the Dataiku documentation with this 5 min survey. Thanks! TAKE THE SURVEY

Outputting POSIXt in R recipes

Outputting POSIXt in R recipes


When outputting a data.frame or a data.table in R recipes, columns inheriting of the POSIXt class (POSIXct, POSIXlt) are written as strings. I find this not very consistent, they should be written as dates.

For now the only way I found to do this was to force the dataset schema manually to a date, and write with :

dkuWriteDataset(df, name, schema = FALSE)

I'm using DSS version 4.1.5 and I am writing to a PostgreSQL database.

Did I miss something ? Is there another way to do it ?

0 Kudos
1 Reply
Dataiker Alumni

This is indeed the preferred solution to write R data.frames with specific date types.


0 Kudos