yql/essentials/tests/sql/suites/flatten_by/flatten_expr.sql


1
2
3
4
5
6
7

/* syntax version 1 */
/* postgres can not */

$data = SELECT "a,b,c,d" AS a, "e,f,g,h" AS b, "x" AS c;

SELECT a,bb,c FROM $data FLATTEN BY (String::SplitToList(a, ",") as a, String::SplitToList(b, ",") as bb) ORDER BY a,bb;