产品动态
公告
* | SELECT key FROM (subquery)
* | SELECT compare(PV, 86400) FROM (SELECT count(*) AS PV)
SELECT count(*) AS PV为第一层统计分析，针对原始日志统计获得网站访问量 PV。SELECT compare(PV, 86400) FROM为第二层统计分析，针对第一层统计分析的结果，对 PV 进行二次统计，使用 同环比函数compare 获得1天前的网站访问量 PV。* |SELECT compare[1] AS today, compare[2] AS yesterday, compare[3] AS ratioFROM (SELECT compare(PV, 86400) AS compareFROM (SELECT COUNT(*) AS PV))
SELECT compare[1] AS today, compare[2] AS yesterday, compare[3] AS ratio FROM 针对 compare 函数的结果，通过数组下标获取其中特定位置的数值。文档反馈