set hive.explain.user=false; | |
set hive.stats.autogather=true; | |
CREATE TABLE sourceTable (one string,two string); | |
load data local inpath '../../data/files/kv1.txt' INTO TABLE sourceTable; | |
load data local inpath '../../data/files/kv3.txt' INTO TABLE sourceTable; | |
CREATE TABLE destinTable (two string) partitioned by (one string); | |
EXPLAIN INSERT OVERWRITE TABLE destinTable partition (one) SELECT one,two FROM sourceTable; | |
drop table destinTable; | |
drop table sourceTable; |