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

Parser for Timeseries creation #32

Closed Seddryck closed 1 year ago

Seddryck commented 1 year ago

To create a time series: 

CREATE OR REPLACE TIMESERIES WindEnergy(
    Instant TIMESTAMP
    , WindPark FACET
    , Producer FACET
    , Forecasted MEASUREMENT
    , Produced MEASUREMENT
);

To create the time series and import the values from a flat file

CREATE OR REPLACE TIMESERIES WindEnergy(
    Instant TIMESTAMP
    , WindPark FACET
    , Producer FACET
    , Forecasted MEASUREMENT
    , Produced MEASUREMENT
)
IMPORT FROM FILE
    '.\..\data.csv'
;