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 [25/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/udtf_json_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_json_tuple.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_json_tuple.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_json_tuple.q.out Fri Apr 26 19:14:49 2013
@@ -68,21 +68,21 @@ STAGE PLANS:
type: string
outputColumnNames: key
Lateral View Join Operator
- outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
+ outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8
Select Operator
expressions:
expr: _col0
type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
expr: _col4
type: string
expr: _col5
type: string
expr: _col6
type: string
+ expr: _col7
+ type: string
+ expr: _col8
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Reduce Output Operator
key expressions:
@@ -121,21 +121,21 @@ STAGE PLANS:
UDTF Operator
function name: json_tuple
Lateral View Join Operator
- outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
+ outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8
Select Operator
expressions:
expr: _col0
type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
expr: _col4
type: string
expr: _col5
type: string
expr: _col6
type: string
+ expr: _col7
+ type: string
+ expr: _col8
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Reduce Output Operator
key expressions:
@@ -305,14 +305,14 @@ STAGE PLANS:
type: string
outputColumnNames: key
Lateral View Join Operator
- outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
+ outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8
Select Operator
expressions:
expr: _col0
type: string
- expr: _col3
+ expr: _col5
type: string
- expr: _col6
+ expr: _col8
type: string
outputColumnNames: _col0, _col1, _col2
Reduce Output Operator
@@ -346,14 +346,14 @@ STAGE PLANS:
UDTF Operator
function name: json_tuple
Lateral View Join Operator
- outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
+ outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8
Select Operator
expressions:
expr: _col0
type: string
- expr: _col3
+ expr: _col5
type: string
- expr: _col6
+ expr: _col8
type: string
outputColumnNames: _col0, _col1, _col2
Reduce Output Operator
@@ -425,22 +425,22 @@ STAGE PLANS:
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col2, _col3, _col4, _col5, _col6
+ outputColumnNames: _col4, _col5, _col6, _col7, _col8
Filter Operator
predicate:
- expr: _col2 is not null
+ expr: _col4 is not null
type: boolean
Select Operator
expressions:
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col3
+ outputColumnNames: _col5
Group By Operator
aggregations:
expr: count()
bucketGroup: false
keys:
- expr: _col3
+ expr: _col5
type: string
mode: hash
outputColumnNames: _col0, _col1
@@ -474,22 +474,22 @@ STAGE PLANS:
UDTF Operator
function name: json_tuple
Lateral View Join Operator
- outputColumnNames: _col2, _col3, _col4, _col5, _col6
+ outputColumnNames: _col4, _col5, _col6, _col7, _col8
Filter Operator
predicate:
- expr: _col2 is not null
+ expr: _col4 is not null
type: boolean
Select Operator
expressions:
- expr: _col3
+ expr: _col5
type: string
- outputColumnNames: _col3
+ outputColumnNames: _col5
Group By Operator
aggregations:
expr: count()
bucketGroup: false
keys:
- expr: _col3
+ expr: _col5
type: string
mode: hash
outputColumnNames: _col0, _col1
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out Fri Apr 26 19:14:49 2013
@@ -89,15 +89,11 @@ STAGE PLANS:
type: string
outputColumnNames: key
Lateral View Join Operator
- outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+ outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
Select Operator
expressions:
expr: _col0
type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
expr: _col4
type: string
expr: _col5
@@ -112,6 +108,10 @@ STAGE PLANS:
type: string
expr: _col10
type: string
+ expr: _col11
+ type: string
+ expr: _col12
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Reduce Output Operator
key expressions:
@@ -166,15 +166,11 @@ STAGE PLANS:
UDTF Operator
function name: parse_url_tuple
Lateral View Join Operator
- outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+ outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
Select Operator
expressions:
expr: _col0
type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
expr: _col4
type: string
expr: _col5
@@ -189,6 +185,10 @@ STAGE PLANS:
type: string
expr: _col10
type: string
+ expr: _col11
+ type: string
+ expr: _col12
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Reduce Output Operator
key expressions:
@@ -384,23 +384,23 @@ STAGE PLANS:
type: string
outputColumnNames: key
Lateral View Join Operator
- outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
+ outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
Select Operator
expressions:
expr: _col0
type: string
- expr: _col2
- type: string
expr: _col4
type: string
- expr: _col10
- type: string
- expr: _col11
+ expr: _col6
type: string
expr: _col12
type: string
expr: _col13
type: string
+ expr: _col14
+ type: string
+ expr: _col15
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
Reduce Output Operator
key expressions:
@@ -455,23 +455,23 @@ STAGE PLANS:
UDTF Operator
function name: parse_url_tuple
Lateral View Join Operator
- outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
+ outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
Select Operator
expressions:
expr: _col0
type: string
- expr: _col2
- type: string
expr: _col4
type: string
- expr: _col10
- type: string
- expr: _col11
+ expr: _col6
type: string
expr: _col12
type: string
expr: _col13
type: string
+ expr: _col14
+ type: string
+ expr: _col15
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
Reduce Output Operator
key expressions:
@@ -549,22 +549,22 @@ STAGE PLANS:
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+ outputColumnNames: _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
Filter Operator
predicate:
- expr: _col10 is not null
+ expr: _col12 is not null
type: boolean
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: string
- outputColumnNames: _col2
+ outputColumnNames: _col4
Group By Operator
aggregations:
expr: count()
bucketGroup: false
keys:
- expr: _col2
+ expr: _col4
type: string
mode: hash
outputColumnNames: _col0, _col1
@@ -606,22 +606,22 @@ STAGE PLANS:
UDTF Operator
function name: parse_url_tuple
Lateral View Join Operator
- outputColumnNames: _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+ outputColumnNames: _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
Filter Operator
predicate:
- expr: _col10 is not null
+ expr: _col12 is not null
type: boolean
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: string
- outputColumnNames: _col2
+ outputColumnNames: _col4
Group By Operator
aggregations:
expr: count()
bucketGroup: false
keys:
- expr: _col2
+ expr: _col4
type: string
mode: hash
outputColumnNames: _col0, _col1
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_stack.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_stack.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_stack.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_stack.q.out Fri Apr 26 19:14:49 2013
@@ -24,12 +24,12 @@ STAGE PLANS:
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col2, _col3
+ outputColumnNames: _col4, _col5
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: string
- expr: _col3
+ expr: _col5
type: array<int>
outputColumnNames: _col0, _col1
Limit
@@ -53,12 +53,12 @@ STAGE PLANS:
UDTF Operator
function name: stack
Lateral View Join Operator
- outputColumnNames: _col2, _col3
+ outputColumnNames: _col4, _col5
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: string
- expr: _col3
+ expr: _col5
type: array<int>
outputColumnNames: _col0, _col1
Limit
@@ -95,12 +95,12 @@ STAGE PLANS:
Lateral View Forward
Select Operator
Lateral View Join Operator
- outputColumnNames: _col2, _col3
+ outputColumnNames: _col4, _col5
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: string
- expr: _col3
+ expr: _col5
type: array<int>
outputColumnNames: _col0, _col1
Limit
@@ -126,12 +126,12 @@ STAGE PLANS:
UDTF Operator
function name: stack
Lateral View Join Operator
- outputColumnNames: _col2, _col3
+ outputColumnNames: _col4, _col5
Select Operator
expressions:
- expr: _col2
+ expr: _col4
type: string
- expr: _col3
+ expr: _col5
type: array<int>
outputColumnNames: _col0, _col1
Limit
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/union26.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/union26.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/union26.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/union26.q.out Fri Apr 26 19:14:49 2013
@@ -158,7 +158,7 @@ STAGE PLANS:
type: string
outputColumnNames: key, value
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col6
Select Operator
expressions:
expr: _col0
@@ -209,7 +209,7 @@ STAGE PLANS:
UDTF Operator
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col6
Select Operator
expressions:
expr: _col0
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/union_remove_10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/union_remove_10.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/union_remove_10.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/union_remove_10.q.out Fri Apr 26 19:14:49 2013
@@ -152,6 +152,25 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.outputtbl1
+ null-subquery2:b-subquery2-subquery2:a-subquery2:inputtbl1
+ TableScan
+ alias: inputtbl1
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: UDFToLong(2)
+ type: bigint
+ outputColumnNames: _col0, _col1
+ Union
Select Operator
expressions:
expr: _col0
@@ -167,46 +186,6 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.outputtbl1
- null-subquery2:b-subquery2-subquery2:a-subquery2:inputtbl1
- TableScan
- alias: inputtbl1
- Select Operator
- expressions:
- expr: key
- type: string
- expr: 2
- type: int
- outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: UDFToLong(_col1)
- type: bigint
- outputColumnNames: _col0, _col1
- Union
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.outputtbl1
Stage: Stage-7
Conditional Operator
@@ -249,31 +228,17 @@ STAGE PLANS:
expressions:
expr: key
type: string
- expr: 1
- type: int
+ expr: UDFToLong(1)
+ type: bigint
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: UDFToLong(_col1)
- type: bigint
- outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.outputtbl1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.outputtbl1
PREHOOK: query: insert overwrite table outputTbl1
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/updateAccessTime.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/updateAccessTime.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/updateAccessTime.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/updateAccessTime.q.out Fri Apr 26 19:14:49 2013
@@ -13,8 +13,6 @@ PREHOOK: query: desc extended tstsrc
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tstsrc
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
@@ -32,8 +30,6 @@ PREHOOK: query: desc extended tstsrc
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended tstsrc
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
@@ -94,8 +90,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -120,8 +114,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -146,8 +138,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -191,8 +181,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -217,8 +205,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None
@@ -243,8 +229,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string default
value string default
ds string None