CedarDB supports AsOf joins for fuzzy merges, usually on time series. An AsOf join allows combining two tables on a “closest matching” attribute. This is useful to find the latest metric from one table at the time of another measurement with an ordering comparison. Usage example: -- Example schema create table humidity(measure_time timestamp, value double); create table temperature(measure_time timestamp, value double); -- Get combined measurements, e.g., to calculate a "feels like" heat ...
