You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/04/26 21:16:13 UTC
svn commit: r1476348 [20/29] - in /hive/branches/vectorization: ./ beeline/
beeline/src/java/org/apache/hive/beeline/ beeline/src/test/org/
beeline/src/test/org/apache/ beeline/src/test/org/apache/hive/
beeline/src/test/org/apache/hive/beeline/ beeline...
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/decimal_udf.q.out Fri Apr 26 19:14:49 2013
@@ -752,7 +752,7 @@ NULL
9.8596
9.8596
NULL
-NULL
+1524157875323883675.019051998750190521
1524157875323883652.7968299765279684
PREHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -1226,7 +1226,7 @@ POSTHOOK: Input: default@decimal_udf
1
1
1
-1.04666666666666666666666666666666667
+1.0466666666666666666666666666666666667
1.12
1.12
0.102
@@ -1234,13 +1234,13 @@ POSTHOOK: Input: default@decimal_udf
1.122
1
1.0016
-1.00039043824701195219123505976095618
-1.04666666666666666666666666666666667
-1.04666666666666666666666666666666667
+1.0003904382470119521912350597609561753
+1.0466666666666666666666666666666666667
+1.0466666666666666666666666666666666667
0.785
0.9999999999999999999999999
1.0000000001
-1.0000000000999999927099999336609994
+1.0000000000999999927099999336609993963
PREHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1297,7 +1297,7 @@ POSTHOOK: Input: default@decimal_udf
2
2
2
-2.09333333333333333333333333333333333
+2.0933333333333333333333333333333333333
2.24
2.24
0.204
@@ -1305,13 +1305,13 @@ POSTHOOK: Input: default@decimal_udf
2.244
2
2.0032
-2.00078087649402390438247011952191235
-2.09333333333333333333333333333333333
-2.09333333333333333333333333333333333
+2.0007808764940239043824701195219123506
+2.0933333333333333333333333333333333333
+2.0933333333333333333333333333333333333
1.57
1.9999999999999999999999998
2.0000000002
-2.00000000019999998541999986732199879
+2.0000000001999999854199998673219987926
PREHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
@@ -2111,7 +2111,7 @@ NULL
9.8596
9.8596
NULL
-NULL
+1524157875323883675.019051998750190521
1524157875323883652.7968299765279684
PREHOOK: query: -- modulo
EXPLAIN SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF
@@ -2482,6 +2482,216 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
[{"x":-1.2345678901234567E9,"y":1.0},{"x":-148.75058823529412,"y":34.0},{"x":1.2345678901234567E9,"y":1.0}]
+PREHOOK: query: -- min
+EXPLAIN SELECT MIN(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+POSTHOOK: query: -- min
+EXPLAIN SELECT MIN(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL key))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ decimal_udf
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: key
+ type: decimal
+ outputColumnNames: key
+ Group By Operator
+ aggregations:
+ expr: min(key)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: decimal
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: min(VALUE._col0)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: decimal
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT MIN(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT MIN(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+-1234567890.123456789
+PREHOOK: query: -- max
+EXPLAIN SELECT MAX(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+POSTHOOK: query: -- max
+EXPLAIN SELECT MAX(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL key))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ decimal_udf
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: key
+ type: decimal
+ outputColumnNames: key
+ Group By Operator
+ aggregations:
+ expr: max(key)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: decimal
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: max(VALUE._col0)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: decimal
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT MAX(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT MAX(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+1234567890.12345678
+PREHOOK: query: -- count
+EXPLAIN SELECT COUNT(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+POSTHOOK: query: -- count
+EXPLAIN SELECT COUNT(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION COUNT (TOK_TABLE_OR_COL key))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ decimal_udf
+ TableScan
+ alias: decimal_udf
+ Select Operator
+ expressions:
+ expr: key
+ type: decimal
+ outputColumnNames: key
+ Group By Operator
+ aggregations:
+ expr: count(key)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(VALUE._col0)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: bigint
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT COUNT(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT COUNT(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+36
PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_UDF
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_udf
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/describe_comment_indent.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/describe_comment_indent.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/describe_comment_indent.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/describe_comment_indent.q.out Fri Apr 26 19:14:49 2013
@@ -27,8 +27,6 @@ PREHOOK: query: DESCRIBE test_table
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE test_table
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
col1 int col1 one line comment
col2 string col2
two lines comment
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/describe_syntax.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/describe_syntax.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/describe_syntax.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/describe_syntax.q.out Fri Apr 26 19:14:49 2013
@@ -38,8 +38,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe table
DESCRIBE t1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -54,8 +52,6 @@ PREHOOK: query: DESCRIBE EXTENDED t1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED t1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -109,8 +105,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe database.table
DESCRIBE db1.t1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -125,8 +119,6 @@ PREHOOK: query: DESCRIBE EXTENDED db1.t1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED db1.t1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -180,15 +172,11 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe table column
DESCRIBE t1 key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE EXTENDED t1 key1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED t1 key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE FORMATTED t1 key1
PREHOOK: type: DESCTABLE
@@ -203,15 +191,11 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe database.tabe column
DESCRIBE db1.t1 key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE EXTENDED db1.t1 key1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED db1.t1 key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE FORMATTED db1.t1 key1
PREHOOK: type: DESCTABLE
@@ -230,15 +214,11 @@ POSTHOOK: query: -- describe table.colum
-- fall back to the old syntax table.column
DESCRIBE t1.key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE EXTENDED t1.key1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED t1.key1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int from deserializer
PREHOOK: query: DESCRIBE FORMATTED t1.key1
PREHOOK: type: DESCTABLE
@@ -253,8 +233,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe table partition
DESCRIBE t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -269,8 +247,6 @@ PREHOOK: query: DESCRIBE EXTENDED t1 PAR
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -324,8 +300,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- describe database.table partition
DESCRIBE db1.t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
@@ -340,8 +314,6 @@ PREHOOK: query: DESCRIBE EXTENDED db1.t1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED db1.t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key1 int None
value1 string None
ds string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/describe_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/describe_table.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/describe_table.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/describe_table.q.out Fri Apr 26 19:14:49 2013
@@ -2,8 +2,6 @@ PREHOOK: query: describe srcpart
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe srcpart
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -18,15 +16,11 @@ PREHOOK: query: describe srcpart.key
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe srcpart.key
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string from deserializer
PREHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -41,8 +35,6 @@ PREHOOK: query: describe extended srcpar
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended srcpart
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -59,15 +51,11 @@ PREHOOK: query: describe extended srcpar
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended srcpart.key
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string from deserializer
PREHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12')
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/describe_xpath.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/describe_xpath.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/describe_xpath.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/describe_xpath.q.out Fri Apr 26 19:14:49 2013
@@ -4,8 +4,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a list structure in a thrift table
describe src_thrift.lint
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
lint array<int> from deserializer
PREHOOK: query: -- Describe the element of a list
describe src_thrift.lint.$elem$
@@ -13,8 +11,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the element of a list
describe src_thrift.lint.$elem$
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
$elem$ int from deserializer
PREHOOK: query: -- Describe the key of a map
describe src_thrift.mStringString.$key$
@@ -22,8 +18,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the key of a map
describe src_thrift.mStringString.$key$
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
$key$ string from deserializer
PREHOOK: query: -- Describe the value of a map
describe src_thrift.mStringString.$value$
@@ -31,8 +25,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe the value of a map
describe src_thrift.mStringString.$value$
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
$value$ string from deserializer
PREHOOK: query: -- Describe a complex element of a list
describe src_thrift.lintString.$elem$
@@ -40,8 +32,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a complex element of a list
describe src_thrift.lintString.$elem$
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
myint int from deserializer
mystring string from deserializer
underscore_int int from deserializer
@@ -51,6 +41,4 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: -- Describe a member of an element of a list
describe src_thrift.lintString.$elem$.myint
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
myint int from deserializer
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter.q.out Fri Apr 26 19:14:49 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe ptestfilter
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe ptestfilter
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a string None
b int None
c string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out Fri Apr 26 19:14:49 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe ptestfilter
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe ptestfilter
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a string None
b int None
c int None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out Fri Apr 26 19:14:49 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe ptestfilter
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe ptestfilter
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a string None
b int None
c string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out Fri Apr 26 19:14:49 2013
@@ -23,8 +23,6 @@ PREHOOK: query: desc extended tbl_protec
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tbl_protectmode_no_drop partition (p='p1')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
c1 string None
c2 string None
p string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out Fri Apr 26 19:14:49 2013
@@ -41,8 +41,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_01_nonpart.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_01_nonpart.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_01_nonpart.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_01_nonpart.q.out Fri Apr 26 19:14:49 2013
@@ -47,8 +47,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out Fri Apr 26 19:14:49 2013
@@ -43,8 +43,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_02_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_02_part.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_02_part.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_02_part.q.out Fri Apr 26 19:14:49 2013
@@ -55,8 +55,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_03_nonpart_over_compat.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_03_nonpart_over_compat.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_03_nonpart_over_compat.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_03_nonpart_over_compat.q.out Fri Apr 26 19:14:49 2013
@@ -57,8 +57,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department identifier
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_04_all_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_04_all_part.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_04_all_part.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_04_all_part.q.out Fri Apr 26 19:14:49 2013
@@ -91,8 +91,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_04_evolved_parts.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_04_evolved_parts.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_04_evolved_parts.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_04_evolved_parts.q.out Fri Apr 26 19:14:49 2013
@@ -101,8 +101,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int from deserializer
emp_name string from deserializer
emp_dob string from deserializer
@@ -122,8 +120,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee partition (emp_country='in', emp_state='tn')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_name string None
emp_dob string employee date of birth
@@ -143,8 +139,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee partition (emp_country='in', emp_state='ka')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int from deserializer
emp_name string from deserializer
emp_dob string from deserializer
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_05_some_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_05_some_part.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_05_some_part.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_05_some_part.q.out Fri Apr 26 19:14:49 2013
@@ -85,8 +85,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_06_one_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_06_one_part.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_06_one_part.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_06_one_part.q.out Fri Apr 26 19:14:49 2013
@@ -82,8 +82,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out Fri Apr 26 19:14:49 2013
@@ -114,8 +114,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string iso code
emp_state string free-form text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out Fri Apr 26 19:14:49 2013
@@ -65,8 +65,6 @@ PREHOOK: query: describe extended exim_i
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_imported_dept
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out Fri Apr 26 19:14:49 2013
@@ -120,8 +120,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_10_external_managed.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_10_external_managed.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_10_external_managed.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_10_external_managed.q.out Fri Apr 26 19:14:49 2013
@@ -51,8 +51,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_11_managed_external.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_11_managed_external.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_11_managed_external.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_11_managed_external.q.out Fri Apr 26 19:14:49 2013
@@ -47,8 +47,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_12_external_location.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_12_external_location.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_12_external_location.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_12_external_location.q.out Fri Apr 26 19:14:49 2013
@@ -50,8 +50,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_13_managed_location.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_13_managed_location.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_13_managed_location.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_13_managed_location.q.out Fri Apr 26 19:14:49 2013
@@ -50,8 +50,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_14_managed_location_over_existing.q.out Fri Apr 26 19:14:49 2013
@@ -62,8 +62,6 @@ PREHOOK: query: describe extended exim_d
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_department
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
dep_id int department id
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_15_external_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_15_external_part.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_15_external_part.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_15_external_part.q.out Fri Apr 26 19:14:49 2013
@@ -125,8 +125,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_18_part_external.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_18_part_external.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_18_part_external.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_18_part_external.q.out Fri Apr 26 19:14:49 2013
@@ -90,8 +90,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_19_00_part_external_location.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_19_00_part_external_location.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_19_00_part_external_location.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_19_00_part_external_location.q.out Fri Apr 26 19:14:49 2013
@@ -72,8 +72,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out Fri Apr 26 19:14:49 2013
@@ -93,8 +93,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out Fri Apr 26 19:14:49 2013
@@ -93,8 +93,6 @@ PREHOOK: query: describe extended exim_e
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended exim_employee
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
emp_id int employee id
emp_country string two char iso code
emp_state string free text
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out Fri Apr 26 19:14:49 2013
@@ -40,8 +40,6 @@ PREHOOK: query: DESCRIBE EXTENDED dest1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED dest1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key int None
value string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/fileformat_text.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/fileformat_text.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/fileformat_text.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/fileformat_text.q.out Fri Apr 26 19:14:49 2013
@@ -40,8 +40,6 @@ PREHOOK: query: DESCRIBE EXTENDED dest1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED dest1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key int None
value string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/groupby_sort_8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/groupby_sort_8.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/groupby_sort_8.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/groupby_sort_8.q.out Fri Apr 26 19:14:49 2013
@@ -27,12 +27,14 @@ POSTHOOK: Output: default@t1@ds=1
POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t1 PARTITION(ds=1).val SIMPLE [(t1)t1.FieldSchema(name:val, type:string, comment:null), ]
PREHOOK: query: -- The plan is not converted to a map-side, since although the sorting columns and grouping
--- columns match, the user is issueing a distinct
+-- columns match, the user is issueing a distinct.
+-- However, after HIVE-4310, partial aggregation is performed on the mapper
EXPLAIN
select count(distinct key) from T1
PREHOOK: type: QUERY
POSTHOOK: query: -- The plan is not converted to a map-side, since although the sorting columns and grouping
--- columns match, the user is issueing a distinct
+-- columns match, the user is issueing a distinct.
+-- However, after HIVE-4310, partial aggregation is performed on the mapper
EXPLAIN
select count(distinct key) from T1
POSTHOOK: type: QUERY
@@ -78,6 +80,90 @@ STAGE PLANS:
Reduce Operator Tree:
Group By Operator
aggregations:
+ expr: count(VALUE._col0)
+ bucketGroup: false
+ mode: mergepartial
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: bigint
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: select count(distinct key) from T1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@ds=1
+#### A masked pattern was here ####
+POSTHOOK: query: select count(distinct key) from T1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@ds=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(t1)t1.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: t1 PARTITION(ds=1).val SIMPLE [(t1)t1.FieldSchema(name:val, type:string, comment:null), ]
+5
+PREHOOK: query: -- In testmode, the plan is not changed
+EXPLAIN
+select count(distinct key) from T1
+PREHOOK: type: QUERY
+POSTHOOK: query: -- In testmode, the plan is not changed
+EXPLAIN
+select count(distinct key) from T1
+POSTHOOK: type: QUERY
+POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(t1)t1.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: t1 PARTITION(ds=1).val SIMPLE [(t1)t1.FieldSchema(name:val, type:string, comment:null), ]
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL key))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ t1
+ TableScan
+ alias: t1
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ outputColumnNames: key
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT key)
+ bucketGroup: false
+ keys:
+ expr: key
+ type: string
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
expr: count(DISTINCT KEY._col0:0._col0)
bucketGroup: false
mode: mergepartial
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/index_creation.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/index_creation.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/index_creation.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/index_creation.q.out Fri Apr 26 19:14:49 2013
@@ -43,8 +43,6 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_2__
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
_bucketname string
_offsets array<bigint>
@@ -59,8 +57,6 @@ PREHOOK: query: desc extended src_idx_sr
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended src_idx_src_index_3
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
_bucketname string
_offsets array<bigint>
@@ -75,8 +71,6 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_4__
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
_bucketname string
_offsets array<bigint>
@@ -91,8 +85,6 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_5__
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
_bucketname string
_offsets array<bigint>
@@ -107,8 +99,6 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_6__
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
_bucketname string
_offsets array<bigint>
@@ -123,8 +113,6 @@ PREHOOK: query: desc extended src_idx_sr
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended src_idx_src_index_7
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
_bucketname string
_offsets array<bigint>
@@ -139,8 +127,6 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_8__
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
_bucketname string
_offsets array<bigint>
@@ -155,8 +141,6 @@ PREHOOK: query: desc extended default__s
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended default__src_src_index_9__
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
_bucketname string
_offsets array<bigint>
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/inoutdriver.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/inoutdriver.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/inoutdriver.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/inoutdriver.q.out Fri Apr 26 19:14:49 2013
@@ -7,8 +7,6 @@ PREHOOK: query: desc extended test
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a int None
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/input1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/input1.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/input1.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/input1.q.out Fri Apr 26 19:14:49 2013
@@ -31,7 +31,5 @@ PREHOOK: query: DESCRIBE TEST1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a int None
b double None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/input10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/input10.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/input10.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/input10.q.out Fri Apr 26 19:14:49 2013
@@ -31,8 +31,6 @@ PREHOOK: query: DESCRIBE TEST10
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST10
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key int None
value string None
ds string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/input15.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/input15.q.out Fri Apr 26 19:14:49 2013
@@ -33,7 +33,5 @@ PREHOOK: query: DESCRIBE TEST15
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST15
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key int None
value string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/input2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/input2.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/input2.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/input2.q.out Fri Apr 26 19:14:49 2013
@@ -7,16 +7,12 @@ PREHOOK: query: DESCRIBE TEST2a
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST2a
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a int None
b double None
PREHOOK: query: DESC TEST2a
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESC TEST2a
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a int None
b double None
PREHOOK: query: CREATE TABLE TEST2b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
@@ -28,8 +24,6 @@ PREHOOK: query: DESCRIBE TEST2b
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST2b
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a array<int> None
b double None
c map<double,int> None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/input3.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/input3.q.out Fri Apr 26 19:14:49 2013
@@ -7,8 +7,6 @@ PREHOOK: query: DESCRIBE TEST3a
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3a
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a int None
b double None
PREHOOK: query: CREATE TABLE TEST3b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
@@ -20,8 +18,6 @@ PREHOOK: query: DESCRIBE TEST3b
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3b
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a array<int> None
b double None
c map<double,int> None
@@ -72,8 +68,6 @@ PREHOOK: query: DESCRIBE TEST3b
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3b
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a array<int> None
b double None
c map<double,int> None
@@ -112,8 +106,6 @@ PREHOOK: query: DESCRIBE TEST3c
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE TEST3c
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a array<int> None
b double None
c map<double,int> None
@@ -165,8 +157,6 @@ PREHOOK: query: DESCRIBE EXTENDED TEST3c
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED TEST3c
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
r1 int None
r2 double None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/input_part10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/input_part10.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/input_part10.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/input_part10.q.out Fri Apr 26 19:14:49 2013
@@ -107,8 +107,6 @@ POSTHOOK: query: DESCRIBE EXTENDED part_
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).a SIMPLE []
POSTHOOK: Lineage: part_special PARTITION(ds=2008 04 08,ts=10:11:12=455).b SIMPLE []
-# col_name data_type comment
-
a string None
b string None
ds string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl2.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl2.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl2.q.out Fri Apr 26 19:14:49 2013
@@ -33,8 +33,6 @@ PREHOOK: query: DESCRIBE INPUTDDL2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL2
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key int None
value string None
ds string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl3.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl3.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl3.q.out Fri Apr 26 19:14:49 2013
@@ -33,7 +33,5 @@ PREHOOK: query: DESCRIBE INPUTDDL3
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL3
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key int None
value string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl4.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl4.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl4.q.out Fri Apr 26 19:14:49 2013
@@ -23,8 +23,6 @@ PREHOOK: query: DESCRIBE INPUTDDL4
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL4
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
viewtime string None
userid int None
page_url string None
@@ -44,8 +42,6 @@ PREHOOK: query: DESCRIBE EXTENDED INPUTD
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL4
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
viewtime string None
userid int None
page_url string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl5.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl5.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl5.q.out Fri Apr 26 19:14:49 2013
@@ -17,8 +17,6 @@ PREHOOK: query: DESCRIBE INPUTDDL5
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE INPUTDDL5
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
name string None
PREHOOK: query: SELECT INPUTDDL5.name from INPUTDDL5
PREHOOK: type: QUERY
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl6.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl6.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl6.q.out Fri Apr 26 19:14:49 2013
@@ -27,8 +27,6 @@ PREHOOK: query: DESCRIBE EXTENDED INPUTD
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL6
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
ds string None
@@ -43,8 +41,6 @@ PREHOOK: query: DESCRIBE EXTENDED INPUTD
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-08')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
ds string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl7.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl7.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl7.q.out Fri Apr 26 19:14:49 2013
@@ -96,8 +96,6 @@ PREHOOK: query: DESCRIBE EXTENDED T1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED T1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
name string None
#### A masked pattern was here ####
@@ -105,8 +103,6 @@ PREHOOK: query: DESCRIBE EXTENDED T2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED T2
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
name string None
#### A masked pattern was here ####
@@ -114,8 +110,6 @@ PREHOOK: query: DESCRIBE EXTENDED T3 PAR
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED T3 PARTITION (ds='2008-04-09')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
name string None
ds string None
@@ -129,8 +123,6 @@ PREHOOK: query: DESCRIBE EXTENDED T4 PAR
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED T4 PARTITION (ds='2008-04-09')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
name string None
ds string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl8.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl8.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/inputddl8.q.out Fri Apr 26 19:14:49 2013
@@ -19,8 +19,6 @@ PREHOOK: query: DESCRIBE EXTENDED INPUTD
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL8
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
aint int from deserializer
astring string from deserializer
lint array<int> from deserializer
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/join_thrift.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/join_thrift.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/join_thrift.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/join_thrift.q.out Fri Apr 26 19:14:49 2013
@@ -2,8 +2,6 @@ PREHOOK: query: DESCRIBE src_thrift
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE src_thrift
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
aint int from deserializer
astring string from deserializer
lint array<int> from deserializer
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/lateral_view.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/lateral_view.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/lateral_view.q.out Fri Apr 26 19:14:49 2013
@@ -34,16 +34,21 @@ STAGE PLANS:
alias: src
Lateral View Forward
Select Operator
- SELECT * : (no compute)
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: key, value
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col2
+ outputColumnNames: _col0, _col1, _col4
Select Operator
expressions:
expr: _col0
type: string
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
outputColumnNames: _col0, _col1, _col2
Reduce Output Operator
@@ -69,14 +74,14 @@ STAGE PLANS:
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col2
+ outputColumnNames: _col0, _col1, _col4
Select Operator
expressions:
expr: _col0
type: string
expr: _col1
type: string
- expr: _col2
+ expr: _col4
type: int
outputColumnNames: _col0, _col1, _col2
Reduce Output Operator
@@ -160,10 +165,10 @@ STAGE PLANS:
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col2
+ outputColumnNames: _col4
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: int
outputColumnNames: _col0
Limit
@@ -181,10 +186,10 @@ STAGE PLANS:
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col2
+ outputColumnNames: _col4
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: int
outputColumnNames: _col0
Limit
@@ -222,20 +227,20 @@ STAGE PLANS:
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col2
+ outputColumnNames: _col4
Lateral View Forward
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: int
- outputColumnNames: _col2
+ outputColumnNames: _col4
Lateral View Join Operator
- outputColumnNames: _col2, _col3
+ outputColumnNames: _col4, _col5
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1
Limit
@@ -253,12 +258,12 @@ STAGE PLANS:
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col2, _col3
+ outputColumnNames: _col4, _col5
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1
Limit
@@ -276,20 +281,20 @@ STAGE PLANS:
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col2
+ outputColumnNames: _col4
Lateral View Forward
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: int
- outputColumnNames: _col2
+ outputColumnNames: _col4
Lateral View Join Operator
- outputColumnNames: _col2, _col3
+ outputColumnNames: _col4, _col5
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1
Limit
@@ -307,12 +312,12 @@ STAGE PLANS:
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col2, _col3
+ outputColumnNames: _col4, _col5
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: int
- expr: _col3
+ expr: _col5
type: string
outputColumnNames: _col0, _col1
Limit
@@ -350,14 +355,14 @@ STAGE PLANS:
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col2
+ outputColumnNames: _col4
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col3
+ outputColumnNames: _col5
Select Operator
expressions:
- expr: _col3
+ expr: _col5
type: int
outputColumnNames: _col0
Limit
@@ -369,16 +374,16 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: array<int>
outputColumnNames: _col0
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col3
+ outputColumnNames: _col5
Select Operator
expressions:
- expr: _col3
+ expr: _col5
type: int
outputColumnNames: _col0
Limit
@@ -396,14 +401,14 @@ STAGE PLANS:
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col2
+ outputColumnNames: _col4
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col3
+ outputColumnNames: _col5
Select Operator
expressions:
- expr: _col3
+ expr: _col5
type: int
outputColumnNames: _col0
Limit
@@ -415,16 +420,16 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: array<int>
outputColumnNames: _col0
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col3
+ outputColumnNames: _col5
Select Operator
expressions:
- expr: _col3
+ expr: _col5
type: int
outputColumnNames: _col0
Limit
@@ -524,10 +529,10 @@ STAGE PLANS:
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col1
+ outputColumnNames: _col3
Select Operator
expressions:
- expr: _col1
+ expr: _col3
type: int
outputColumnNames: _col0
Limit
@@ -545,10 +550,10 @@ STAGE PLANS:
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col1
+ outputColumnNames: _col3
Select Operator
expressions:
- expr: _col1
+ expr: _col3
type: int
outputColumnNames: _col0
Limit