| --! qt:dataset:src |
| set hive.stats.autogather=true; |
| set datanucleus.cache.collections=false; |
| |
| set hive.merge.mapfiles=false; |
| set hive.merge.mapredfiles=false; |
| |
| CREATE TABLE stats_non_partitioned (key string, value string); |
| |
| explain extended |
| insert overwrite table stats_non_partitioned |
| select * from src; |
| |
| insert overwrite table stats_non_partitioned |
| select * from src; |
| |
| desc extended stats_non_partitioned; |
| |
| select * from stats_non_partitioned; |
| |
| |
| CREATE TABLE stats_partitioned(key string, value string) partitioned by (ds string); |
| |
| explain |
| insert overwrite table stats_partitioned partition (ds='1') |
| select * from src; |
| |
| insert overwrite table stats_partitioned partition (ds='1') |
| select * from src; |
| |
| show partitions stats_partitioned; |
| select * from stats_partitioned where ds is not null; |
| |
| describe extended stats_partitioned partition (ds='1'); |
| describe extended stats_partitioned; |
| |
| |
| set hive.merge.mapfiles=true; |
| set hive.merge.mapredfiles=true; |
| |
| drop table stats_non_partitioned; |
| drop table stats_partitioned; |
| |
| CREATE TABLE stats_non_partitioned (key string, value string); |
| |
| explain extended |
| insert overwrite table stats_non_partitioned |
| select * from src; |
| |
| insert overwrite table stats_non_partitioned |
| select * from src; |
| |
| desc extended stats_non_partitioned; |
| |
| select * from stats_non_partitioned; |
| |
| |
| CREATE TABLE stats_partitioned(key string, value string) partitioned by (ds string); |
| |
| explain |
| insert overwrite table stats_partitioned partition (ds='1') |
| select * from src; |
| |
| insert overwrite table stats_partitioned partition (ds='1') |
| select * from src; |
| |
| show partitions stats_partitioned; |
| select * from stats_partitioned where ds is not null; |
| |
| describe extended stats_partitioned partition (ds='1'); |
| describe extended stats_partitioned; |