yql/essentials/tests/s-expressions/suites/Optimizers/ExtendWithFill.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

USE plato;

-- Should not generate single MrFill for all content
INSERT INTO Output
SELECT * from(
    select key, sum(cast(subkey as Uint32)) as value
    from Input group by key

    union all

    select "" as key, sum(cast(subkey as Uint32)) as value
    from Input-- group by key
);