blob: e91ef8f7c2f73a781e8ac72a84b030ed4dee6100 (
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
24
25
26
27
28
|
USE plato;
PRAGMA DisableSimpleColumns;
PRAGMA yt.LookupJoinLimit="64k";
PRAGMA yt.LookupJoinMaxRows="100";
$campaigns_data = AsList(
AsStruct(Just(1) as id),
AsStruct(Just(2) as id));
$strategies_data = AsList(
AsStruct(Just(1) as id),
AsStruct(Just(2) as id));
$lottery_data = AsList(
AsStruct(Just(1) as id, Just(2) as campaign_id, Just(3) as strategy_id));
INSERT INTO @campaigns SELECT * FROM AS_TABLE($campaigns_data) ORDER BY id;
INSERT INTO @strategies SELECT * FROM AS_TABLE($strategies_data) ORDER BY id;
INSERT INTO @lottery SELECT * FROM AS_TABLE($lottery_data) ORDER BY id;
COMMIT;
SELECT
lottery.id AS lottery_id
FROM @lottery AS lottery
JOIN @campaigns AS campaigns ON lottery.campaign_id = campaigns.id
JOIN @strategies AS strategies ON lottery.strategy_id = strategies.id
|
