yt/yql/tests/sql/suites/optimizers/test_fuse_map_predicate_limit.yql


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

/* postgres can not */

$data = (
	SELECT key AS Key, YQL::Substring(key, 1, 1) AS Category FROM plato.Input0 WHERE length(key) > 2 LIMIT 20
);

SELECT
    Category,
    COUNT(*)
FROM $data
GROUP BY Category
ORDER BY Category ASC;