| --! qt:dataset:src |
| set hive.explain.user=false; |
| set hive.compute.query.using.stats=true; |
| |
| -- SORT_QUERY_RESULTS |
| |
| DROP TABLE insert_into1; |
| |
| CREATE TABLE insert_into1 (key int, value string); |
| |
| EXPLAIN INSERT INTO TABLE insert_into1 SELECT * from src ORDER BY key LIMIT 100; |
| INSERT INTO TABLE insert_into1 SELECT * from src ORDER BY key LIMIT 100; |
| SELECT SUM(HASH(c)) FROM ( |
| SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into1 |
| ) t; |
| explain |
| select count(*) from insert_into1; |
| select count(*) from insert_into1; |
| EXPLAIN INSERT INTO TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 100; |
| INSERT INTO TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 100; |
| SELECT SUM(HASH(c)) FROM ( |
| SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into1 |
| ) t; |
| |
| explain |
| SELECT COUNT(*) FROM insert_into1; |
| select count(*) from insert_into1; |
| |
| EXPLAIN INSERT OVERWRITE TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 10; |
| INSERT OVERWRITE TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 10; |
| SELECT SUM(HASH(c)) FROM ( |
| SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into1 |
| ) t; |
| |
| explain |
| SELECT COUNT(*) FROM insert_into1; |
| select count(*) from insert_into1; |
| |
| explain insert overwrite table insert_into1 select 1, 'a'; |
| insert overwrite table insert_into1 select 1, 'a'; |
| |
| explain insert into insert_into1 select 2, 'b'; |
| insert into insert_into1 select 2, 'b'; |
| |
| select * from insert_into1; |
| |
| set hive.stats.autogather=false; |
| explain |
| insert into table insert_into1 values(1, 'abc'); |
| insert into table insert_into1 values(1, 'abc'); |
| explain |
| SELECT COUNT(*) FROM insert_into1; |
| select count(*) from insert_into1; |
| |
| DROP TABLE insert_into1; |
| set hive.stats.autogather=true; |
| set hive.compute.query.using.stats=false; |