--! qt:dataset:src
set hive.map.aggr=false;
set hive.stats.column.autogather=true;

CREATE TABLE DEST1_n52(key INT, value STRING) STORED AS TEXTFILE;

create table s_n129 as select * from src where key='10';

explain FROM S_n129
INSERT OVERWRITE TABLE DEST1_n52 SELECT key, sum(SUBSTR(value,5)) GROUP BY key
;

FROM S_n129
INSERT OVERWRITE TABLE DEST1_n52 SELECT key, sum(SUBSTR(value,5)) GROUP BY key
;

desc formatted DEST1_n52;

desc formatted DEST1_n52 key;
desc formatted DEST1_n52 value;