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 ####
