yt/yql/tests/sql/suites/aggregate/library_error_in_aggregation_fail.yql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

/* custom error: Expected numeric type, but got String */

USE plato;

select * from (
SELECT
    a.key as x, sum(b.value)
FROM Input as a
JOIN Input as b
USING (key)
GROUP BY a.key
) where x > "aaa"
ORDER BY x;

select 1;
select 1;
select 1;
select 1;
select 1;
select 1;