hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1674738 [11/11] - in /hive/trunk: ./ common/src/java/org/apache/hadoop/hive/conf/ hbase-handler/ metastore/bin/ ql/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/apache/hadoop/...
Date Mon, 20 Apr 2015 06:14:39 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out?rev=1674738&r1=1674737&r2=1674738&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out Mon Apr 20 06:14:38 2015
@@ -346,28 +346,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col7
                               name: sum
                               window function: GenericUDAFSumDouble
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -768,7 +768,7 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: lag_window_0
                               arguments: _col5, 1, _col5
                               name: lag
                               window function: GenericUDAFLagEvaluator
@@ -776,7 +776,7 @@ STAGE PLANS:
                               isPivotResult: true
                   Statistics: Num rows: 14 Data size: 8823 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), (_col5 - _wcol0) (type: int)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), (_col5 - lag_window_0) (type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics: Num rows: 14 Data size: 8823 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -1297,28 +1297,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col7
                               name: sum
                               window function: GenericUDAFSumDouble
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -1630,21 +1630,21 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: lag_window_2
                               arguments: _col5, 1, _col5
                               name: lag
                               window function: GenericUDAFLagEvaluator
@@ -1652,7 +1652,7 @@ STAGE PLANS:
                               isPivotResult: true
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), (_col5 - _wcol2) (type: int)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), (_col5 - lag_window_2) (type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -1999,21 +1999,21 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: lag_window_2
                               arguments: _col2, 1, _col2
                               name: lag
                               window function: GenericUDAFLagEvaluator
@@ -2021,7 +2021,7 @@ STAGE PLANS:
                               isPivotResult: true
                   Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int), _wcol0 (type: int), _wcol1 (type: int), _col2 (type: int), (_col2 - _wcol2) (type: int)
+                    expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col2 (type: int), (_col2 - lag_window_2) (type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
                     Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -2957,7 +2957,7 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1, _col5
                               name: rank
                               window function: GenericUDAFRankEvaluator
@@ -2965,7 +2965,7 @@ STAGE PLANS:
                               isPivotResult: true
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -3280,28 +3280,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col7
                               name: sum
                               window function: GenericUDAFSumDouble
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -3604,28 +3604,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col7
                               name: sum
                               window function: GenericUDAFSumDouble
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -3998,28 +3998,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col7
                               name: sum
                               window function: GenericUDAFSumDouble
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -4352,20 +4352,20 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: count_window_0
                               arguments: _col5
                               name: count
                               window function: GenericUDAFCountEvaluator
                               window frame: PRECEDING(MAX)~
                             window function definition
-                              alias: _wcol1
+                              alias: sum_window_1
                               arguments: _col7
                               name: sum
                               window function: GenericUDAFSumDouble
                               window frame: PRECEDING(2)~FOLLOWING(2)
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: bigint), _wcol1 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), count_window_0 (type: bigint), sum_window_1 (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -4866,33 +4866,33 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: count_window_2
                               arguments: _col1
                               name: count
                               window function: GenericUDAFCountEvaluator
                               window frame: PRECEDING(MAX)~
                             window function definition
-                              alias: _wcol3
+                              alias: sum_window_3
                               arguments: _col7
                               name: sum
                               window function: GenericUDAFSumDouble
                               window frame: PRECEDING(MAX)~
                             window function definition
-                              alias: _wcol4
+                              alias: lag_window_4
                               arguments: _col5, 1, _col5
                               name: lag
                               window function: GenericUDAFLagEvaluator
@@ -4900,7 +4900,7 @@ STAGE PLANS:
                               isPivotResult: true
                   Statistics: Num rows: 14 Data size: 8823 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: bigint), _col7 (type: double), _wcol3 (type: double), _col5 (type: int), (_col5 - _wcol4) (type: int)
