This message was deleted.
# troubleshootings
Slackbot
11/09/2022, 8:56 PMThis message was deleted.
r
Renato Santos
11/09/2022, 10:03 PMit supports
AggregateFn(...) filter (where Y)count(1) filter ( where httpRspCode not like '5%') as successRatek
Kai Sun
11/09/2022, 10:05 PMThen do we support the first, aka
Copy code
SELECT
COUNT(CASE WHEN httpRspCode not like '5%' THEN 1 ELSE NULL END)
From tabler
Renato Santos
11/09/2022, 10:06 PMI think yes, but the null may throw out all the results, usually I do sum(case when X then 1 else 0 end) when doing these
k
Kai Sun
11/09/2022, 10:08 PMRight. The intentions is to throw out when WHEN condition is not met. Same effects as
sum(case when X then 1 else 0 end)Kai Sun
11/09/2022, 10:08 PMDo they have same performance or any other performance difference?
r
Renato Santos
11/09/2022, 10:08 PM Copy code
COUNT(CASE WHEN mm not like '5%' THEN 1 ELSE NULL END) as a,
sum(CASE WHEN mm not like '5%' THEN 1 ELSE 0 END) as b,
COUNT(1) as c,
sum(CASE WHEN mm not like '5%' THEN 1 ELSE 1 END) as dRenato Santos
11/09/2022, 10:09 PMDo they have same performance or any other performance difference?As far as I'm aware, it should be very little difference, most of the work will depends on your entire query condition and the how many segments you can exclude using the __time column the
col like 'Y%'Renato Santos
11/09/2022, 10:15 PMboth A and B column generates the same execution plan, so there's no difference
k
Kai Sun
11/09/2022, 10:15 PMright. Thx for the info.
r
Renato Santos
11/09/2022, 10:21 PM Copy code
count(1) filter (where mm not like '5%') as X3 Views