Document custom sliding window timestamp column support #46

Activity

1. MichaelXavier commented on May 22, 2018

   

   MichaelXavier

   on May 22, 2018

   More actions

   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.
2. derekjn commented on May 22, 2018

   

   derekjn

   on May 22, 2018

   Contributor

   More actions

   @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.