yql/essentials/tests/sql/suites/join/premap_nonseq_flatmap.sql


1
2
3
4
5
6
7
8
9
10
11

PRAGMA DisableSimpleColumns;
use plato;

$hashes = (
  SELECT multiplier AS hash
  FROM (SELECT ListFromRange(0, 3) AS multiplier)
  FLATTEN BY multiplier
);

SELECT * FROM Input1 AS a CROSS JOIN $hashes AS h
ORDER BY a.key,a.subkey,h.hash;