Home / Companies / InfluxData / Blog / Post Details
Content Deep Dive

Outer Joins in Flux

Blog post from InfluxData

Post Details
Company
Date Published
Author
Sean Brickley
Word Count
1,651
Language
English
Hacker News Points
-
Summary

The Flux query team has developed a new join package to improve upon existing solutions and provide support for outer joins, which was a frequently requested feature. The new package provides six functions, including `tables()`, `inner()`, `full()`, `left()`, `right()`, and `time()`, with the latter three being aliases for the first three. It allows users to define left and right input table streams and compare records from these tables based on a function that takes two records as arguments, following a specific format. The package also supports different join methods, including inner, left, right, and full joins, each with its own set of rules for constructing the output record. The new package aims to improve performance by reducing row comparisons and provide flexibility in join predicates, which can be used to leverage complex comparisons in the future.