yql/essentials/tests/sql/suites/optimizers/test_fuse_map_take.sql


1
2
3
4
5
6
7
8
9
10

/* postgres can not */
$data = (
	SELECT key AS Name, value AS Value FROM plato.Input0
);

$filtered = (
	SELECT * FROM $data WHERE Name != "BadName" LIMIT 10
);

SELECT Name, Avg(Length(Value)) AS Len FROM $filtered GROUP BY Name ORDER BY Name;