+                    expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), count_window_2 (type: bigint), _col7 (type: double), sum_window_3 (type: double), _col5 (type: int), (_col5 - lag_window_4) (type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
                     Statistics: Num rows: 14 Data size: 8823 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -5454,14 +5454,14 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: sum_window_0
                               arguments: _col2
                               name: sum
                               window function: GenericUDAFSumDouble
                               window frame: PRECEDING(2)~
                   Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col1 (type: string), _col2 (type: double), _wcol0 (type: double)
+                    expressions: _col0 (type: string), _col1 (type: string), _col2 (type: double), sum_window_0 (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -5939,28 +5939,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col7
                               name: sum
                               window function: GenericUDAFSumDouble
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -6010,15 +6010,15 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: sum_window_0
                               arguments: _col5
                               name: sum
                               window function: GenericUDAFSumLong
                               window frame: PRECEDING(5)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col1 (type: string), _col2 (type: string), _col5 (type: int), _wcol0 (type: bigint)
-                    outputColumnNames: _col1, _col2, _col5, _wcol0
+                    expressions: _col1 (type: string), _col2 (type: string), _col5 (type: int), sum_window_0 (type: bigint)
+                    outputColumnNames: _col1, _col2, _col5, sum_window_0
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     Reduce Output Operator
                       key expressions: _col2 (type: string), _col1 (type: string)
@@ -6026,7 +6026,7 @@ STAGE PLANS:
                       Map-reduce partition columns: _col2 (type: string)
                       Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                       tag: -1
-                      value expressions: _wcol0 (type: bigint), _col5 (type: int)
+                      value expressions: sum_window_0 (type: bigint), _col5 (type: int)
                       auto parallelism: true
         Reducer 5 
             Needs Tagging: false
@@ -6049,35 +6049,35 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol1
+                              alias: rank_window_1
                               arguments: _col3, _col2
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: dense_rank_window_2
                               arguments: _col3, _col2
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol3
+                              alias: cume_dist_window_3
                               arguments: _col3, _col2
                               name: cume_dist
                               window function: GenericUDAFCumeDistEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol4
+                              alias: first_value_window_4
                               arguments: _col6, true
                               name: first_value
                               window function: GenericUDAFFirstValueEvaluator
                               window frame: PRECEDING(2)~FOLLOWING(2)
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col3 (type: string), _col2 (type: string), _col6 (type: int), UDFToInteger(round(_col0, 1)) (type: int), _wcol1 (type: int), _wcol2 (type: int), _wcol3 (type: double), _wcol4 (type: int)
+                    expressions: _col3 (type: string), _col2 (type: string), _col6 (type: int), UDFToInteger(round(_col0, 1)) (type: int), rank_window_1 (type: int), dense_rank_window_2 (type: int), cume_dist_window_3 (type: double), first_value_window_4 (type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -6616,28 +6616,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col2, _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col2, _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col5
                               name: sum
                               window function: GenericUDAFSumLong
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint)
+                    expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -7066,28 +7066,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col5
                               name: sum
                               window function: GenericUDAFSumLong
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint)
+                    expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -7477,28 +7477,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col5
                               name: sum
                               window function: GenericUDAFSumLong
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint)
+                    expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -7939,28 +7939,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col2, _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col2, _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col5
                               name: sum
                               window function: GenericUDAFSumLong
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint)
+                    expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -8410,28 +8410,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col2, _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col2, _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col5
                               name: sum
                               window function: GenericUDAFSumLong
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint), _wcol2 (type: bigint)
+                    expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint), sum_window_2 (type: bigint)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
@@ -8840,28 +8840,28 @@ STAGE PLANS:
                         raw input shape:
                         window functions:
                             window function definition
-                              alias: _wcol0
+                              alias: rank_window_0
                               arguments: _col1
                               name: rank
                               window function: GenericUDAFRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol1
+                              alias: dense_rank_window_1
                               arguments: _col1
                               name: dense_rank
                               window function: GenericUDAFDenseRankEvaluator
                               window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                               isPivotResult: true
                             window function definition
-                              alias: _wcol2
+                              alias: sum_window_2
                               arguments: _col5
                               name: sum
                               window function: GenericUDAFSumLong
                               window frame: PRECEDING(MAX)~
                   Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint), _wcol2 (type: bigint)
+                    expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint), sum_window_2 (type: bigint)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
                     Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/union_remove_6_subq.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_remove_6_subq.q.out?rev=1674738&r1=1674737&r2=1674738&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_remove_6_subq.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_remove_6_subq.q.out Mon Apr 20 06:14:38 2015
@@ -559,14 +559,14 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: avg_window_0
                         arguments: _col1
                         name: avg
                         window function: GenericUDAFAverageEvaluatorDouble
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col0 (type: string), _wcol0 (type: double)
+              expressions: _col0 (type: string), avg_window_0 (type: double)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
               File Output Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_ptf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_ptf.q.out?rev=1674738&r1=1674737&r2=1674738&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_ptf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_ptf.q.out Mon Apr 20 06:14:38 2015
@@ -387,28 +387,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col7
                         name: sum
                         window function: GenericUDAFSumDouble
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -844,7 +844,7 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: lag_window_0
                         arguments: _col5, 1, _col5
                         name: lag
                         window function: GenericUDAFLagEvaluator
