![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Druid.io
dinghua_xuexi
这个作者很懒,什么都没留下…
展开
-
SuperSet 查询Druid.io 时区转换查询
SELECT FLOOR(TIMESTAMPADD(HOUR, 8, __time) TO DAY) AS "__timestamp", "room_id" AS "room_id", "game_type" AS "game_type", "game_mode" AS "game_mode", TIME_FORMAT(MILLIS_TO_TIMESTAMP(MIN(start_time_min)*1000), 'yyyy-MM-dd HH:mm:s.原创 2022-03-31 10:26:33 · 406 阅读 · 0 评论 -
Redash 查询 druid.io 时区转换
select dms1, event, SUM("count") AS pvFROM "apprizhi-app_statistic"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='.原创 2022-03-31 10:04:00 · 448 阅读 · 0 评论 -
Druid.io 查询分时段指标
{ "aggregations": [ { "fieldName": "unique_user", "type": "thetaSketch", "name": "new_user", "isInputThetaSketch": false, "size": 16384 } ], .原创 2020-05-22 17:13:01 · 443 阅读 · 0 评论 -
Druid SQL:列名和sql关键字重名解决办法
问题描述由于历史遗留,设计druid schema 的时候,metrics里面设计了一个count指标,列名也定为了count。在使用sql查询该数据源时,由于count时sql 函数,对该数据源的count进行操作时,如果不采取措施,导致无法使用该字段。问题演示现在需要对count列进行求和运算,如果和其他普通字段一样,不进行特殊处理,sql语句如下select SUM(share_count_sum) as share_count,SUM(count) as pv,topic_id f原创 2020-05-21 15:50:23 · 1933 阅读 · 0 评论