SELECT
dms1,
event,
SUM("count") AS pv
FROM
"appdatasource"
WHERE
TIMESTAMPADD(HOUR, 8, __time) >= TIME_PARSE('{{ start_date }}T00:00:00')
AND TIMESTAMPADD(HOUR, 8, __time) < TIME_PARSE('{{ end_date }}T00:00:00')
AND appkey='appkey1111' AND dms1='{{ user_id }}' AND event='{{ event_id }}'
GROUP BY dms1,event
SELECT
dms1,
SUM("count") AS pv
FROM
"appdatasource"
WHERE
TIMESTAMPADD(HOUR, 8, __time) >= TIME_PARSE('{{ start_date }}T00:00:00')
AND TIMESTAMPADD(HOUR, 8, __time) < TIME_PARSE('{{ end_date }}T00:00:00')
AND appkey='appkey11111' AND event='taskend'
GROUP BY dms1
Redash 查询 druid.io 时区转换
于 2022-03-31 10:04:00 首次发布