Functions for arithmetic expressions

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

Functions for arithmetic expressions #37

Open Seddryck opened 1 year ago

Seddryck commented 1 year ago

It should be possible to apply some functions to an expression defining a new measurement

WITH MEASUREMENT Accuracy AS (
    ABS(Produced - Forecasted)/Produced
)

Supported functions:

[ ] Absolute, Sign
[ ] Invert, Oppose
[ ] Power, Square root, Cube root
[ ] Clip
[ ] Ceiling, Floor, Round

Seddryck commented 1 year ago

Investigation required on the usage of Expressif to support a part of this feature