summaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/pragma/release_temp_data_chain_pull.yql
blob: 8fd82074144d1d62e636963b9e67be3f4eab2e94 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
/* kikimr can not */
USE plato;

PRAGMA yt.ReleaseTempData="immediate";
PRAGMA yt.InflightTempTablesLimit="6";

DEFINE ACTION $action($param) AS

$key = CAST($param as String);

$a = "Input";
$b = (SELECT key,value FROM $a WHERE key != ($key || ".1") GROUP BY key, value ORDER BY value LIMIT 10);
$c = (SELECT key,value FROM $b WHERE key != ($key || ".2") GROUP BY key, value ORDER BY value LIMIT 10);
$d = (SELECT key,value FROM $c WHERE key != ($key || ".3") GROUP BY key, value ORDER BY value LIMIT 10);
$e = (SELECT key,value FROM $d WHERE key != ($key || ".4") GROUP BY key, value ORDER BY value LIMIT 10);
$f = (SELECT key,value FROM $e WHERE key != ($key || ".5") GROUP BY key, value ORDER BY value LIMIT 10);
$g = (SELECT key,value FROM $f WHERE key != ($key || ".6") GROUP BY key, value ORDER BY value LIMIT 10);

PROCESS $g;

END DEFINE;

EVALUATE FOR $param IN ListFromRange(1, 3) DO $action($param);