is there any documentation on the LASTWITHTIME aggregation function? I'm trying to use it right now but it seems that it only supports time columns that are LONG/INT?

yes, it only supports timestamps/epochs at the moment. I'll add some documentation on it, thanks for the reminder!

thanks!

Is it possible (query side) to convert the date string to epoch and use that in

lastwithtime

? I've tried that

SELECT
	FromDateTime(dateString, 'YYYY-MM-dd') AS epochMillis,
	lastwithtime(value, epochMillis, 'float'),
	kpiId
FROM test_kpis
GROUP BY kpiId

Doesn't seem to work

creating a derived column using a transform function during ingestion should work

"transformConfigs": [
    {
        "columnName": "epochMillis",
        "transformFunction": "fromDateTime(dateString, 'YYYY-MM-dd')"
    }
]

That's what I thought of but was wondering if there was some way to do it query time, seems like not then Thanks for the answer @User !