calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Γιώργος Θεοδωράκης <giwrgosrth...@gmail.com>
Subject Window Semantics for Streams
Date Tue, 18 Oct 2016 17:23:39 GMT
Hi,

I was wondering if there is any possible way to define windows with SQl in
Calcite for queries that don't have an aggregate function? For example, I
want to define the queries from Linear Road Benchmark of the STREAM project
(http://infolab.stanford.edu/stream/cql-benchmark.html):

1)
SELECT DISTINCT car_id
FROM CarSegStr [RANGE 30 SECONDS];

2)
SELECT car_id, exp_way, dir, seg
FROM CarSegStr [PARTITION BY car_id ROWS 1], CurActiveCars
WHERE CarSegStr.car_id = CurActiveCars.car_id;

Thank you in advance,
George.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message