tkuchiki/query.md

Last active June 13, 2017 03:23

Star (0) 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/tkuchiki/76bda4ca36b16e513c897afe6619d57f.js"></script>
Save tkuchiki/76bda4ca36b16e513c897afe6619d57f to your computer and use it in GitHub Desktop.

Norikra でクエリの実行結果(event)を別のクエリで処理する

Raw

-- QUERY:{"name":"filtered_username","group":"LOOPBACK(filtered_username)","targets":["users"],"suspended":false}
SELECT id, username, age
  FROM users.win:time_batch(1 min)
  WHERE username LIKE 'foobar%'

-- QUERY:{"name":"user_count","group":"STDOUT()","targets":[],"suspended":false}
SELECT
  COUNT(*) AS cnt,
  COUNT(*) / 60.0 AS cnt_per_sec
  FROM filtered_username.win:time_batch(1 min)