search

pipelinedb / docs

PipelineDB Documentation
http://docs.pipelinedb.com
2 stars 7 forks source link

Document custom sliding window timestamp column support #46

Open usmanm opened 8 years ago

MichaelXavier commented 6 years ago

Is this functionality that exists? If I understand it correctly, this would allow you to use the sliding windows features of pipelinedb but you could feed archived data through the stream all at once.

derekjn commented 6 years ago

@MichaelXavier no, this functionality isn't available yet. But you can still use your own timestamp columns to define sliding windows using the explicit syntax:

CREATE CONTINUOUS VIEW v AS
  SELECT count(*) FROM stream
 WHERE my_timestamp > clock_timestamp() - interval '1 hour';

This will create a sliding window over one hour with respect to the my_timestamp column.