| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.map.aggr=true; |
| set hive.groupby.skewindata=false; |
| set mapred.reduce.tasks=31; |
| |
| CREATE TABLE dest1_n68(c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 DOUBLE, c6 DOUBLE, c7 DOUBLE, c8 DOUBLE, c9 DOUBLE, c10 DOUBLE, c11 DOUBLE) STORED AS TEXTFILE; |
| |
| EXPLAIN |
| FROM src |
| INSERT OVERWRITE TABLE dest1_n68 SELECT |
| sum(substr(src.value,5)), |
| avg(substr(src.value,5)), |
| avg(DISTINCT substr(src.value,5)), |
| max(substr(src.value,5)), |
| min(substr(src.value,5)), |
| std(substr(src.value,5)), |
| stddev_samp(substr(src.value,5)), |
| variance(substr(src.value,5)), |
| var_samp(substr(src.value,5)), |
| sum(DISTINCT substr(src.value, 5)), |
| count(DISTINCT substr(src.value, 5)); |
| |
| FROM src |
| INSERT OVERWRITE TABLE dest1_n68 SELECT |
| sum(substr(src.value,5)), |
| avg(substr(src.value,5)), |
| avg(DISTINCT substr(src.value,5)), |
| max(substr(src.value,5)), |
| min(substr(src.value,5)), |
| std(substr(src.value,5)), |
| stddev_samp(substr(src.value,5)), |
| variance(substr(src.value,5)), |
| var_samp(substr(src.value,5)), |
| sum(DISTINCT substr(src.value, 5)), |
| count(DISTINCT substr(src.value, 5)); |
| |
| SELECT dest1_n68.* FROM dest1_n68; |