yql/essentials/tests/sql/suites/blocks/combine_all_sum.sql


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

USE plato;

SELECT
    sum(key),
    sum(cast(key as int8)),
    sum(cast(key as uint16)),
    sum(cast(key as int32)),
    sum(1u/0u),
    sum(2),
    sum(if(key=10u,key)),
    sum(if(key=100u,key))
FROM Input