This message was deleted.
# troubleshootings
Slackbot
03/14/2023, 6:59 AMThis message was deleted.
v
Vijay Narayanan
03/14/2023, 7:02 AMWhat is the query?
Vijay Narayanan
03/14/2023, 7:07 AMAre you using exact count distinct or approximate count distinct in druid?
b
BalaJi Devanaboina
03/14/2023, 7:08 AMNo we kept it as false.
BalaJi Devanaboina
03/14/2023, 7:08 AMNot this query very query is running slow in druid
BalaJi Devanaboina
03/14/2023, 7:08 AMComparing to trino
v
Vijay Narayanan
03/14/2023, 7:09 AMWe need to get on call. Are you ok for call at 530 pm?
b
BalaJi Devanaboina
03/14/2023, 7:10 AMWith our office laptop we can't join
s
Sergio Ferragut
03/14/2023, 2:51 PM@BalaJi Devanaboina One thought is that you are not filtering on __time which means that the query will need to examine all segments in order to produce the result. What relationship does "asdt" have with __time, if they are aligned, adding the filter also on __time should be a boost to performance. Also, how is the table's secondary partitioning?
2 Views