lgbo-ustc commented on issue #5904:
URL:
https://github.com/apache/incubator-gluten/issues/5904#issuecomment-2136465890
adding a post projections doesn't seem to make too much overhead.
```sql
f2386dc7dd0d :) select a, if(isNaN(dev), null, dev) from(select a,
stddev_samp(b) as dev from (select number as a , number % 111 as b from
numbers(10000000)) group by a) Format Null settings max_threads=1
SELECT
a,
if(isNaN(dev), NULL, dev)
FROM
(
SELECT
a,
stddev_samp(b) AS dev
FROM
(
SELECT
number AS a,
number % 111 AS b
FROM numbers(10000000)
)
GROUP BY a
)
FORMAT `Null`
SETTINGS max_threads = 1
Query id: 49a4b5ec-1be6-4f15-9332-f3e4f637aeb1
Ok.
0 rows in set. Elapsed: 1.240 sec. Processed 10.00 million rows, 80.00 MB
(8.06 million rows/s., 64.49 MB/s.)
Peak memory usage: 769.10 MiB.
f2386dc7dd0d :) select a, stddev_samp(b) as dev from (select number as a ,
number % 111 as b from numbers(10000000)) group by a Format Null settings
max_threads=1;
SELECT
a,
stddev_samp(b) AS dev
FROM
(
SELECT
number AS a,
number % 111 AS b
FROM numbers(10000000)
)
GROUP BY a
FORMAT `Null`
SETTINGS max_threads = 1
Query id: cfcca2c4-a437-4f5b-99ac-a7cbc1c24a20
Ok.
0 rows in set. Elapsed: 1.235 sec. Processed 10.00 million rows, 80.00 MB
(8.09 million rows/s., 64.76 MB/s.)
Peak memory usage: 769.10 MiB.
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
