Skip to content

Instantly share code, notes, and snippets.

@up1

up1/sql.txt

Created May 1, 2015 08:07
Show Gist options
  • Save up1/d1f1653a753f92f97d75 to your computer and use it in GitHub Desktop.
Save up1/d1f1653a753f92f97d75 to your computer and use it in GitHub Desktop.
Download ZIP
How-old.net
Raw
sql.txt
SELECT
System.Timestamp AS OutTime,
Face.gender AS Gender,
Count(*) AS Count
FROM
StreamInput
GROUP BY HoppingWindow(second,10,1),
Face.gender
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment