aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/s-expressions/suites/EquiJoin/EquiOptKey2LeftSelfInt.yqls
blob: 924287c0f9b235d1aebbb56440beb07df9c79b3c (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
(
(let mr_source (DataSource 'yt 'plato))
(let x (Read! world mr_source (Key '('table (String 'InputSelf2))) '('key 'subkey 'value) '()))
(let world (Left! x))
(let table (Right! x))
(let tableOptKVInt (Map table (lambda '(row) (block '(
   (return (AsStruct
     '('key (FromString (Member row 'key) 'Uint32))
     '('subkey (Just (Member row 'subkey)))
     '('value (FromString (Member row 'value) 'Uint32))
   ))
)))))
(let tableKVInt (Map table (lambda '(row) (block '(
   (return (AsStruct
     '('key (Coalesce (FromString (Member row 'key) 'Uint32) (Uint32 '888)))
     '('subkey (Just (Member row 'subkey)))
     '('value (Coalesce (FromString (Member row 'value) 'Uint32) (Uint32 '999)))
   ))
)))))
(let join (EquiJoin '(tableKVInt 'a) '(tableOptKVInt 'b) '('Left '"a" '"b" '('"a" '"key") '('"b" '"value" ) '()) '()))
(let res_sink (DataSink 'result))
(let sortDir '((Bool 'true) (Bool 'true) (Bool 'true) (Bool 'true)))
(let keySelector (lambda '(row) '((Member row '"a.key") (Member row '"a.subkey") (Member row '"b.key") (Member row '"b.subkey"))))
(let world (Write! world res_sink (Key) (Sort join sortDir keySelector) '('('type))))
(let world (Commit! world res_sink))
(return world)
)