We are testing looker over Presto and we found that total (distinct) calculations require additional (and sequential) queries. This is an issue because it harms the response time. There are some SQL model workarounds we could create but before that, I would like to know if:
- Is this only happening with presto?
- There is any enhancement planned?
- Are you guys using any workaround for this?
Thanks in advance!