阿里云日志服务常用图标绘制SQL语句：

    1. * | SELECT Request_method, COUNT(*) as number GROUP BY Request_method LIMIT 10   (表格) 
    2. * | select time_series(__time__, '1m', '%H:%i:%s' ,'0') as Time, count(1) as PV, approx_distinct(IP) as UV group by Time order by Time limit 100  (线图)
    3. * | SELECT Request_method, COUNT(*) as number GROUP BY Request_method LIMIT 10   (柱状图)
    4. * | SELECT Request_method, COUNT(*) as number GROUP BY Request_method LIMIT 10   (条形图)
    5. * | SELECT Request_method, COUNT(*) as number GROUP BY Request_method LIMIT 10   (饼图)
    6. * | select time_series(__time__, '1m', '%H:%i:%s' ,'0') as Time, count(1) as PV, approx_distinct(IP) as UV group by time order by time limit 100  (面积图)
    7. * | SELECT COUNT(*) as PV  (单值图)
    8. * | SELECT COUNT(*) as PV   (进度条)
    9. * | select time_series(__time__, '15m', '%H:%i', '0') as T, count(1) as PV group by T order by T  (时间轴)
    10. * | SELECT ip_to_province(IP) AS Province, COUNT(*) as Count GROUP BY Province ORDER BY Count DESC LIMIT 10  (中国地图)
    11. * | SELECT ip_to_country(IP) AS Country, COUNT(*) as Count GROUP BY Country ORDER BY Count DESC LIMIT 2  (世界地图)
    12. * | SELECT ip_to_geo(IP) AS Geo, COUNT(*) as Count GROUP BY Geo ORDER BY Count DESC LIMIT 5  (高德地图)
    13. * | SELECT ip_to_geo(IP) AS Geo, COUNT(*) as Count GROUP BY Geo ORDER BY Count DESC LIMIT 5   (热力图)
    14. * | SELECT time_series(__time__, '1m', '%H:%i' ,'0') AS Time, count(1) AS count , Request_method GROUP BY Time, Request_method ORDER BY Time LIMIT 1000  (流图)
    15. * | select SourceValue, TargetValue, round(sum(StreamValue)) as StreamValue from (select SourceValue, TargetValue, StreamValue, __time__ from log group by SourceValue, TargetValue, StreamValue, __time__ order by __time__ desc) group by SourceValue, TargetValue  (桑基图)
    16. * | SELECT ip_to_province(IP) AS Province, COUNT(*) AS Count GROUP BY Province ORDER BY Count DESC LIMIT 10  (词云)
    17. * | SELECT ip_to_province(IP) AS Province, COUNT(*) AS Count GROUP BY Province ORDER BY Count DESC LIMIT 10   (矩形树图)
    18. * | SELECT "event.target" AS Target, count(1) AS Click_count GROUP BY Target ORDERY BY Click_count DESC    (漏斗图)
    19. * | select time_series(__time__, '1m', '%H:%i:%s' ,'0') as time, count(1) as PV, approx_distinct(IP) as UV group by time order by time limit 100  (色块图)
    1. CacheResponseStatus=200|SELECT ClientRequestHost,COUNT(*) AS HOSTS GROUP BY ClientRequestHost
    2. *|SELECT ClientRequestHost,COUNT(*) AS HOSTS GROUP BY ClientRequestHost
    3. *|SELECT ClientCountry,COUNT(*) AS Country GROUP BY ClientCountry ORDER BY 2 DESC limit 10