search

Seddryck / Tseesecake

Tseesecake is a lightweight proxy for time-series query engines, supporting multiple database engines and storage providers, with a SQL dialect dedicated to time series
https://seddryck.github.io/Tseesecake
Apache License 2.0
2 stars 1 forks source link

Arithmetic expressions #36

Closed Seddryck closed 10 months ago

Seddryck commented 1 year ago

It should be possible to define an arithmetic expression such as the difference or the ratio between two measurements without defining a literal expression.

SELECT
    Instant
    , (Forecasted - Produced) * -1.50 AS Signal
FROM
    WindEnergy
Seddryck commented 10 months ago

The virtual measurement (WITH statement) is providing an equivalent feature