aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/hor_join/max_outtables.sql
blob: 0ce459d466de97e270372fbc6a82bd666dcba12d (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
/* syntax version 1 */
/* postgres can not */
/* kikimr can not */
pragma yt.MaxOutputTables="3";

$i1 = (SELECT CAST(key AS Int32) ?? 0 as key, '' as value FROM plato.Input1);
$i2 = (SELECT 0 as key, value from plato.Input2);
$i3 = (SELECT 1 as key, value from plato.Input3);
$i4 = (SELECT 2 as key, value from plato.Input4);
$i5 = (SELECT 3 as key, value from plato.Input5);


$udf = ($x) -> { return Yql::VariantItem($x) };

PROCESS $i1, $i2, $i3, $i4, $i5 using $udf(TableRow());