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


1
2
3
4
5
6
7
8
9

/* ytfile can not */
/* dqfile can not */
USE plato;

INSERT INTO Output WITH MONOTONIC_KEYS
SELECT key, subkey, some(value) as value
FROM Input
GROUP BY key, subkey
ORDER BY key, subkey;