This questions was asked on the Trino Slack.
I noticed a weird thing while using trino-pinot. Whenever I execute query 1 it takes a lot of time to execute and whenever I execute query 2 I get the results instantaneously, although both the queries are similar.
Can you please suggest as to why this is happening.
-- query 1
select sum(c1), 'Total' as total
from table_name
where dt >= '20210401'
and dt <= '20210630'
group by 'Total';
Query 20210927_114139_00025_hxt48, FINISHED, 3 nodes
Splits: 200 total, 200 done (100.00%)
41.78 [827M rows, 6.16GB] [19.8M rows/s, 151MB/s]
-- query 2
select sum(c1), 'Total' as total
from table_name
where dt >= '20210401'
and dt <= '20210630'
;
Query 20210927_114543_00026_hxt48, FINISHED, 1 node
Splits: 9 total, 9 done (100.00%)
0.70 [1 rows, 9B] [1 rows/s, 13B/s]