| --! qt:dataset:src |
| 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`; |