yql/essentials/tests/sql/suites/insert_monotonic/truncate_and_append.sql


1
2
3
4
5
6
7
8
9

USE plato;

INSERT INTO Output WITH TRUNCATE
SELECT * FROM Input1
ORDER BY key, subkey;

INSERT INTO Output WITH MONOTONIC_KEYS
SELECT * FROM Input2
ORDER BY key, subkey;