yql/essentials/tests/sql/suites/optimizers/yql-9297_publish_ytcopy.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

/* postgres can not */
/* multirun can not */
/* kikimr can not - table truncate */
USE plato;

INSERT INTO @a
SELECT *
FROM Input
WHERE key < "100"
ORDER BY key DESC;

COMMIT;

INSERT INTO Output
SELECT *
FROM @a
ORDER BY key DESC;

COMMIT;

SELECT *
FROM Output;