Online Archive: Epoch Millis in a field type double

Rafael_Martins · 2023-04-03T14:54:33.603Z

I need to create an online archive in a collection and the date field stores a Epoch Millis.

I selected the option for this kind o date. However, it doesn’t work because the field that stores this data is Double, not Long. So there is this error:

Error starting archive: Invalid criteria field type field name: event.expiration_at_ms, detected field type: double

How can I fix it?

Jason_Tran · 2023-04-12T03:17:12.922Z

Hi @Rafael_Martins,

Not sure if it works with your use case but perhaps you can try use the custom criteria filter for the date field but I do believe a different partition field has to be used as Atlas currently supports the following partition attribute types:

date
int
long
objectId
string
uuid

Regards,
Jason