DROP TABLE insert;

CREATE TABLE insert (key INT, as STRING);

EXPLAIN INSERT INTO TABLE insert SELECT * FROM src LIMIT 100;
INSERT INTO TABLE insert SELECT * FROM src LIMIT 100;
SELECT SUM(HASH(hash)) FROM (
    SELECT TRANSFORM(*) USING 'tr \t _' AS (hash) FROM insert
) t;

EXPLAIN INSERT INTO TABLE insert SELECT * FROM src LIMIT 100;
INSERT INTO TABLE insert SELECT * FROM src LIMIT 100;
SELECT SUM(HASH(sum)) FROM (
    SELECT TRANSFORM(*) USING 'tr \t _' AS (sum) FROM insert
) t;

SELECT COUNT(*) FROM insert;

EXPLAIN INSERT OVERWRITE TABLE insert SELECT * FROM src LIMIT 10;
INSERT OVERWRITE TABLE insert SELECT * FROM src LIMIT 10;
SELECT SUM(HASH(add)) FROM (
    SELECT TRANSFORM(*) USING 'tr \t _' AS (add) FROM insert
) t;


DROP TABLE insert;