toff63/Esper-isolate-rooms.md

Created November 28, 2015 18:13

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/toff63/1cf24a89fc1b46f424cb.js"></script>
Save toff63/1cf24a89fc1b46f424cb to your computer and use it in GitHub Desktop.

Raw

create schema Temperature(place string, temperature double);

create window HallTemperature.win:length(2) as Temperature;
insert into HallTemperature select * from Temperature(place='hall');

create window BedroomTemperature.win:length(2) as Temperature;
insert into BedroomTemperature select * from Temperature(place='bedroom');

Nthole commented Nov 28, 2015

You remind me of my time when i was at University