Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Fluentd の Data Collection に対応したサービスごとのPVをカウントしたい。
- SELECT td_title, COUNT(1) AS cnt
- FROM access_log
- WHERE
- td_title LIKE '%S3%' OR
- td_title LIKE '%Mongo%' OR
- td_title LIKE '%HDFS%' OR
- td_title LIKE '%Riak%' OR
- td_title LIKE '%Windows%' OR
- td_title LIKE '%RapsberryPi%' OR
- td_title LIKE '%GlusterFS%' OR
- td_title LIKE '%Norikra%'
- GROUP BY td_title
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement