path: root/yql/essentials/tests/sql/suites/flatten_by/flatten_expr_where.yql

$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) WHERE bb != "h" ORDER BY a,bb;