blob: 1be595ca176ecb0827e5ab90403c02ba9f21d635 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
USE plato;
PRAGMA yt.JoinMergeForce = "1";
pragma yt.JoinMergeTablesLimit="10";
$join =
SELECT a.key as key1, a.subkey as subkey1
FROM (SELECT * FROM Input8 WHERE subkey != "bar") AS a
JOIN (SELECT * FROM Input8 WHERE subkey != "foo") AS b
ON a.key = b.key AND a.subkey = b.subkey;
SELECT key1, subkey1, count(*)
FROM $join
GROUP COMPACT BY subkey1, key1;
SELECT key1, subkey1
FROM $join
GROUP COMPACT BY key1, subkey1;
|
