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 2014/04/08 02:19:44 UTC
svn commit: r1585632 [13/13] - in /hive/branches/branch-0.13/ql/src/test:
queries/clientpositive/ results/clientpositive/ results/clientpositive/tez/
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/tez/subquery_in.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/tez/subquery_in.q.out?rev=1585632&r1=1585631&r2=1585632&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/tez/subquery_in.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/tez/subquery_in.q.out Tue Apr 8 00:19:43 2014
@@ -180,12 +180,14 @@ STAGE PLANS:
PREHOOK: query: select *
from src
where src.key in (select key from src s1 where s1.key > '9')
+order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: select *
from src
where src.key in (select key from src s1 where s1.key > '9')
+order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -300,6 +302,7 @@ where b.key in
from src a
where b.value = a.value and a.key > '9'
)
+order by b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -310,6 +313,7 @@ where b.key in
from src a
where b.value = a.value and a.key > '9'
)
+order by b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -458,6 +462,7 @@ part where part.p_size in
from (select p_size, rank() over(partition by p_mfgr order by p_size) as r from part) a
where r <= 2
)
+order by p_name
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
@@ -468,6 +473,7 @@ part where part.p_size in
from (select p_size, rank() over(partition by p_mfgr order by p_size) as r from part) a
where r <= 2
)
+order by p_name
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
@@ -608,6 +614,7 @@ from part b where b.p_size in
from (select p_mfgr, p_size, rank() over(partition by p_mfgr order by p_size) as r from part) a
where r <= 2 and b.p_mfgr = a.p_mfgr
)
+order by p_mfgr, p_name, p_size
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
@@ -617,15 +624,16 @@ from part b where b.p_size in
from (select p_mfgr, p_size, rank() over(partition by p_mfgr order by p_size) as r from part) a
where r <= 2 and b.p_mfgr = a.p_mfgr
)
+order by p_mfgr, p_name, p_size
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#3 almond antique misty red olive 1
Manufacturer#1 almond antique burnished rose metallic 2
Manufacturer#1 almond antique burnished rose metallic 2
Manufacturer#2 almond aquamarine midnight light salmon 2
-Manufacturer#5 almond antique sky peru orange 2
+Manufacturer#3 almond antique misty red olive 1
Manufacturer#4 almond aquamarine yellow dodger mint 7
+Manufacturer#5 almond antique sky peru orange 2
PREHOOK: query: -- distinct, corr
explain
select *
@@ -748,6 +756,7 @@ where b.key in
from src a
where b.value = a.value and a.key > '9'
)
+order by b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -758,6 +767,7 @@ where b.key in
from src a
where b.value = a.value and a.key > '9'
)
+order by b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -777,6 +787,7 @@ select p_mfgr, p_name, p_size
from part
where part.p_size in
(select first_value(p_size) over(partition by p_mfgr order by p_size) from part)
+order by p_mfgr, p_name, p_size
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
@@ -785,15 +796,16 @@ select p_mfgr, p_name, p_size
from part
where part.p_size in
(select first_value(p_size) over(partition by p_mfgr order by p_size) from part)
+order by p_mfgr, p_name, p_size
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#3 almond antique misty red olive 1
Manufacturer#1 almond antique burnished rose metallic 2
-Manufacturer#5 almond antique sky peru orange 2
-Manufacturer#2 almond aquamarine midnight light salmon 2
Manufacturer#1 almond antique burnished rose metallic 2
+Manufacturer#2 almond aquamarine midnight light salmon 2
+Manufacturer#3 almond antique misty red olive 1
Manufacturer#4 almond aquamarine yellow dodger mint 7
+Manufacturer#5 almond antique sky peru orange 2
PREHOOK: query: -- non agg, non corr, with join in Parent Query
explain
select p.p_partkey, li.l_suppkey
@@ -939,6 +951,7 @@ PREHOOK: query: select p.p_partkey, li.l
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR')
+order by p.p_partkey, li.l_suppkey
PREHOOK: type: QUERY
PREHOOK: Input: default@lineitem
#### A masked pattern was here ####
@@ -946,24 +959,26 @@ POSTHOOK: query: select p.p_partkey, li.
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR')
+order by p.p_partkey, li.l_suppkey
POSTHOOK: type: QUERY
POSTHOOK: Input: default@lineitem
#### A masked pattern was here ####
-155190 7706
+2320 9821
4297 1798
-108570 8571
-82704 7721
+40216 217
61336 8855
-2320 9821
+64128 9141
+82704 7721
+108570 8571
115118 7630
115209 7721
-64128 9141
-40216 217
+155190 7706
PREHOOK: query: -- non agg, corr, with join in Parent Query
select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber)
+order by p.p_partkey, li.l_suppkey
PREHOOK: type: QUERY
PREHOOK: Input: default@lineitem
#### A masked pattern was here ####
@@ -972,6 +987,7 @@ select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber)
+order by p.p_partkey, li.l_suppkey
POSTHOOK: type: QUERY
POSTHOOK: Input: default@lineitem
#### A masked pattern was here ####
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/tez/vectorization_15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/tez/vectorization_15.q.out?rev=1585632&r1=1585631&r2=1585632&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/tez/vectorization_15.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/tez/vectorization_15.q.out Tue Apr 8 00:19:43 2014
@@ -26,6 +26,7 @@ WHERE (((cstring2 LIKE '%ss%')
AND ((ctinyint = csmallint)
AND (cdouble >= -3728))))
GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
+ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
@@ -57,6 +58,7 @@ WHERE (((cstring2 LIKE '%ss%')
AND ((ctinyint = csmallint)
AND (cdouble >= -3728))))
GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
+ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_top_level.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_top_level.q.out?rev=1585632&r1=1585631&r2=1585632&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_top_level.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_top_level.q.out Tue Apr 8 00:19:43 2014
@@ -1,18 +1,22 @@
PREHOOK: query: -- top level
explain
+select * from (
select key, 0 as value from src where key % 3 == 0 limit 3
union all
select key, 1 as value from src where key % 3 == 1 limit 3
union all
select key, 2 as value from src where key % 3 == 2 limit 3
+) q1 order by key
PREHOOK: type: QUERY
POSTHOOK: query: -- top level
explain
+select * from (
select key, 0 as value from src where key % 3 == 0 limit 3
union all
select key, 1 as value from src where key % 3 == 1 limit 3
union all
select key, 2 as value from src where key % 3 == 2 limit 3
+) q1 order by key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -29,10 +33,10 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((key % 3) = 0) (type: boolean)
+ predicate: ((key % 3) = 1) (type: boolean)
Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), 0 (type: int)
+ expressions: key (type: string), 1 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -65,13 +69,11 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ value expressions: _col0 (type: string), _col1 (type: int)
TableScan
Union
Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
@@ -79,13 +81,11 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ value expressions: _col0 (type: string), _col1 (type: int)
TableScan
Union
Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
@@ -93,13 +93,21 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ value expressions: _col0 (type: string), _col1 (type: int)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 9 Data size: 900 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-3
Map Reduce
@@ -108,10 +116,10 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((key % 3) = 1) (type: boolean)
+ predicate: ((key % 3) = 0) (type: boolean)
Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), 1 (type: int)
+ expressions: key (type: string), 0 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -171,40 +179,48 @@ STAGE PLANS:
Fetch Operator
limit: -1
-PREHOOK: query: select key, 0 as value from src where key % 3 == 0 limit 3
+PREHOOK: query: select * from (
+select key, 0 as value from src where key % 3 == 0 limit 3
union all
select key, 1 as value from src where key % 3 == 1 limit 3
union all
select key, 2 as value from src where key % 3 == 2 limit 3
+) q1 order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: select key, 0 as value from src where key % 3 == 0 limit 3
+POSTHOOK: query: select * from (
+select key, 0 as value from src where key % 3 == 0 limit 3
union all
select key, 1 as value from src where key % 3 == 1 limit 3
union all
select key, 2 as value from src where key % 3 == 2 limit 3
+) q1 order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
+165 0
238 1
+255 0
+27 0
+278 2
+311 2
409 1
484 1
-27 0
-165 0
-255 0
86 2
-311 2
-278 2
PREHOOK: query: explain
+select * from (
select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
union all
select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
+) q1 order by k
PREHOOK: type: QUERY
POSTHOOK: query: explain
+select * from (
select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
union all
select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
+) q1 order by k
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -290,13 +306,11 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 20 Data size: 2020 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
Statistics: Num rows: 20 Data size: 2020 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ value expressions: _col0 (type: string), _col1 (type: string)
TableScan
Union
Statistics: Num rows: 20 Data size: 2020 Basic stats: COMPLETE Column stats: NONE
@@ -304,35 +318,43 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 20 Data size: 2020 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
Statistics: Num rows: 20 Data size: 2020 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ value expressions: _col0 (type: string), _col1 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 20 Data size: 2020 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 20 Data size: 2020 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-5
Map Reduce
Map Operator Tree:
TableScan
- alias: s1
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ alias: s2
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
TableScan
- alias: s2
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ alias: s1
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: value (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -381,15 +403,19 @@ STAGE PLANS:
Fetch Operator
limit: -1
-PREHOOK: query: select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
+PREHOOK: query: select * from (
+select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
union all
select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
+) q1 order by k
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
+POSTHOOK: query: select * from (
+select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
union all
select s1.key as k, s2.value as v from src s1 join src s2 on (s1.key = s2.key) limit 10
+) q1 order by k
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -402,7 +428,6 @@ POSTHOOK: Input: default@src
0 val_0
0 val_0
0 val_0
-10 val_10
0 val_0
0 val_0
0 val_0
@@ -413,6 +438,7 @@ POSTHOOK: Input: default@src
0 val_0
0 val_0
10 val_10
+10 val_10
PREHOOK: query: -- ctas
explain
create table union_top as
@@ -667,23 +693,23 @@ select key, 2 as value from src where ke
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: default@union_top
-PREHOOK: query: select * from union_top
+PREHOOK: query: select * from union_top order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@union_top
#### A masked pattern was here ####
-POSTHOOK: query: select * from union_top
+POSTHOOK: query: select * from union_top order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@union_top
#### A masked pattern was here ####
+165 0
238 1
+255 0
+27 0
+278 2
+311 2
409 1
484 1
-27 0
-165 0
-255 0
86 2
-311 2
-278 2
PREHOOK: query: truncate table union_top
PREHOOK: type: TRUNCATETABLE
PREHOOK: Output: default@union_top
@@ -942,25 +968,25 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@union_top
POSTHOOK: Lineage: union_top.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: union_top.value EXPRESSION []
-PREHOOK: query: select * from union_top
+PREHOOK: query: select * from union_top order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@union_top
#### A masked pattern was here ####
-POSTHOOK: query: select * from union_top
+POSTHOOK: query: select * from union_top order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@union_top
#### A masked pattern was here ####
POSTHOOK: Lineage: union_top.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: union_top.value EXPRESSION []
+165 0
238 1
+255 0
+27 0
+278 2
+311 2
409 1
484 1
-27 0
-165 0
-255 0
86 2
-311 2
-278 2
PREHOOK: query: explain
insert overwrite table union_top
select key, 0 as value from src where key % 3 == 0 limit 3
@@ -1215,11 +1241,11 @@ POSTHOOK: Lineage: union_top.key EXPRESS
POSTHOOK: Lineage: union_top.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: union_top.value EXPRESSION []
POSTHOOK: Lineage: union_top.value EXPRESSION []
-PREHOOK: query: select * from union_top
+PREHOOK: query: select * from union_top order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@union_top
#### A masked pattern was here ####
-POSTHOOK: query: select * from union_top
+POSTHOOK: query: select * from union_top order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@union_top
#### A masked pattern was here ####
@@ -1227,15 +1253,15 @@ POSTHOOK: Lineage: union_top.key EXPRESS
POSTHOOK: Lineage: union_top.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: union_top.value EXPRESSION []
POSTHOOK: Lineage: union_top.value EXPRESSION []
+165 0
238 1
+255 0
+27 0
+278 2
+311 2
409 1
484 1
-27 0
-165 0
-255 0
86 2
-311 2
-278 2
PREHOOK: query: -- create view
explain
create view union_top_view as
@@ -1300,12 +1326,12 @@ POSTHOOK: Lineage: union_top.key EXPRESS
POSTHOOK: Lineage: union_top.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: union_top.value EXPRESSION []
POSTHOOK: Lineage: union_top.value EXPRESSION []
-PREHOOK: query: select * from union_top_view
+PREHOOK: query: select * from union_top_view order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@union_top_view
#### A masked pattern was here ####
-POSTHOOK: query: select * from union_top_view
+POSTHOOK: query: select * from union_top_view order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@union_top_view
@@ -1314,15 +1340,15 @@ POSTHOOK: Lineage: union_top.key EXPRESS
POSTHOOK: Lineage: union_top.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: union_top.value EXPRESSION []
POSTHOOK: Lineage: union_top.value EXPRESSION []
+165 0
238 1
+255 0
+27 0
+278 2
+311 2
409 1
484 1
86 2
-311 2
-278 2
-27 0
-165 0
-255 0
PREHOOK: query: drop table union_top
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@union_top
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorization_15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorization_15.q.out?rev=1585632&r1=1585631&r2=1585632&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorization_15.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorization_15.q.out Tue Apr 8 00:19:43 2014
@@ -26,6 +26,7 @@ WHERE (((cstring2 LIKE '%ss%')
AND ((ctinyint = csmallint)
AND (cdouble >= -3728))))
GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
+ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
@@ -57,6 +58,7 @@ WHERE (((cstring2 LIKE '%ss%')
AND ((ctinyint = csmallint)
AND (cdouble >= -3728))))
GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
+ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorization_part_project.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorization_part_project.q.out?rev=1585632&r1=1585631&r2=1585632&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorization_part_project.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorization_part_project.q.out Tue Apr 8 00:19:43 2014
@@ -57,9 +57,9 @@ POSTHOOK: Lineage: alltypesorc_part PART
POSTHOOK: Lineage: alltypesorc_part PARTITION(ds=2012).ctimestamp1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
POSTHOOK: Lineage: alltypesorc_part PARTITION(ds=2012).ctimestamp2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ]
POSTHOOK: Lineage: alltypesorc_part PARTITION(ds=2012).ctinyint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
-PREHOOK: query: explain select (cdouble+2) from alltypesorc_part limit 10
+PREHOOK: query: explain select (cdouble+2) c1 from alltypesorc_part order by c1 limit 10
PREHOOK: type: QUERY
-POSTHOOK: query: explain select (cdouble+2) from alltypesorc_part limit 10
+POSTHOOK: query: explain select (cdouble+2) c1 from alltypesorc_part order by c1 limit 10
POSTHOOK: type: QUERY
POSTHOOK: Lineage: alltypesorc_part PARTITION(ds=2011).cbigint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ]
POSTHOOK: Lineage: alltypesorc_part PARTITION(ds=2011).cboolean1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cboolean1, type:boolean, comment:null), ]
@@ -100,29 +100,37 @@ STAGE PLANS:
expressions: (cdouble + 2) (type: double)
outputColumnNames: _col0
Statistics: Num rows: 200 Data size: 41576 Basic stats: COMPLETE Column stats: NONE
- Limit
- Number of rows: 10
- Statistics: Num rows: 10 Data size: 2070 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 10 Data size: 2070 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Reduce Output Operator
+ key expressions: _col0 (type: double)
+ sort order: +
+ Statistics: Num rows: 200 Data size: 41576 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: double)
Execution mode: vectorized
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 200 Data size: 41576 Basic stats: COMPLETE Column stats: NONE
+ Limit
+ Number of rows: 10
+ Statistics: Num rows: 10 Data size: 2070 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 10 Data size: 2070 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
limit: 10
-PREHOOK: query: select (cdouble+2) from alltypesorc_part limit 10
+PREHOOK: query: select (cdouble+2) c1 from alltypesorc_part order by c1 limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc_part
PREHOOK: Input: default@alltypesorc_part@ds=2011
PREHOOK: Input: default@alltypesorc_part@ds=2012
#### A masked pattern was here ####
-POSTHOOK: query: select (cdouble+2) from alltypesorc_part limit 10
+POSTHOOK: query: select (cdouble+2) c1 from alltypesorc_part order by c1 limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc_part
POSTHOOK: Input: default@alltypesorc_part@ds=2011
@@ -152,13 +160,13 @@ POSTHOOK: Lineage: alltypesorc_part PART
POSTHOOK: Lineage: alltypesorc_part PARTITION(ds=2012).ctimestamp1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
POSTHOOK: Lineage: alltypesorc_part PARTITION(ds=2012).ctimestamp2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ]
POSTHOOK: Lineage: alltypesorc_part PARTITION(ds=2012).ctinyint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
--13324.0
--4211.0
+-15910.0
+-15910.0
-15811.0
--9564.0
-15009.0
-7023.0
-4965.0
--7822.0
--15429.0
+-15811.0
+-15788.0
+-15788.0
+-15547.0
-15547.0
+-15429.0
+-15429.0
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out?rev=1585632&r1=1585631&r2=1585632&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out Tue Apr 8 00:19:43 2014
@@ -43,23 +43,23 @@ POSTHOOK: Lineage: columntable.key SIMPL
POSTHOOK: Lineage: columntable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
key string
value string
-PREHOOK: query: SELECT key, value FROM columnTable
+PREHOOK: query: SELECT key, value FROM columnTable ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@columntable
#### A masked pattern was here ####
-POSTHOOK: query: SELECT key, value FROM columnTable
+POSTHOOK: query: SELECT key, value FROM columnTable ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@columntable
#### A masked pattern was here ####
POSTHOOK: Lineage: columntable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: columntable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-238 val_238
-86 val_86
-311 val_311
-27 val_27
165 val_165
-409 val_409
+238 val_238
255 val_255
+27 val_27
278 val_278
-98 val_98
+311 val_311
+409 val_409
484 val_484
+86 val_86
+98 val_98
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out?rev=1585632&r1=1585631&r2=1585632&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out Tue Apr 8 00:19:43 2014
@@ -75,7 +75,7 @@ POSTHOOK: Lineage: alltypesorc_wrong.sti
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
PREHOOK: query: EXPLAIN SELECT
- to_unix_timestamp(ctimestamp1),
+ to_unix_timestamp(ctimestamp1) AS c1,
year(ctimestamp1),
month(ctimestamp1),
day(ctimestamp1),
@@ -85,9 +85,10 @@ PREHOOK: query: EXPLAIN SELECT
minute(ctimestamp1),
second(ctimestamp1)
FROM alltypesorc_string
+ORDER BY c1
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT
- to_unix_timestamp(ctimestamp1),
+ to_unix_timestamp(ctimestamp1) AS c1,
year(ctimestamp1),
month(ctimestamp1),
day(ctimestamp1),
@@ -97,6 +98,7 @@ POSTHOOK: query: EXPLAIN SELECT
minute(ctimestamp1),
second(ctimestamp1)
FROM alltypesorc_string
+ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Lineage: alltypesorc_string.ctimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
POSTHOOK: Lineage: alltypesorc_string.stimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
@@ -118,21 +120,29 @@ STAGE PLANS:
expressions: to_unix_timestamp(ctimestamp1) (type: bigint), year(ctimestamp1) (type: int), month(ctimestamp1) (type: int), day(ctimestamp1) (type: int), dayofmonth(ctimestamp1) (type: int), weekofyear(ctimestamp1) (type: int), hour(ctimestamp1) (type: int), minute(ctimestamp1) (type: int), second(ctimestamp1) (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col0 (type: bigint)
+ sort order: +
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ value expressions: _col0 (type: bigint), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int)
Execution mode: vectorized
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
limit: -1
PREHOOK: query: SELECT
- to_unix_timestamp(ctimestamp1),
+ to_unix_timestamp(ctimestamp1) AS c1,
year(ctimestamp1),
month(ctimestamp1),
day(ctimestamp1),
@@ -142,11 +152,12 @@ PREHOOK: query: SELECT
minute(ctimestamp1),
second(ctimestamp1)
FROM alltypesorc_string
+ORDER BY c1
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc_string
#### A masked pattern was here ####
POSTHOOK: query: SELECT
- to_unix_timestamp(ctimestamp1),
+ to_unix_timestamp(ctimestamp1) AS c1,
year(ctimestamp1),
month(ctimestamp1),
day(ctimestamp1),
@@ -156,6 +167,7 @@ POSTHOOK: query: SELECT
minute(ctimestamp1),
second(ctimestamp1)
FROM alltypesorc_string
+ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc_string
#### A masked pattern was here ####
@@ -164,48 +176,48 @@ POSTHOOK: Lineage: alltypesorc_string.st
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
-28786 1969 12 31 31 1 23 59 46
NULL NULL NULL NULL NULL NULL NULL NULL NULL
-28795 1969 12 31 31 1 23 59 55
28784 1969 12 31 31 1 23 59 44
-28790 1969 12 31 31 1 23 59 50
-28815 1970 1 1 1 1 0 0 15
-28807 1970 1 1 1 1 0 0 7
-28804 1970 1 1 1 1 0 0 4
-28792 1969 12 31 31 1 23 59 52
28784 1969 12 31 31 1 23 59 44
28784 1969 12 31 31 1 23 59 44
-28805 1970 1 1 1 1 0 0 5
-28814 1970 1 1 1 1 0 0 14
-28813 1970 1 1 1 1 0 0 13
+28784 1969 12 31 31 1 23 59 44
+28785 1969 12 31 31 1 23 59 45
+28786 1969 12 31 31 1 23 59 46
28787 1969 12 31 31 1 23 59 47
-28809 1970 1 1 1 1 0 0 9
-28792 1969 12 31 31 1 23 59 52
-28800 1970 1 1 1 1 0 0 0
-28805 1970 1 1 1 1 0 0 5
-28798 1969 12 31 31 1 23 59 58
+28788 1969 12 31 31 1 23 59 48
28789 1969 12 31 31 1 23 59 49
-28811 1970 1 1 1 1 0 0 11
-28808 1970 1 1 1 1 0 0 8
-28802 1970 1 1 1 1 0 0 2
-28804 1970 1 1 1 1 0 0 4
-28784 1969 12 31 31 1 23 59 44
28789 1969 12 31 31 1 23 59 49
+28790 1969 12 31 31 1 23 59 50
+28792 1969 12 31 31 1 23 59 52
+28792 1969 12 31 31 1 23 59 52
+28792 1969 12 31 31 1 23 59 52
28792 1969 12 31 31 1 23 59 52
-28807 1970 1 1 1 1 0 0 7
28795 1969 12 31 31 1 23 59 55
-28800 1970 1 1 1 1 0 0 0
-28798 1969 12 31 31 1 23 59 58
-28807 1970 1 1 1 1 0 0 7
28795 1969 12 31 31 1 23 59 55
-28785 1969 12 31 31 1 23 59 45
-28788 1969 12 31 31 1 23 59 48
+28795 1969 12 31 31 1 23 59 55
+28798 1969 12 31 31 1 23 59 58
+28798 1969 12 31 31 1 23 59 58
+28800 1970 1 1 1 1 0 0 0
+28800 1970 1 1 1 1 0 0 0
+28802 1970 1 1 1 1 0 0 2
28803 1970 1 1 1 1 0 0 3
-28808 1970 1 1 1 1 0 0 8
-28792 1969 12 31 31 1 23 59 52
+28804 1970 1 1 1 1 0 0 4
+28804 1970 1 1 1 1 0 0 4
+28805 1970 1 1 1 1 0 0 5
+28805 1970 1 1 1 1 0 0 5
28806 1970 1 1 1 1 0 0 6
+28807 1970 1 1 1 1 0 0 7
+28807 1970 1 1 1 1 0 0 7
+28807 1970 1 1 1 1 0 0 7
+28808 1970 1 1 1 1 0 0 8
+28808 1970 1 1 1 1 0 0 8
+28809 1970 1 1 1 1 0 0 9
+28811 1970 1 1 1 1 0 0 11
+28813 1970 1 1 1 1 0 0 13
+28814 1970 1 1 1 1 0 0 14
+28815 1970 1 1 1 1 0 0 15
PREHOOK: query: EXPLAIN SELECT
- to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(stimestamp1) AS c1,
year(stimestamp1),
month(stimestamp1),
day(stimestamp1),
@@ -215,9 +227,10 @@ PREHOOK: query: EXPLAIN SELECT
minute(stimestamp1),
second(stimestamp1)
FROM alltypesorc_string
+ORDER BY c1
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT
- to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(stimestamp1) AS c1,
year(stimestamp1),
month(stimestamp1),
day(stimestamp1),
@@ -227,6 +240,7 @@ POSTHOOK: query: EXPLAIN SELECT
minute(stimestamp1),
second(stimestamp1)
FROM alltypesorc_string
+ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Lineage: alltypesorc_string.ctimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
POSTHOOK: Lineage: alltypesorc_string.stimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
@@ -248,21 +262,29 @@ STAGE PLANS:
expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1) (type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1) (type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1) (type: int), second(stimestamp1) (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col0 (type: bigint)
+ sort order: +
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ value expressions: _col0 (type: bigint), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int)
Execution mode: vectorized
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
limit: -1
PREHOOK: query: SELECT
- to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(stimestamp1) AS c1,
year(stimestamp1),
month(stimestamp1),
day(stimestamp1),
@@ -272,11 +294,12 @@ PREHOOK: query: SELECT
minute(stimestamp1),
second(stimestamp1)
FROM alltypesorc_string
+ORDER BY c1
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc_string
#### A masked pattern was here ####
POSTHOOK: query: SELECT
- to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(stimestamp1) AS c1,
year(stimestamp1),
month(stimestamp1),
day(stimestamp1),
@@ -286,6 +309,7 @@ POSTHOOK: query: SELECT
minute(stimestamp1),
second(stimestamp1)
FROM alltypesorc_string
+ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc_string
#### A masked pattern was here ####
@@ -294,48 +318,48 @@ POSTHOOK: Lineage: alltypesorc_string.st
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
-28786 1969 12 31 31 1 23 59 46
NULL NULL NULL NULL NULL NULL NULL NULL NULL
-28795 1969 12 31 31 1 23 59 55
28784 1969 12 31 31 1 23 59 44
-28790 1969 12 31 31 1 23 59 50
-28815 1970 1 1 1 1 0 0 15
-28807 1970 1 1 1 1 0 0 7
-28804 1970 1 1 1 1 0 0 4
-28792 1969 12 31 31 1 23 59 52
28784 1969 12 31 31 1 23 59 44
28784 1969 12 31 31 1 23 59 44
-28805 1970 1 1 1 1 0 0 5
-28814 1970 1 1 1 1 0 0 14
-28813 1970 1 1 1 1 0 0 13
+28784 1969 12 31 31 1 23 59 44
+28785 1969 12 31 31 1 23 59 45
+28786 1969 12 31 31 1 23 59 46
28787 1969 12 31 31 1 23 59 47
-28809 1970 1 1 1 1 0 0 9
-28792 1969 12 31 31 1 23 59 52
-28800 1970 1 1 1 1 0 0 0
-28805 1970 1 1 1 1 0 0 5
-28798 1969 12 31 31 1 23 59 58
+28788 1969 12 31 31 1 23 59 48
28789 1969 12 31 31 1 23 59 49
-28811 1970 1 1 1 1 0 0 11
-28808 1970 1 1 1 1 0 0 8
-28802 1970 1 1 1 1 0 0 2
-28804 1970 1 1 1 1 0 0 4
-28784 1969 12 31 31 1 23 59 44
28789 1969 12 31 31 1 23 59 49
+28790 1969 12 31 31 1 23 59 50
+28792 1969 12 31 31 1 23 59 52
+28792 1969 12 31 31 1 23 59 52
+28792 1969 12 31 31 1 23 59 52
28792 1969 12 31 31 1 23 59 52
-28807 1970 1 1 1 1 0 0 7
28795 1969 12 31 31 1 23 59 55
-28800 1970 1 1 1 1 0 0 0
-28798 1969 12 31 31 1 23 59 58
-28807 1970 1 1 1 1 0 0 7
28795 1969 12 31 31 1 23 59 55
-28785 1969 12 31 31 1 23 59 45
-28788 1969 12 31 31 1 23 59 48
+28795 1969 12 31 31 1 23 59 55
+28798 1969 12 31 31 1 23 59 58
+28798 1969 12 31 31 1 23 59 58
+28800 1970 1 1 1 1 0 0 0
+28800 1970 1 1 1 1 0 0 0
+28802 1970 1 1 1 1 0 0 2
28803 1970 1 1 1 1 0 0 3
-28808 1970 1 1 1 1 0 0 8
-28792 1969 12 31 31 1 23 59 52
+28804 1970 1 1 1 1 0 0 4
+28804 1970 1 1 1 1 0 0 4
+28805 1970 1 1 1 1 0 0 5
+28805 1970 1 1 1 1 0 0 5
28806 1970 1 1 1 1 0 0 6
+28807 1970 1 1 1 1 0 0 7
+28807 1970 1 1 1 1 0 0 7
+28807 1970 1 1 1 1 0 0 7
+28808 1970 1 1 1 1 0 0 8
+28808 1970 1 1 1 1 0 0 8
+28809 1970 1 1 1 1 0 0 9
+28811 1970 1 1 1 1 0 0 11
+28813 1970 1 1 1 1 0 0 13
+28814 1970 1 1 1 1 0 0 14
+28815 1970 1 1 1 1 0 0 15
PREHOOK: query: EXPLAIN SELECT
- to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1,
year(ctimestamp1) = year(stimestamp1),
month(ctimestamp1) = month(stimestamp1),
day(ctimestamp1) = day(stimestamp1),
@@ -345,9 +369,10 @@ PREHOOK: query: EXPLAIN SELECT
minute(ctimestamp1) = minute(stimestamp1),
second(ctimestamp1) = second(stimestamp1)
FROM alltypesorc_string
+ORDER BY c1
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT
- to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1,
year(ctimestamp1) = year(stimestamp1),
month(ctimestamp1) = month(stimestamp1),
day(ctimestamp1) = day(stimestamp1),
@@ -357,6 +382,7 @@ POSTHOOK: query: EXPLAIN SELECT
minute(ctimestamp1) = minute(stimestamp1),
second(ctimestamp1) = second(stimestamp1)
FROM alltypesorc_string
+ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Lineage: alltypesorc_string.ctimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
POSTHOOK: Lineage: alltypesorc_string.stimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
@@ -378,14 +404,22 @@ STAGE PLANS:
expressions: (to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1)) (type: boolean), (year(ctimestamp1) = year(stimestamp1)) (type: boolean), (month(ctimestamp1) = month(stimestamp1)) (type: boolean), (day(ctimestamp1) = day(stimestamp1)) (type: boolean), (dayofmonth(ctimestamp1) = dayofmonth(stimestamp1)) (type: boolean), (weekofyear(ctimestamp1) = weekofyear(stimestamp1)) (type: boolean), (hour(ctimestamp1) = hour(stimestamp1)) (type: boolean), (minute(ctimestamp1) = minute(stimestamp1)) (type: boolean), (second(ctimestamp1) = second(stimestamp1)) (type: boolean)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col0 (type: boolean)
+ sort order: +
Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ value expressions: _col0 (type: boolean), _col1 (type: boolean), _col2 (type: boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean), _col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean)
Execution mode: vectorized
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
@@ -393,7 +427,7 @@ STAGE PLANS:
PREHOOK: query: -- Should all be true or NULL
SELECT
- to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1,
year(ctimestamp1) = year(stimestamp1),
month(ctimestamp1) = month(stimestamp1),
day(ctimestamp1) = day(stimestamp1),
@@ -403,12 +437,13 @@ SELECT
minute(ctimestamp1) = minute(stimestamp1),
second(ctimestamp1) = second(stimestamp1)
FROM alltypesorc_string
+ORDER BY c1
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc_string
#### A masked pattern was here ####
POSTHOOK: query: -- Should all be true or NULL
SELECT
- to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1,
year(ctimestamp1) = year(stimestamp1),
month(ctimestamp1) = month(stimestamp1),
day(ctimestamp1) = day(stimestamp1),
@@ -418,6 +453,7 @@ SELECT
minute(ctimestamp1) = minute(stimestamp1),
second(ctimestamp1) = second(stimestamp1)
FROM alltypesorc_string
+ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc_string
#### A masked pattern was here ####
@@ -426,7 +462,6 @@ POSTHOOK: Lineage: alltypesorc_string.st
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
-true true true true true true true true true
NULL NULL NULL NULL NULL NULL NULL NULL NULL
true true true true true true true true true
true true true true true true true true true
@@ -466,9 +501,10 @@ true true true true true true true true
true true true true true true true true true
true true true true true true true true true
true true true true true true true true true
+true true true true true true true true true
PREHOOK: query: -- Wrong format. Should all be NULL.
EXPLAIN SELECT
- to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(stimestamp1) AS c1,
year(stimestamp1),
month(stimestamp1),
day(stimestamp1),
@@ -478,10 +514,11 @@ EXPLAIN SELECT
minute(stimestamp1),
second(stimestamp1)
FROM alltypesorc_wrong
+ORDER BY c1
PREHOOK: type: QUERY
POSTHOOK: query: -- Wrong format. Should all be NULL.
EXPLAIN SELECT
- to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(stimestamp1) AS c1,
year(stimestamp1),
month(stimestamp1),
day(stimestamp1),
@@ -491,6 +528,7 @@ EXPLAIN SELECT
minute(stimestamp1),
second(stimestamp1)
FROM alltypesorc_wrong
+ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Lineage: alltypesorc_string.ctimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
POSTHOOK: Lineage: alltypesorc_string.stimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
@@ -512,21 +550,29 @@ STAGE PLANS:
expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1) (type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1) (type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1) (type: int), second(stimestamp1) (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col0 (type: bigint)
+ sort order: +
Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ value expressions: _col0 (type: bigint), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int)
Execution mode: vectorized
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
limit: -1
PREHOOK: query: SELECT
- to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(stimestamp1) AS c1,
year(stimestamp1),
month(stimestamp1),
day(stimestamp1),
@@ -536,11 +582,12 @@ PREHOOK: query: SELECT
minute(stimestamp1),
second(stimestamp1)
FROM alltypesorc_wrong
+ORDER BY c1
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc_wrong
#### A masked pattern was here ####
POSTHOOK: query: SELECT
- to_unix_timestamp(stimestamp1),
+ to_unix_timestamp(stimestamp1) AS c1,
year(stimestamp1),
month(stimestamp1),
day(stimestamp1),
@@ -550,6 +597,7 @@ POSTHOOK: query: SELECT
minute(stimestamp1),
second(stimestamp1)
FROM alltypesorc_wrong
+ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc_wrong
#### A masked pattern was here ####