blob: 80aaedfb0a3d428b8f9b4163be52d5cd06d14754 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
|
USE plato;
PRAGMA yt.JoinMergeForce = "1";
pragma yt.JoinMergeTablesLimit="10";
SELECT a.key as key1
FROM (SELECT * FROM plato.Input1 WHERE subkey != "bar") AS a
JOIN (SELECT * FROM plato.Input1 WHERE subkey != "foo") AS b ON a.key = b.key
WHERE a.key != "1" OR b.key != "2";
|
