Modified: hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_limit.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_limit.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_limit.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_limit.q.out Thu Aug 7 00:21:45 2014 @@ -59,27 +59,11 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@loc_orc #### A masked pattern was here #### PREHOOK: query: -- numRows: 8 rawDataSize: 796 -explain extended select * from loc_orc +explain select * from loc_orc PREHOOK: type: QUERY POSTHOOK: query: -- numRows: 8 rawDataSize: 796 -explain extended select * from loc_orc +explain select * from loc_orc POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - loc_orc - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_ALLCOLREF - - STAGE DEPENDENCIES: Stage-0 is a root stage @@ -91,7 +75,6 @@ STAGE PLANS: TableScan alias: loc_orc Statistics: Num rows: 8 Data size: 796 Basic stats: COMPLETE Column stats: COMPLETE - GatherStats: false Select Operator expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: int) outputColumnNames: _col0, _col1, _col2, _col3 @@ -99,29 +82,11 @@ STAGE PLANS: ListSink PREHOOK: query: -- numRows: 4 rawDataSize: 396 -explain extended select * from loc_orc limit 4 +explain select * from loc_orc limit 4 PREHOOK: type: QUERY POSTHOOK: query: -- numRows: 4 rawDataSize: 396 -explain extended select * from loc_orc limit 4 +explain select * from loc_orc limit 4 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - loc_orc - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_ALLCOLREF - TOK_LIMIT - 4 - - STAGE DEPENDENCIES: Stage-0 is a root stage @@ -133,7 +98,6 @@ STAGE PLANS: TableScan alias: loc_orc Statistics: Num rows: 8 Data size: 796 Basic stats: COMPLETE Column stats: COMPLETE - GatherStats: false Select Operator expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: int) outputColumnNames: _col0, _col1, _col2, _col3 @@ -145,30 +109,12 @@ STAGE PLANS: PREHOOK: query: -- greater than the available number of rows -- numRows: 8 rawDataSize: 796 -explain extended select * from loc_orc limit 16 +explain select * from loc_orc limit 16 PREHOOK: type: QUERY POSTHOOK: query: -- greater than the available number of rows -- numRows: 8 rawDataSize: 796 -explain extended select * from loc_orc limit 16 +explain select * from loc_orc limit 16 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - loc_orc - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_ALLCOLREF - TOK_LIMIT - 16 - - STAGE DEPENDENCIES: Stage-0 is a root stage @@ -180,7 +126,6 @@ STAGE PLANS: TableScan alias: loc_orc Statistics: Num rows: 8 Data size: 796 Basic stats: COMPLETE Column stats: COMPLETE - GatherStats: false Select Operator expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: int) outputColumnNames: _col0, _col1, _col2, _col3 @@ -191,29 +136,11 @@ STAGE PLANS: ListSink PREHOOK: query: -- numRows: 0 rawDataSize: 0 -explain extended select * from loc_orc limit 0 +explain select * from loc_orc limit 0 PREHOOK: type: QUERY POSTHOOK: query: -- numRows: 0 rawDataSize: 0 -explain extended select * from loc_orc limit 0 +explain select * from loc_orc limit 0 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - loc_orc - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_ALLCOLREF - TOK_LIMIT - 0 - - STAGE DEPENDENCIES: Stage-0 is a root stage @@ -225,7 +152,6 @@ STAGE PLANS: TableScan alias: loc_orc Statistics: Num rows: 8 Data size: 796 Basic stats: COMPLETE Column stats: COMPLETE - GatherStats: false Select Operator expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: int) outputColumnNames: _col0, _col1, _col2, _col3
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out Thu Aug 7 00:21:45 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_select.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_select.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_select.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_select.q.out Thu Aug 7 00:21:45 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_table.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_table.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_table.q.out Thu Aug 7 00:21:45 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_union.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_union.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_union.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_union.q.out Thu Aug 7 00:21:45 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/columnstats_partlvl.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/columnstats_partlvl.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/columnstats_partlvl.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/columnstats_partlvl.q.out Thu Aug 7 00:21:45 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/combine2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/combine2.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/combine2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/combine2.q.out Thu Aug 7 00:21:45 2014 @@ -671,12 +671,12 @@ STAGE PLANS: keys: ds (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 0 Data size: 23248 Basic stats: PARTIAL Column stats: COMPLETE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 0 Data size: 23248 Basic stats: PARTIAL Column stats: COMPLETE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/groupby_sort_11.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/groupby_sort_11.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/groupby_sort_11.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/groupby_sort_11.q.out Thu Aug 7 00:21:45 2014 @@ -395,11 +395,11 @@ STAGE PLANS: keys: 1 (type: int) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 10 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 10 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE Reduce Operator Tree: Group By Operator aggregations: count(DISTINCT KEY._col0:0._col0) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input24.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input24.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/input24.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/input24.q.out Thu Aug 7 00:21:45 2014 @@ -28,9 +28,9 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE Select Operator - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE Group By Operator aggregations: count(1) mode: hash Modified: hive/branches/cbo/ql/src/test/results/clientpositive/input25.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/input25.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/input25.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/input25.q.out Thu Aug 7 00:21:45 2014 @@ -45,14 +45,14 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: a (type: int), b (type: int), d (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Limit Number of rows: 10 - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Reduce Output Operator sort order: Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -109,14 +109,14 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: a (type: int), b (type: int), d (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Limit Number of rows: 10 - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Reduce Output Operator sort order: Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/metadataonly1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/metadataonly1.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/metadataonly1.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/metadataonly1.q.out Thu Aug 7 00:21:45 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out Thu Aug 7 00:21:45 2014 @@ -129,9 +129,9 @@ STAGE PLANS: Map Operator Tree: TableScan alias: tstparttbl2 - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE Select Operator - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE Group By Operator aggregations: count(1) mode: hash @@ -325,9 +325,9 @@ STAGE PLANS: Map Operator Tree: TableScan alias: tstparttbl2 - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE Select Operator - Statistics: Num rows: 0 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE Group By Operator aggregations: count(1) mode: hash Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_columnar.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_columnar.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_columnar.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_columnar.q.out Thu Aug 7 00:21:45 2014 @@ -29,14 +29,16 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@parquet_columnar_access_stage PREHOOK: query: CREATE TABLE parquet_columnar_access ( s string, - i int, + x int, + y int, f float ) STORED AS PARQUET PREHOOK: type: CREATETABLE PREHOOK: Output: database:default POSTHOOK: query: CREATE TABLE parquet_columnar_access ( s string, - i int, + x int, + y int, f float ) STORED AS PARQUET POSTHOOK: type: CREATETABLE @@ -50,17 +52,18 @@ POSTHOOK: query: LOAD DATA LOCAL INPATH POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@parquet_columnar_access_stage -PREHOOK: query: INSERT OVERWRITE TABLE parquet_columnar_access SELECT * FROM parquet_columnar_access_stage +PREHOOK: query: INSERT OVERWRITE TABLE parquet_columnar_access SELECT s, i, (i + 1), f FROM parquet_columnar_access_stage PREHOOK: type: QUERY PREHOOK: Input: default@parquet_columnar_access_stage PREHOOK: Output: default@parquet_columnar_access -POSTHOOK: query: INSERT OVERWRITE TABLE parquet_columnar_access SELECT * FROM parquet_columnar_access_stage +POSTHOOK: query: INSERT OVERWRITE TABLE parquet_columnar_access SELECT s, i, (i + 1), f FROM parquet_columnar_access_stage POSTHOOK: type: QUERY POSTHOOK: Input: default@parquet_columnar_access_stage POSTHOOK: Output: default@parquet_columnar_access POSTHOOK: Lineage: parquet_columnar_access.f SIMPLE [(parquet_columnar_access_stage)parquet_columnar_access_stage.FieldSchema(name:f, type:float, comment:null), ] -POSTHOOK: Lineage: parquet_columnar_access.i SIMPLE [(parquet_columnar_access_stage)parquet_columnar_access_stage.FieldSchema(name:i, type:int, comment:null), ] POSTHOOK: Lineage: parquet_columnar_access.s SIMPLE [(parquet_columnar_access_stage)parquet_columnar_access_stage.FieldSchema(name:s, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_columnar_access.x SIMPLE [(parquet_columnar_access_stage)parquet_columnar_access_stage.FieldSchema(name:i, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_columnar_access.y EXPRESSION [(parquet_columnar_access_stage)parquet_columnar_access_stage.FieldSchema(name:i, type:int, comment:null), ] PREHOOK: query: SELECT * FROM parquet_columnar_access PREHOOK: type: QUERY PREHOOK: Input: default@parquet_columnar_access @@ -69,32 +72,32 @@ POSTHOOK: query: SELECT * FROM parquet_c POSTHOOK: type: QUERY POSTHOOK: Input: default@parquet_columnar_access #### A masked pattern was here #### -1abc00 1 1.0 -1def01 2 1.1 -1ghi02 3 1.2 -1jkl03 1 1.3 -1mno04 2 1.4 -1pqr05 3 1.0 -1stu06 1 1.1 -1vwx07 2 1.2 -1yza08 3 1.3 -1bcd09 1 1.4 -1efg10 2 1.0 -1hij11 3 1.1 -1klm12 1 1.2 -1nop13 2 1.3 -1qrs14 3 1.4 -1tuv15 1 1.0 -1wxy16 2 1.1 -1zab17 3 1.2 -1cde18 1 1.3 -1fgh19 2 1.4 -1ijk20 3 1.0 -PREHOOK: query: ALTER TABLE parquet_columnar_access REPLACE COLUMNS (s1 string, i1 int, f1 float) +1abc00 1 2 1.0 +1def01 2 3 1.1 +1ghi02 3 4 1.2 +1jkl03 1 2 1.3 +1mno04 2 3 1.4 +1pqr05 3 4 1.0 +1stu06 1 2 1.1 +1vwx07 2 3 1.2 +1yza08 3 4 1.3 +1bcd09 1 2 1.4 +1efg10 2 3 1.0 +1hij11 3 4 1.1 +1klm12 1 2 1.2 +1nop13 2 3 1.3 +1qrs14 3 4 1.4 +1tuv15 1 2 1.0 +1wxy16 2 3 1.1 +1zab17 3 4 1.2 +1cde18 1 2 1.3 +1fgh19 2 3 1.4 +1ijk20 3 4 1.0 +PREHOOK: query: ALTER TABLE parquet_columnar_access REPLACE COLUMNS (s1 string, x1 int, y1 int, f1 float) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@parquet_columnar_access PREHOOK: Output: default@parquet_columnar_access -POSTHOOK: query: ALTER TABLE parquet_columnar_access REPLACE COLUMNS (s1 string, i1 int, f1 float) +POSTHOOK: query: ALTER TABLE parquet_columnar_access REPLACE COLUMNS (s1 string, x1 int, y1 int, f1 float) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@parquet_columnar_access POSTHOOK: Output: default@parquet_columnar_access @@ -106,24 +109,24 @@ POSTHOOK: query: SELECT * FROM parquet_c POSTHOOK: type: QUERY POSTHOOK: Input: default@parquet_columnar_access #### A masked pattern was here #### -1abc00 1 1.0 -1def01 2 1.1 -1ghi02 3 1.2 -1jkl03 1 1.3 -1mno04 2 1.4 -1pqr05 3 1.0 -1stu06 1 1.1 -1vwx07 2 1.2 -1yza08 3 1.3 -1bcd09 1 1.4 -1efg10 2 1.0 -1hij11 3 1.1 -1klm12 1 1.2 -1nop13 2 1.3 -1qrs14 3 1.4 -1tuv15 1 1.0 -1wxy16 2 1.1 -1zab17 3 1.2 -1cde18 1 1.3 -1fgh19 2 1.4 -1ijk20 3 1.0 +1abc00 1 2 1.0 +1def01 2 3 1.1 +1ghi02 3 4 1.2 +1jkl03 1 2 1.3 +1mno04 2 3 1.4 +1pqr05 3 4 1.0 +1stu06 1 2 1.1 +1vwx07 2 3 1.2 +1yza08 3 4 1.3 +1bcd09 1 2 1.4 +1efg10 2 3 1.0 +1hij11 3 4 1.1 +1klm12 1 2 1.2 +1nop13 2 3 1.3 +1qrs14 3 4 1.4 +1tuv15 1 2 1.0 +1wxy16 2 3 1.1 +1zab17 3 4 1.2 +1cde18 1 2 1.3 +1fgh19 2 3 1.4 +1ijk20 3 4 1.0 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadataonly1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadataonly1.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadataonly1.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadataonly1.q.out Thu Aug 7 00:21:45 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union5.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union5.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union5.q.out Thu Aug 7 00:21:45 2014 @@ -86,14 +86,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union7.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union7.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union7.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union7.q.out Thu Aug 7 00:21:45 2014 @@ -90,14 +90,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorization_15.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorization_15.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorization_15.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorization_15.q.out Thu Aug 7 00:21:45 2014 @@ -1,3 +1,140 @@ +PREHOOK: query: EXPLAIN +SELECT cfloat, + cboolean1, + cdouble, + cstring1, + ctinyint, + cint, + ctimestamp1, + STDDEV_SAMP(cfloat), + (-26.28 - cint), + MIN(cdouble), + (cdouble * 79.553), + (33 % cfloat), + STDDEV_SAMP(ctinyint), + VAR_POP(ctinyint), + (-23 % cdouble), + (-(ctinyint)), + VAR_SAMP(cint), + (cint - cfloat), + (-23 % ctinyint), + (-((-26.28 - cint))), + STDDEV_POP(cint) +FROM alltypesorc +WHERE (((cstring2 LIKE '%ss%') + OR (cstring1 LIKE '10%')) + OR ((cint >= -75) + AND ((ctinyint = csmallint) + AND (cdouble >= -3728)))) +GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 +ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 +PREHOOK: type: QUERY +POSTHOOK: query: EXPLAIN +SELECT cfloat, + cboolean1, + cdouble, + cstring1, + ctinyint, + cint, + ctimestamp1, + STDDEV_SAMP(cfloat), + (-26.28 - cint), + MIN(cdouble), + (cdouble * 79.553), + (33 % cfloat), + STDDEV_SAMP(ctinyint), + VAR_POP(ctinyint), + (-23 % cdouble), + (-(ctinyint)), + VAR_SAMP(cint), + (cint - cfloat), + (-23 % ctinyint), + (-((-26.28 - cint))), + STDDEV_POP(cint) +FROM alltypesorc +WHERE (((cstring2 LIKE '%ss%') + OR (cstring1 LIKE '10%')) + OR ((cint >= -75) + AND ((ctinyint = csmallint) + AND (cdouble >= -3728)))) +GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 +ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE) + Reducer 3 <- Reducer 2 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: alltypesorc + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: (((cstring2 like '%ss%') or (cstring1 like '10%')) or ((cint >= (- 75)) and ((ctinyint = csmallint) and (cdouble >= (- 3728))))) (type: boolean) + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: cfloat (type: float), cboolean1 (type: boolean), cdouble (type: double), cstring1 (type: string), ctinyint (type: tinyint), cint (type: int), ctimestamp1 (type: timestamp) + outputColumnNames: cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: stddev_samp(cfloat), min(cdouble), stddev_samp(ctinyint), var_pop(ctinyint), var_samp(cint), stddev_pop(cint) + keys: cfloat (type: float), cboolean1 (type: boolean), cdouble (type: double), cstring1 (type: string), ctinyint (type: tinyint), cint (type: int), ctimestamp1 (type: timestamp) + mode: hash + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12 + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: float), _col1 (type: boolean), _col2 (type: double), _col3 (type: string), _col4 (type: tinyint), _col5 (type: int), _col6 (type: timestamp) + sort order: +++++++ + Map-reduce partition columns: _col0 (type: float), _col1 (type: boolean), _col2 (type: double), _col3 (type: string), _col4 (type: tinyint), _col5 (type: int), _col6 (type: timestamp) + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + value expressions: _col7 (type: struct<count:bigint,sum:double,variance:double>), _col8 (type: double), _col9 (type: struct<count:bigint,sum:double,variance:double>), _col10 (type: struct<count:bigint,sum:double,variance:double>), _col11 (type: struct<count:bigint,sum:double,variance:double>), _col12 (type: struct<count:bigint,sum:double,variance:double>) + Execution mode: vectorized + Reducer 2 + Reduce Operator Tree: + Group By Operator + aggregations: stddev_samp(VALUE._col0), min(VALUE._col1), stddev_samp(VALUE._col2), var_pop(VALUE._col3), var_samp(VALUE._col4), stddev_pop(VALUE._col5) + keys: KEY._col0 (type: float), KEY._col1 (type: boolean), KEY._col2 (type: double), KEY._col3 (type: string), KEY._col4 (type: tinyint), KEY._col5 (type: int), KEY._col6 (type: timestamp) + mode: mergepartial + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12 + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: float), _col1 (type: boolean), _col2 (type: double), _col3 (type: string), _col4 (type: tinyint), _col5 (type: int), _col6 (type: timestamp), _col7 (type: double), ((- 26.28) - _col5) (type: double), _col8 (type: double), (_col2 * 79.553) (type: double), (33 % _col0) (type: float), _col9 (type: double), _col10 (type: double), ((- 23) % _col2) (type: double), (- _col4) (type: tinyint), _col11 (type: double), (_col5 - _col0) (type: float), ((- 23) % _col4) (type: int), (- ((- 26.28) - _col5)) (type: double), _col12 (type: double) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20 + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: float), _col1 (type: boolean), _col2 (type: double), _col3 (type: string), _col4 (type: tinyint), _col5 (type: int), _col6 (type: timestamp) + sort order: +++++++ + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + value expressions: _col7 (type: double), _col8 (type: double), _col9 (type: double), _col10 (type: double), _col11 (type: float), _col12 (type: double), _col13 (type: double), _col14 (type: double), _col15 (type: tinyint), _col16 (type: double), _col17 (type: float), _col18 (type: int), _col19 (type: double), _col20 (type: double) + Reducer 3 + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: float), KEY.reducesinkkey1 (type: boolean), KEY.reducesinkkey2 (type: double), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: tinyint), KEY.reducesinkkey5 (type: int), KEY.reducesinkkey6 (type: timestamp), VALUE._col0 (type: double), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: double), VALUE._col4 (type: float), VALUE._col5 (type: double), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: tinyint), VALUE._col9 (type: double), VALUE._col10 (type: float), VALUE._col11 (type: int), VALUE._col12 (type: double), VALUE._col13 (type: double) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20 + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + 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 + Execution mode: vectorized + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + PREHOOK: query: SELECT cfloat, cboolean1, cdouble, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_explode.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_explode.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/udf_explode.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/udf_explode.q.out Thu Aug 7 00:21:45 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udtf_explode.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/udtf_explode.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/udtf_explode.q.out Thu Aug 7 00:21:45 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union11.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union11.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union11.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union11.q.out Thu Aug 7 00:21:45 2014 @@ -73,12 +73,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: bigint) TableScan Union @@ -92,12 +92,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: bigint) TableScan Union @@ -111,12 +111,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator @@ -124,14 +124,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union14.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union14.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union14.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union14.q.out Thu Aug 7 00:21:45 2014 @@ -75,12 +75,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: bigint) TableScan Union @@ -94,12 +94,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator @@ -107,14 +107,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union15.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union15.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union15.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union15.q.out Thu Aug 7 00:21:45 2014 @@ -71,12 +71,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 5 Data size: 480 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 5 Data size: 480 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: s2 @@ -96,12 +96,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 5 Data size: 480 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 5 Data size: 480 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: s3 @@ -121,12 +121,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 5 Data size: 480 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 5 Data size: 480 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator @@ -134,14 +134,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 2 Data size: 200 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 2 Data size: 200 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 2 Data size: 200 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union17.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union17.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union17.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union17.q.out Thu Aug 7 00:21:45 2014 @@ -110,7 +110,7 @@ STAGE PLANS: keys: VALUE._col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 30 Data size: 2640 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 30 Data size: 5760 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false table: @@ -122,7 +122,7 @@ STAGE PLANS: keys: VALUE._col0 (type: string), VALUE._col1 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 30 Data size: 8160 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 30 Data size: 11280 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false table: @@ -138,7 +138,7 @@ STAGE PLANS: key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 30 Data size: 2640 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 30 Data size: 5760 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator @@ -146,14 +146,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: final outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 1320 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 15 Data size: 2880 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 1440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 15 Data size: 2880 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 15 Data size: 1440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 15 Data size: 2880 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -181,7 +181,7 @@ STAGE PLANS: key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 30 Data size: 8160 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 30 Data size: 11280 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col2 (type: bigint) Reduce Operator Tree: Group By Operator @@ -189,14 +189,14 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: final outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 15 Data size: 4080 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 15 Data size: 5640 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 15 Data size: 4200 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 15 Data size: 5640 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 15 Data size: 4200 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 15 Data size: 5640 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union19.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union19.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union19.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union19.q.out Thu Aug 7 00:21:45 2014 @@ -88,12 +88,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 30 Data size: 2640 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 30 Data size: 2880 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 30 Data size: 2640 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 30 Data size: 2880 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) Select Operator expressions: _col0 (type: string), _col1 (type: string), _col1 (type: string) @@ -125,12 +125,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 30 Data size: 2640 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 30 Data size: 2880 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 30 Data size: 2640 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 30 Data size: 2880 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) Select Operator expressions: _col0 (type: string), _col1 (type: string), _col1 (type: string) @@ -150,14 +150,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 1320 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 15 Data size: 1500 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 1440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 15 Data size: 1500 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 15 Data size: 1440 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 15 Data size: 1500 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union20.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union20.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union20.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union20.q.out Thu Aug 7 00:21:45 2014 @@ -130,14 +130,14 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 18 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 36 Data size: 19584 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 18 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 36 Data size: 9792 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 18 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 36 Data size: 9792 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union21.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union21.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union21.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union21.q.out Thu Aug 7 00:21:45 2014 @@ -58,12 +58,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: src_thrift @@ -83,12 +83,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: src @@ -108,12 +108,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: src @@ -133,12 +133,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: src @@ -158,12 +158,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 132 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 132 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator @@ -171,14 +171,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 66 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 66 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 66 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 66 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 66 Data size: 0 Basic stats: PARTIAL Column stats: PARTIAL + Statistics: Num rows: 66 Data size: 1056 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union5.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union5.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union5.q.out Thu Aug 7 00:21:45 2014 @@ -68,12 +68,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: bigint) TableScan Union @@ -87,12 +87,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator @@ -100,14 +100,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union7.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union7.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union7.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union7.q.out Thu Aug 7 00:21:45 2014 @@ -67,12 +67,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) TableScan alias: s2 @@ -92,12 +92,12 @@ STAGE PLANS: keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: PARTIAL value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator @@ -105,14 +105,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_14.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_14.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_14.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_14.q.out Thu Aug 7 00:21:45 2014 @@ -1,3 +1,147 @@ +PREHOOK: query: EXPLAIN +SELECT ctimestamp1, + cfloat, + cstring1, + cboolean1, + cdouble, + (-26.28 + cdouble), + (-((-26.28 + cdouble))), + STDDEV_SAMP((-((-26.28 + cdouble)))), + (cfloat * -26.28), + MAX(cfloat), + (-(cfloat)), + (-(MAX(cfloat))), + ((-((-26.28 + cdouble))) / 10.175), + STDDEV_POP(cfloat), + COUNT(cfloat), + (-(((-((-26.28 + cdouble))) / 10.175))), + (-1.389 % STDDEV_SAMP((-((-26.28 + cdouble))))), + (cfloat - cdouble), + VAR_POP(cfloat), + (VAR_POP(cfloat) % 10.175), + VAR_SAMP(cfloat), + (-((cfloat - cdouble))) +FROM alltypesorc +WHERE (((ctinyint <= cbigint) + AND ((cint <= cdouble) + OR (ctimestamp2 < ctimestamp1))) + AND ((cdouble < ctinyint) + AND ((cbigint > -257) + OR (cfloat < cint)))) +GROUP BY ctimestamp1, cfloat, cstring1, cboolean1, cdouble +ORDER BY cstring1, cfloat, cdouble, ctimestamp1 +PREHOOK: type: QUERY +POSTHOOK: query: EXPLAIN +SELECT ctimestamp1, + cfloat, + cstring1, + cboolean1, + cdouble, + (-26.28 + cdouble), + (-((-26.28 + cdouble))), + STDDEV_SAMP((-((-26.28 + cdouble)))), + (cfloat * -26.28), + MAX(cfloat), + (-(cfloat)), + (-(MAX(cfloat))), + ((-((-26.28 + cdouble))) / 10.175), + STDDEV_POP(cfloat), + COUNT(cfloat), + (-(((-((-26.28 + cdouble))) / 10.175))), + (-1.389 % STDDEV_SAMP((-((-26.28 + cdouble))))), + (cfloat - cdouble), + VAR_POP(cfloat), + (VAR_POP(cfloat) % 10.175), + VAR_SAMP(cfloat), + (-((cfloat - cdouble))) +FROM alltypesorc +WHERE (((ctinyint <= cbigint) + AND ((cint <= cdouble) + OR (ctimestamp2 < ctimestamp1))) + AND ((cdouble < ctinyint) + AND ((cbigint > -257) + OR (cfloat < cint)))) +GROUP BY ctimestamp1, cfloat, cstring1, cboolean1, cdouble +ORDER BY cstring1, cfloat, cdouble, ctimestamp1 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: alltypesorc + Statistics: Num rows: 1779 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: ((((ctinyint <= cbigint) and ((cint <= cdouble) or (ctimestamp2 < ctimestamp1))) and (cdouble < ctinyint)) and ((cbigint > (- 257)) or (cfloat < cint))) (type: boolean) + Statistics: Num rows: 86 Data size: 18236 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: ctimestamp1 (type: timestamp), cfloat (type: float), cstring1 (type: string), cboolean1 (type: boolean), cdouble (type: double) + outputColumnNames: ctimestamp1, cfloat, cstring1, cboolean1, cdouble + Statistics: Num rows: 86 Data size: 18236 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: stddev_samp((- ((- 26.28) + cdouble))), max(cfloat), stddev_pop(cfloat), count(cfloat), var_pop(cfloat), var_samp(cfloat) + keys: ctimestamp1 (type: timestamp), cfloat (type: float), cstring1 (type: string), cboolean1 (type: boolean), cdouble (type: double) + mode: hash + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 + Statistics: Num rows: 86 Data size: 18236 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: timestamp), _col1 (type: float), _col2 (type: string), _col3 (type: boolean), _col4 (type: double) + sort order: +++++ + Map-reduce partition columns: _col0 (type: timestamp), _col1 (type: float), _col2 (type: string), _col3 (type: boolean), _col4 (type: double) + Statistics: Num rows: 86 Data size: 18236 Basic stats: COMPLETE Column stats: NONE + value expressions: _col5 (type: struct<count:bigint,sum:double,variance:double>), _col6 (type: float), _col7 (type: struct<count:bigint,sum:double,variance:double>), _col8 (type: bigint), _col9 (type: struct<count:bigint,sum:double,variance:double>), _col10 (type: struct<count:bigint,sum:double,variance:double>) + Execution mode: vectorized + Reduce Operator Tree: + Group By Operator + aggregations: stddev_samp(VALUE._col0), max(VALUE._col1), stddev_pop(VALUE._col2), count(VALUE._col3), var_pop(VALUE._col4), var_samp(VALUE._col5) + keys: KEY._col0 (type: timestamp), KEY._col1 (type: float), KEY._col2 (type: string), KEY._col3 (type: boolean), KEY._col4 (type: double) + mode: mergepartial + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 + Statistics: Num rows: 43 Data size: 9118 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: timestamp), _col1 (type: float), _col2 (type: string), _col3 (type: boolean), _col4 (type: double), ((- 26.28) + _col4) (type: double), (- ((- 26.28) + _col4)) (type: double), _col5 (type: double), (_col1 * (- 26.28)) (type: double), _col6 (type: float), (- _col1) (type: float), (- _col6) (type: float), ((- ((- 26.28) + _col4)) / 10.175) (type: double), _col7 (type: double), _col8 (type: bigint), (- ((- ((- 26.28) + _col4)) / 10.175)) (type: double), ((- 1.389) % _col5) (type: double), (_col1 - _col4) (type: double), _col9 (type: double), (_col9 % 10.175) (type: double), _col10 (type: double), (- (_col1 - _col4)) (type: double) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21 + Statistics: Num rows: 43 Data size: 9118 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-2 + Map Reduce + Map Operator Tree: + TableScan + Reduce Output Operator + key expressions: _col2 (type: string), _col1 (type: float), _col4 (type: double), _col0 (type: timestamp) + sort order: ++++ + Statistics: Num rows: 43 Data size: 9118 Basic stats: COMPLETE Column stats: NONE + value expressions: _col3 (type: boolean), _col5 (type: double), _col6 (type: double), _col7 (type: double), _col8 (type: double), _col9 (type: float), _col10 (type: float), _col11 (type: float), _col12 (type: double), _col13 (type: double), _col14 (type: bigint), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col19 (type: double), _col20 (type: double), _col21 (type: double) + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey3 (type: timestamp), KEY.reducesinkkey1 (type: float), KEY.reducesinkkey0 (type: string), VALUE._col0 (type: boolean), KEY.reducesinkkey2 (type: double), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: double), VALUE._col4 (type: double), VALUE._col5 (type: float), VALUE._col6 (type: float), VALUE._col7 (type: float), VALUE._col8 (type: double), VALUE._col9 (type: double), VALUE._col10 (type: bigint), VALUE._col11 (type: double), VALUE._col12 (type: double), VALUE._col13 (type: double), VALUE._col14 (type: double), VALUE._col15 (type: double), VALUE._col16 (type: double), VALUE._col17 (type: double) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21 + Statistics: Num rows: 43 Data size: 9118 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 43 Data size: 9118 Basic stats: COMPLETE Column stats: NONE + 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 + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + PREHOOK: query: SELECT ctimestamp1, cfloat, cstring1, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_15.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_15.q.out?rev=1616379&r1=1616378&r2=1616379&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_15.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_15.q.out Thu Aug 7 00:21:45 2014 @@ -1,3 +1,143 @@ +PREHOOK: query: EXPLAIN +SELECT cfloat, + cboolean1, + cdouble, + cstring1, + ctinyint, + cint, + ctimestamp1, + STDDEV_SAMP(cfloat), + (-26.28 - cint), + MIN(cdouble), + (cdouble * 79.553), + (33 % cfloat), + STDDEV_SAMP(ctinyint), + VAR_POP(ctinyint), + (-23 % cdouble), + (-(ctinyint)), + VAR_SAMP(cint), + (cint - cfloat), + (-23 % ctinyint), + (-((-26.28 - cint))), + STDDEV_POP(cint) +FROM alltypesorc +WHERE (((cstring2 LIKE '%ss%') + OR (cstring1 LIKE '10%')) + OR ((cint >= -75) + AND ((ctinyint = csmallint) + AND (cdouble >= -3728)))) +GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 +ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 +PREHOOK: type: QUERY +POSTHOOK: query: EXPLAIN +SELECT cfloat, + cboolean1, + cdouble, + cstring1, + ctinyint, + cint, + ctimestamp1, + STDDEV_SAMP(cfloat), + (-26.28 - cint), + MIN(cdouble), + (cdouble * 79.553), + (33 % cfloat), + STDDEV_SAMP(ctinyint), + VAR_POP(ctinyint), + (-23 % cdouble), + (-(ctinyint)), + VAR_SAMP(cint), + (cint - cfloat), + (-23 % ctinyint), + (-((-26.28 - cint))), + STDDEV_POP(cint) +FROM alltypesorc +WHERE (((cstring2 LIKE '%ss%') + OR (cstring1 LIKE '10%')) + OR ((cint >= -75) + AND ((ctinyint = csmallint) + AND (cdouble >= -3728)))) +GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 +ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: alltypesorc + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: (((cstring2 like '%ss%') or (cstring1 like '10%')) or ((cint >= (- 75)) and ((ctinyint = csmallint) and (cdouble >= (- 3728))))) (type: boolean) + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: cfloat (type: float), cboolean1 (type: boolean), cdouble (type: double), cstring1 (type: string), ctinyint (type: tinyint), cint (type: int), ctimestamp1 (type: timestamp) + outputColumnNames: cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1 + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + Group By Operator + aggregations: stddev_samp(cfloat), min(cdouble), stddev_samp(ctinyint), var_pop(ctinyint), var_samp(cint), stddev_pop(cint) + keys: cfloat (type: float), cboolean1 (type: boolean), cdouble (type: double), cstring1 (type: string), ctinyint (type: tinyint), cint (type: int), ctimestamp1 (type: timestamp) + mode: hash + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12 + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: float), _col1 (type: boolean), _col2 (type: double), _col3 (type: string), _col4 (type: tinyint), _col5 (type: int), _col6 (type: timestamp) + sort order: +++++++ + Map-reduce partition columns: _col0 (type: float), _col1 (type: boolean), _col2 (type: double), _col3 (type: string), _col4 (type: tinyint), _col5 (type: int), _col6 (type: timestamp) + Statistics: Num rows: 1407 Data size: 377237 Basic stats: COMPLETE Column stats: NONE + value expressions: _col7 (type: struct<count:bigint,sum:double,variance:double>), _col8 (type: double), _col9 (type: struct<count:bigint,sum:double,variance:double>), _col10 (type: struct<count:bigint,sum:double,variance:double>), _col11 (type: struct<count:bigint,sum:double,variance:double>), _col12 (type: struct<count:bigint,sum:double,variance:double>) + Execution mode: vectorized + Reduce Operator Tree: + Group By Operator + aggregations: stddev_samp(VALUE._col0), min(VALUE._col1), stddev_samp(VALUE._col2), var_pop(VALUE._col3), var_samp(VALUE._col4), stddev_pop(VALUE._col5) + keys: KEY._col0 (type: float), KEY._col1 (type: boolean), KEY._col2 (type: double), KEY._col3 (type: string), KEY._col4 (type: tinyint), KEY._col5 (type: int), KEY._col6 (type: timestamp) + mode: mergepartial + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12 + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col0 (type: float), _col1 (type: boolean), _col2 (type: double), _col3 (type: string), _col4 (type: tinyint), _col5 (type: int), _col6 (type: timestamp), _col7 (type: double), ((- 26.28) - _col5) (type: double), _col8 (type: double), (_col2 * 79.553) (type: double), (33 % _col0) (type: float), _col9 (type: double), _col10 (type: double), ((- 23) % _col2) (type: double), (- _col4) (type: tinyint), _col11 (type: double), (_col5 - _col0) (type: float), ((- 23) % _col4) (type: int), (- ((- 26.28) - _col5)) (type: double), _col12 (type: double) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20 + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-2 + Map Reduce + Map Operator Tree: + TableScan + Reduce Output Operator + key expressions: _col0 (type: float), _col1 (type: boolean), _col2 (type: double), _col3 (type: string), _col4 (type: tinyint), _col5 (type: int), _col6 (type: timestamp) + sort order: +++++++ + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + value expressions: _col7 (type: double), _col8 (type: double), _col9 (type: double), _col10 (type: double), _col11 (type: float), _col12 (type: double), _col13 (type: double), _col14 (type: double), _col15 (type: tinyint), _col16 (type: double), _col17 (type: float), _col18 (type: int), _col19 (type: double), _col20 (type: double) + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: float), KEY.reducesinkkey1 (type: boolean), KEY.reducesinkkey2 (type: double), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: tinyint), KEY.reducesinkkey5 (type: int), KEY.reducesinkkey6 (type: timestamp), VALUE._col0 (type: double), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: double), VALUE._col4 (type: float), VALUE._col5 (type: double), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: tinyint), VALUE._col9 (type: double), VALUE._col10 (type: float), VALUE._col11 (type: int), VALUE._col12 (type: double), VALUE._col13 (type: double) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20 + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 703 Data size: 188484 Basic stats: COMPLETE Column stats: NONE + 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 + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + PREHOOK: query: SELECT cfloat, cboolean1, cdouble,