blob: bb8698027d16fb496d6f27d19a723a0b2cb76b8a (
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
|
USE plato;
PRAGMA AnsiInForEmptyOrNullableItemsCollections = "true";
PRAGMA yt.MapJoinLimit="1m";
PRAGMA yt.LookupJoinLimit="64k";
PRAGMA yt.LookupJoinMaxRows="100";
insert into @T1
select Just('fooo'u) as ID order by ID;
insert into @T2
select 't' as text, '{}'y as tags, 'foo' as ID
order by ID;
commit;
$lost_ids = SELECT ID FROM @T2 WHERE ID NOT IN (SELECT ID FROM @T1);
$lost_samples_after_align = SELECT * FROM @T2 WHERE ID IN $lost_ids;
SELECT * FROM $lost_samples_after_align;
SELECT
text || 'a' as text,
tags,
FROM $lost_samples_after_align;
|
