Machhindra
05/27/2021, 6:23 PMSELECT DATETIMECONVERT(metricTime, '1:MILLISECONDS:EPOCH', '1:MILLISECONDS:EPOCH', '1:MINUTES'),
AVG(metricValue) AS "AVG_1"
FROM metric_v6.metric_v6
WHERE metricTime >= 1621555200000
AND metricTime < 1622160000000
AND metric = 'CECCP%'
GROUP BY DATETIMECONVERT(metricTime, '1:MILLISECONDS:EPOCH', '1:MILLISECONDS:EPOCH', '1:MINUTES')
LIMIT 10000
Screenshot of the Superset SQL Editor -Mayank
Xiang Fu
Machhindra
05/28/2021, 2:20 PMXiang Fu
Machhindra
05/28/2021, 4:45 PMXiang Fu
Machhindra
05/28/2021, 5:24 PMXiang Fu
Machhindra
06/10/2021, 6:25 PMSELECT DATETIMECONVERT(metricTime, '1:MILLISECONDS:EPOCH', '1:MILLISECONDS:EPOCH', '1:DAYS'),
product,
metric,
count(metricValue) AS count_1
FROM metric_v7.metric_v7
WHERE (product = 'BLAH'
OR product = 'CLAH'
AND metric = 'AECCP%')
GROUP BY product,
metric,
DATETIMECONVERT(metricTime, '1:MILLISECONDS:EPOCH', '1:MILLISECONDS:EPOCH', '1:DAYS')
LIMIT 10000;
Xiang Fu
'AECCP%%'