yql/essentials/tests/sql/suites/aggregate/table_row_aggregation.sql


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

/* syntax version 1 */
/* postgres can not */
USE plato;

$data = (
  SELECT SOME(TableRow())
  FROM Input4
  GROUP BY key
);

SELECT *
FROM $data
FLATTEN COLUMNS
ORDER BY key;