yql/essentials/tests/sql/suites/weak_field/weak_field_aggregation.sql


1
2
3
4
5
6
7
8
9
10

/* postgres can not */
USE plato;

--INSERT INTO Output
SELECT
  odd,
  sum(WeakField(data3, "int32") + WeakField(datahole3, "uint32", 999)) as score
FROM Input4
GROUP BY cast(subkey as uint32) % 2 as odd
ORDER BY odd, score