Forum Discussion
Materialized view arg_max based on 2 columns
Hey, if I have a table that has these fields (key. ,....., updated, ingestion_time), I need to build a materialized view that gets the recently updated version for each key, and if there are multi...
Maybe a bit late, but what you want is probably something like this:
.create materialized-view [MostRecentlyUpdated] on table [T]
{
T | summarize arg_max(ingestion_time, *) by key, updated
}