@@ -852,7 +852,7 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 14 Data size: 8823 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), (_col5 - _wcol0) (type: int)
+              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), (_col5 - lag_window_0) (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3
               Statistics: Num rows: 14 Data size: 8823 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -1408,28 +1408,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col7
                         name: sum
                         window function: GenericUDAFSumDouble
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -1782,21 +1782,21 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: lag_window_2
                         arguments: _col5, 1, _col5
                         name: lag
                         window function: GenericUDAFLagEvaluator
@@ -1804,7 +1804,7 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), (_col5 - _wcol2) (type: int)
+              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), (_col5 - lag_window_2) (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -2238,21 +2238,21 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: lag_window_2
                         arguments: _col2, 1, _col2
                         name: lag
                         window function: GenericUDAFLagEvaluator
@@ -2260,7 +2260,7 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int), _wcol0 (type: int), _wcol1 (type: int), _col2 (type: int), (_col2 - _wcol2) (type: int)
+              expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col2 (type: int), (_col2 - lag_window_2) (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
               Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -3303,7 +3303,7 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1, _col5
                         name: rank
                         window function: GenericUDAFRankEvaluator
@@ -3311,7 +3311,7 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int)
+              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -3667,28 +3667,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col7
                         name: sum
                         window function: GenericUDAFSumDouble
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -4032,28 +4032,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col7
                         name: sum
                         window function: GenericUDAFSumDouble
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -4514,28 +4514,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col7
                         name: sum
                         window function: GenericUDAFSumDouble
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -4909,20 +4909,20 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: count_window_0
                         arguments: _col5
                         name: count
                         window function: GenericUDAFCountEvaluator
                         window frame: PRECEDING(MAX)~
                       window function definition
-                        alias: _wcol1
+                        alias: sum_window_1
                         arguments: _col7
                         name: sum
                         window function: GenericUDAFSumDouble
                         window frame: PRECEDING(2)~FOLLOWING(2)
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: bigint), _wcol1 (type: double)
+              expressions: _col2 (type: string), _col1 (type: string), count_window_0 (type: bigint), sum_window_1 (type: double)
               outputColumnNames: _col0, _col1, _col2, _col3
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -5503,33 +5503,33 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: count_window_2
                         arguments: _col1
                         name: count
                         window function: GenericUDAFCountEvaluator
                         window frame: PRECEDING(MAX)~
                       window function definition
-                        alias: _wcol3
+                        alias: sum_window_3
                         arguments: _col7
                         name: sum
                         window function: GenericUDAFSumDouble
                         window frame: PRECEDING(MAX)~
                       window function definition
-                        alias: _wcol4
+                        alias: lag_window_4
                         arguments: _col5, 1, _col5
                         name: lag
                         window function: GenericUDAFLagEvaluator
@@ -5537,7 +5537,7 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 14 Data size: 8823 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: bigint), _col7 (type: double), _wcol3 (type: double), _col5 (type: int), (_col5 - _wcol4) (type: int)
+              expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), count_window_2 (type: bigint), _col7 (type: double), sum_window_3 (type: double), _col5 (type: int), (_col5 - lag_window_4) (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
               Statistics: Num rows: 14 Data size: 8823 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -6172,14 +6172,14 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: sum_window_0
                         arguments: _col2
                         name: sum
                         window function: GenericUDAFSumDouble
                         window frame: PRECEDING(2)~
             Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col0 (type: string), _col1 (type: string), _col2 (type: double), _wcol0 (type: double)
+              expressions: _col0 (type: string), _col1 (type: string), _col2 (type: double), sum_window_0 (type: double)
               outputColumnNames: _col0, _col1, _col2, _col3
               Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -6706,28 +6706,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col7
                         name: sum
                         window function: GenericUDAFSumDouble
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), _wcol0 (type: int), _wcol1 (type: int), _wcol2 (type: double)
+              expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -6841,15 +6841,15 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: sum_window_0
                         arguments: _col5
                         name: sum
                         window function: GenericUDAFSumLong
                         window frame: PRECEDING(5)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col1 (type: string), _col2 (type: string), _col5 (type: int), _wcol0 (type: bigint)
-              outputColumnNames: _col1, _col2, _col5, _wcol0
+              expressions: _col1 (type: string), _col2 (type: string), _col5 (type: int), sum_window_0 (type: bigint)
+              outputColumnNames: _col1, _col2, _col5, sum_window_0
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
                 compressed: false
@@ -6860,7 +6860,7 @@ STAGE PLANS:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns _col1,_col2,_col5,_wcol0
+                      columns _col1,_col2,_col5,sum_window_0
                       columns.types string,string,int,bigint
                       escape.delim \
                       serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
@@ -6880,7 +6880,7 @@ STAGE PLANS:
               Map-reduce partition columns: _col2 (type: string)
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               tag: -1
-              value expressions: _wcol0 (type: bigint), _col5 (type: int)
+              value expressions: sum_window_0 (type: bigint), _col5 (type: int)
               auto parallelism: false
       Path -> Alias:
 #### A masked pattern was here ####
@@ -6891,7 +6891,7 @@ STAGE PLANS:
             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
             properties:
