Advertisement
TDCustmerSupportJP

Untitled

Jul 3rd, 2017
12,392
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.25 KB | None | 0 0
  1. -- Fluentd の Data Collection に対応したサービスごとのPVをカウントしたい。
  2. SELECT td_title, COUNT(1) AS cnt
  3. FROM access_log
  4. WHERE
  5.   REGEXP_LIKE(td_title,'S3|Mongo|HDFS|Riak|Windows|RapsberryPi|GlusterFS|Norikra')
  6. GROUP BY td_title
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement