Dan Hill
05/02/2020, 4:33 AMpresto> select platform_id, customer_id, sum(clicks) as clicks, sum(impressions) as impressions, sum(cost_usd_micros) as cost_usd_micros from pinot.default.events_testing where platform_id = 1 and "customer_id" = 1 and "timestamp" >= date('2019-04-02') and "timestamp" < date('2020-01-16') group by platform_id, customer_id order by clicks desc, platform_id, customer_id desc limit 11;
platform_id | customer_id | clicks | impressions | cost_usd_micros
-------------+-------------+--------+-------------+-----------------
1 | 1 | 49 | 628 | 2497915
But removing customer_id
from the select and group by causes it to return no rows.
presto> select platform_id, sum(clicks) as clicks, sum(impressions) as impressions, sum(cost_usd_micros) as cost_usd_micros from pinot.default.events_testing where platform_id = 1 and "customer_id" = 1 and "timestamp" >= date('2019-04-02') and "timestamp" < date('2020-01-16') group by platform_id order by clicks desc, platform_id desc limit 11;
platform_id | clicks | impressions | cost_usd_micros
-------------+--------+-------------+-----------------
(0 rows)