--! qt:dataset:src
set hive.merge.smallfiles.avgsize=16000000;

DROP TABLE insert_into4a;
DROP TABLE insert_into4b;

CREATE TABLE insert_into4a (key int, value string);
CREATE TABLE insert_into4b (key int, value string);

EXPLAIN INSERT INTO TABLE insert_into4a SELECT * FROM src LIMIT 10;
INSERT INTO TABLE insert_into4a SELECT * FROM src LIMIT 10;
SELECT SUM(HASH(c)) FROM (
    SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into4a
) t;

EXPLAIN INSERT INTO TABLE insert_into4a SELECT * FROM src LIMIT 10;
INSERT INTO TABLE insert_into4a SELECT * FROM src LIMIT 10;
SELECT SUM(HASH(c)) FROM (
    SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into4a
) t;

--At this point insert_into4a has 2 files (if INSERT INTO merges isn't fixed)

EXPLAIN INSERT INTO TABLE insert_into4b SELECT * FROM insert_into4a;
INSERT INTO TABLE insert_into4b SELECT * FROM insert_into4a;
SELECT SUM(HASH(c)) FROM (
    SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into4b
) t;

DROP TABLE insert_into4a;
DROP TABLE insert_into4b;