-              columns _col1,_col2,_col5,_wcol0
+              columns _col1,_col2,_col5,sum_window_0
               columns.types string,string,int,bigint
               escape.delim \
               serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
@@ -6900,7 +6900,7 @@ STAGE PLANS:
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns _col1,_col2,_col5,_wcol0
+                columns _col1,_col2,_col5,sum_window_0
                 columns.types string,string,int,bigint
                 escape.delim \
                 serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
@@ -6927,35 +6927,35 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol1
+                        alias: rank_window_1
                         arguments: _col3, _col2
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: dense_rank_window_2
                         arguments: _col3, _col2
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol3
+                        alias: cume_dist_window_3
                         arguments: _col3, _col2
                         name: cume_dist
                         window function: GenericUDAFCumeDistEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol4
+                        alias: first_value_window_4
                         arguments: _col6, true
                         name: first_value
                         window function: GenericUDAFFirstValueEvaluator
                         window frame: PRECEDING(2)~FOLLOWING(2)
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col3 (type: string), _col2 (type: string), _col6 (type: int), UDFToInteger(round(_col0, 1)) (type: int), _wcol1 (type: int), _wcol2 (type: int), _wcol3 (type: double), _wcol4 (type: int)
+              expressions: _col3 (type: string), _col2 (type: string), _col6 (type: int), UDFToInteger(round(_col0, 1)) (type: int), rank_window_1 (type: int), dense_rank_window_2 (type: int), cume_dist_window_3 (type: double), first_value_window_4 (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -7553,28 +7553,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col2, _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col2, _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col5
                         name: sum
                         window function: GenericUDAFSumLong
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint)
+              expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -8138,28 +8138,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col5
                         name: sum
                         window function: GenericUDAFSumLong
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint)
+              expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -8637,28 +8637,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col5
                         name: sum
                         window function: GenericUDAFSumLong
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint)
+              expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -9234,28 +9234,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col2, _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col2, _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col5
                         name: sum
                         window function: GenericUDAFSumLong
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint)
+              expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -9793,28 +9793,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col2, _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col2, _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col5
                         name: sum
                         window function: GenericUDAFSumLong
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint), _wcol2 (type: bigint)
+              expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint), sum_window_2 (type: bigint)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -10311,28 +10311,28 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol1
+                        alias: dense_rank_window_1
                         arguments: _col1
                         name: dense_rank
                         window function: GenericUDAFDenseRankEvaluator
                         window frame: PRECEDING(MAX)~FOLLOWING(MAX)
                         isPivotResult: true
                       window function definition
-                        alias: _wcol2
+                        alias: sum_window_2
                         arguments: _col5
                         name: sum
                         window function: GenericUDAFSumLong
                         window frame: PRECEDING(MAX)~
             Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _col1 (type: string), _wcol0 (type: int), _wcol1 (type: int), _col5 (type: int), _wcol2 (type: bigint), _wcol2 (type: bigint)
+              expressions: _col2 (type: string), _col1 (type: string), rank_window_0 (type: int), dense_rank_window_1 (type: int), _col5 (type: int), sum_window_2 (type: bigint), sum_window_2 (type: bigint)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
               Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
               File Output Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out?rev=1674738&r1=1674737&r2=1674738&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out Mon Apr 20 06:14:38 2015
@@ -89,7 +89,7 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
@@ -97,7 +97,7 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: _col2 (type: string), _wcol0 (type: int)
+              expressions: _col2 (type: string), rank_window_0 (type: int)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
               File Output Operator
@@ -160,7 +160,7 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col1
                         name: rank
                         window function: GenericUDAFRankEvaluator
@@ -168,10 +168,10 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: (_wcol0 < 4) (type: boolean)
+              predicate: (rank_window_0 < 4) (type: boolean)
               Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: _col2 (type: string), _wcol0 (type: int)
+                expressions: _col2 (type: string), rank_window_0 (type: int)
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
@@ -329,7 +329,7 @@ STAGE PLANS:
                   raw input shape:
                   window functions:
                       window function definition
-                        alias: _wcol0
+                        alias: rank_window_0
                         arguments: _col5
                         name: rank
                         window function: GenericUDAFRankEvaluator
@@ -337,10 +337,10 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: (_wcol0 < 5) (type: boolean)
+              predicate: (rank_window_0 < 5) (type: boolean)
               Statistics: Num rows: 4096 Data size: 880654 Basic stats: COMPLETE Column stats: NONE
               Select Operator
-                expressions: _col0 (type: tinyint), _col5 (type: double), _wcol0 (type: int)
+                expressions: _col0 (type: tinyint), _col5 (type: double), rank_window_0 (type: int)
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 4096 Data size: 880654 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator



Mime
View raw message