Saving all output to "!!{outputDirectory}!!/groupby3_map_multi_distinct.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/groupby3_map_multi_distinct.q >>> set hive.map.aggr=true; No rows affected >>> set hive.groupby.skewindata=false; No rows affected >>> set mapred.reduce.tasks=31; No rows affected >>> >>> CREATE TABLE dest1(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; No rows affected >>> >>> EXPLAIN FROM src INSERT OVERWRITE TABLE dest1 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)); 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI avg (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION std (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION stddev_samp (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION variance (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION var_samp (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))))))' '' 'STAGE DEPENDENCIES:' ' Stage-1 is a root stage' ' Stage-0 depends on stages: Stage-1' ' Stage-2 depends on stages: Stage-0' '' 'STAGE PLANS:' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src ' ' TableScan' ' alias: src' ' Select Operator' ' expressions:' ' expr: value' ' type: string' ' outputColumnNames: value' ' Group By Operator' ' aggregations:' ' expr: sum(substr(value, 5))' ' expr: avg(substr(value, 5))' ' expr: avg(DISTINCT substr(value, 5))' ' expr: max(substr(value, 5))' ' expr: min(substr(value, 5))' ' expr: std(substr(value, 5))' ' expr: stddev_samp(substr(value, 5))' ' expr: variance(substr(value, 5))' ' expr: var_samp(substr(value, 5))' ' expr: sum(DISTINCT substr(value, 5))' ' expr: count(DISTINCT substr(value, 5))' ' bucketGroup: false' ' keys:' ' expr: substr(value, 5)' ' type: string' ' mode: hash' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' sort order: +' ' tag: -1' ' value expressions:' ' expr: _col1' ' type: double' ' expr: _col2' ' type: struct' ' expr: _col3' ' type: struct' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col6' ' type: struct' ' expr: _col7' ' type: struct' ' expr: _col8' ' type: struct' ' expr: _col9' ' type: struct' ' expr: _col10' ' type: double' ' expr: _col11' ' type: bigint' ' Reduce Operator Tree:' ' Group By Operator' ' aggregations:' ' expr: sum(VALUE._col0)' ' expr: avg(VALUE._col1)' ' expr: avg(DISTINCT KEY._col0:0._col0)' ' expr: max(VALUE._col3)' ' expr: min(VALUE._col4)' ' expr: std(VALUE._col5)' ' expr: stddev_samp(VALUE._col6)' ' expr: variance(VALUE._col7)' ' expr: var_samp(VALUE._col8)' ' expr: sum(DISTINCT KEY._col0:1._col0)' ' expr: count(DISTINCT KEY._col0:2._col0)' ' bucketGroup: false' ' mode: mergepartial' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10' ' Select Operator' ' expressions:' ' expr: _col0' ' type: double' ' expr: _col1' ' type: double' ' expr: _col2' ' type: double' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: double' ' expr: _col6' ' type: double' ' expr: _col7' ' type: double' ' expr: _col8' ' type: double' ' expr: _col9' ' type: double' ' expr: _col10' ' type: bigint' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10' ' Select Operator' ' expressions:' ' expr: _col0' ' type: double' ' expr: _col1' ' type: double' ' expr: _col2' ' type: double' ' expr: UDFToDouble(_col3)' ' type: double' ' expr: UDFToDouble(_col4)' ' type: double' ' expr: _col5' ' type: double' ' expr: _col6' ' type: double' ' expr: _col7' ' type: double' ' expr: _col8' ' type: double' ' expr: _col9' ' type: double' ' expr: UDFToDouble(_col10)' ' type: double' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10' ' File Output Operator' ' compressed: false' ' GlobalTableId: 1' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: groupby3_map_multi_distinct.dest1' '' ' Stage: Stage-0' ' Move Operator' ' tables:' ' replace: true' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: groupby3_map_multi_distinct.dest1' '' ' Stage: Stage-2' ' Stats-Aggr Operator' '' '' 158 rows selected >>> >>> FROM src INSERT OVERWRITE TABLE dest1 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)); '_col0','_col1','_col2','_col3','_col4','_col5','_col6','_col7','_col8','_col9','_col10' No rows selected >>> >>> SELECT dest1.* FROM dest1; 'c1','c2','c3','c4','c5','c6','c7','c8','c9','c10','c11' '130091.0','260.182','256.10355987055016','98.0','0.0','142.9268095075238','143.06995106518906','20428.072876','20469.01089779559','79136.0','309.0' 1 row selected >>> !record