You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/06/12 19:13:50 UTC
svn commit: r1492291 - in /hive/trunk/ql/src/test: queries/clientpositive/
results/clientpositive/
Author: hashutosh
Date: Wed Jun 12 17:13:50 2013
New Revision: 1492291
URL: http://svn.apache.org/r1492291
Log:
HIVE-4717 : Fix non-deterministic TestCliDriver on 0.23 (Brock Noland via Ashutosh Chauhan)
Modified:
hive/trunk/ql/src/test/queries/clientpositive/ctas_colname.q
hive/trunk/ql/src/test/queries/clientpositive/groupby_grouping_sets4.q
hive/trunk/ql/src/test/queries/clientpositive/join32_lessSize.q
hive/trunk/ql/src/test/queries/clientpositive/multi_insert_lateral_view.q
hive/trunk/ql/src/test/queries/clientpositive/orc_diff_part_cols.q
hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out
hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out
hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out
hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out
Modified: hive/trunk/ql/src/test/queries/clientpositive/ctas_colname.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/ctas_colname.q?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/ctas_colname.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/ctas_colname.q Wed Jun 12 17:13:50 2013
@@ -6,43 +6,43 @@ explain
create table summary as select *, sum(key), count(value) from src;
create table summary as select *, sum(key), count(value) from src;
describe formatted summary;
-select * from summary;
+select * from summary order by `_col0`, `_col1`, `_c1`, `_c2`;
-- window functions
explain
create table x4 as select *, rank() over(partition by key order by value) as rr from src1;
create table x4 as select *, rank() over(partition by key order by value) as rr from src1;
describe formatted x4;
-select * from x4;
+select * from x4 order by key, value, rr;
explain
create table x5 as select *, lead(key,1) over(partition by key order by value) from src limit 20;
create table x5 as select *, lead(key,1) over(partition by key order by value) from src limit 20;
describe formatted x5;
-select * from x5;
+select * from x5 order by key, value, tok_windowspec;
-- sub queries
explain
create table x6 as select * from (select *, max(key) from src1) a;
create table x6 as select * from (select *, max(key) from src1) a;
describe formatted x6;
-select * from x6;
+select * from x6 order by `_col0`, `_c1`;
explain
create table x7 as select * from (select * from src group by key) a;
create table x7 as select * from (select * from src group by key) a;
describe formatted x7;
-select * from x7;
+select * from x7 order by `_col0`;
explain
create table x8 as select * from (select * from src group by key having key < 9) a;
create table x8 as select * from (select * from src group by key having key < 9) a;
describe formatted x8;
-select * from x8;
+select * from x8 order by `_col0`;
explain
create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a;
create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a;
describe formatted x9;
-select * from x9;
+select * from x9 order by key, `_c0`;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby_grouping_sets4.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby_grouping_sets4.q?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby_grouping_sets4.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby_grouping_sets4.q Wed Jun 12 17:13:50 2013
@@ -12,13 +12,13 @@ SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a;
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b;
SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a;
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b;
set hive.new.job.grouping.set.cardinality=2;
@@ -29,11 +29,11 @@ SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a;
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b;
SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a;
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b;
Modified: hive/trunk/ql/src/test/queries/clientpositive/join32_lessSize.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/join32_lessSize.q?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/join32_lessSize.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/join32_lessSize.q Wed Jun 12 17:13:50 2013
@@ -18,7 +18,7 @@ SELECT x.key, z.value, y.value
FROM src1 x JOIN src y ON (x.key = y.key)
JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11);
-select * from dest_j1 x order by x.key;
+select * from dest_j1 x order by x.value;
EXPLAIN EXTENDED
INSERT OVERWRITE TABLE dest_j1
@@ -33,7 +33,7 @@ FROM src w JOIN src1 x ON (x.value = w.v
JOIN src y ON (x.key = y.key)
JOIN src1 z ON (x.key = z.key);
-select * from dest_j1 x order by x.key;
+select * from dest_j1 x order by x.value;
EXPLAIN EXTENDED
INSERT OVERWRITE TABLE dest_j2
@@ -46,7 +46,7 @@ SELECT res.key, z.value, res.value
FROM (select x.key, x.value from src1 x JOIN src y ON (x.key = y.key)) res
JOIN srcpart z ON (res.value = z.value and z.ds='2008-04-08' and z.hr=11);
-select * from dest_j2 x order by x.key;
+select * from dest_j2 x order by x.value;
EXPLAIN EXTENDED
INSERT OVERWRITE TABLE dest_j2
@@ -59,7 +59,7 @@ SELECT res.key, z.value, res.value
FROM (select x.key, x.value from src1 x LEFT OUTER JOIN src y ON (x.key = y.key)) res
JOIN srcpart z ON (res.value = z.value and z.ds='2008-04-08' and z.hr=11);
-select * from dest_j2 x order by x.key;
+select * from dest_j2 x order by x.value;
EXPLAIN
INSERT OVERWRITE TABLE dest_j2
@@ -72,7 +72,7 @@ SELECT res.key, x.value, res.value
FROM (select x.key, x.value from src1 x JOIN src y ON (x.key = y.key)) res
JOIN srcpart x ON (res.value = x.value and x.ds='2008-04-08' and x.hr=11);
-select * from dest_j2 x order by x.key;
+select * from dest_j2 x order by x.value;
EXPLAIN
INSERT OVERWRITE TABLE dest_j2
@@ -85,4 +85,4 @@ SELECT res.key, y.value, res.value
FROM (select x.key, x.value from src1 x JOIN src y ON (x.key = y.key)) res
JOIN srcpart y ON (res.value = y.value and y.ds='2008-04-08' and y.hr=11);
-select * from dest_j2 x order by x.key;
+select * from dest_j2 x order by x.value;
Modified: hive/trunk/ql/src/test/queries/clientpositive/multi_insert_lateral_view.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/multi_insert_lateral_view.q?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/multi_insert_lateral_view.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/multi_insert_lateral_view.q Wed Jun 12 17:13:50 2013
@@ -18,8 +18,8 @@ from src_10
insert overwrite table src_lv1 select key, C lateral view explode(array(key+1, key+2)) A as C
insert overwrite table src_lv2 select key, C lateral view explode(array(key+3, key+4)) A as C;
-select * from src_lv1;
-select * from src_lv2;
+select * from src_lv1 order by key, value;
+select * from src_lv2 order by key, value;
-- 2(LV+GBY)
-- TS[0]-LVF[1]-SEL[2]-LVJ[5]-SEL[11]-GBY[12]-RS[13]-GBY[14]-SEL[15]-FS[16]
@@ -35,8 +35,8 @@ from src_10
insert overwrite table src_lv1 select key, sum(C) lateral view explode(array(key+1, key+2)) A as C group by key
insert overwrite table src_lv2 select key, sum(C) lateral view explode(array(key+3, key+4)) A as C group by key;
-select * from src_lv1;
-select * from src_lv2;
+select * from src_lv1 order by key, value;
+select * from src_lv2 order by key, value;
-- (LV+GBY) + RS:2GBY
-- TS[0]-LVF[1]-SEL[2]-LVJ[5]-SEL[6]-GBY[7]-RS[8]-GBY[9]-SEL[10]-FS[11]
@@ -54,9 +54,9 @@ insert overwrite table src_lv1 select ke
insert overwrite table src_lv2 select key, count(value) where key > 200 group by key
insert overwrite table src_lv3 select key, count(value) where key < 200 group by key;
-select * from src_lv1;
-select * from src_lv2;
-select * from src_lv3;
+select * from src_lv1 order by key, value;
+select * from src_lv2 order by key, value;
+select * from src_lv3 order by key, value;
-- todo: shared distinct columns (should work with hive.optimize.multigroupby.common.distincts)
-- 2(LV+GBY) + RS:2GBY
@@ -76,9 +76,9 @@ insert overwrite table src_lv1 select C,
insert overwrite table src_lv2 select C, sum(distinct key) lateral view explode(array(key+3, key+4)) A as C group by C
insert overwrite table src_lv3 select value, sum(distinct key) group by value;
-select * from src_lv1;
-select * from src_lv2;
-select * from src_lv3;
+select * from src_lv1 order by key, value;
+select * from src_lv2 order by key, value;
+select * from src_lv3 order by key, value;
create table src_lv4 (key string, value string);
@@ -96,7 +96,7 @@ insert overwrite table src_lv2 select ke
insert overwrite table src_lv3 select value, sum(distinct key) where key > 200 group by value
insert overwrite table src_lv4 select value, sum(distinct key) where key < 200 group by value;
-select * from src_lv1;
-select * from src_lv2;
-select * from src_lv3;
-select * from src_lv4;
+select * from src_lv1 order by key, value;
+select * from src_lv2 order by key, value;
+select * from src_lv3 order by key, value;
+select * from src_lv4 order by key, value;
Modified: hive/trunk/ql/src/test/queries/clientpositive/orc_diff_part_cols.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/orc_diff_part_cols.q?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/orc_diff_part_cols.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/orc_diff_part_cols.q Wed Jun 12 17:13:50 2013
@@ -16,4 +16,4 @@ ALTER TABLE test_orc ADD COLUMNS (cnt IN
INSERT OVERWRITE TABLE test_orc PARTITION (part = '2') SELECT key, count(*) FROM src GROUP BY key LIMIT 5;
-SELECT * FROM test_orc;
+SELECT * FROM test_orc ORDER BY key;
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out Wed Jun 12 17:13:50 2013
@@ -141,11 +141,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from summary
+PREHOOK: query: select * from summary order by `_col0`, `_col1`, `_c1`, `_c2`
PREHOOK: type: QUERY
PREHOOK: Input: default@summary
#### A masked pattern was here ####
-POSTHOOK: query: select * from summary
+POSTHOOK: query: select * from summary order by `_col0`, `_col1`, `_c1`, `_c2`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@summary
#### A masked pattern was here ####
@@ -273,11 +273,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from x4
+PREHOOK: query: select * from x4 order by key, value, rr
PREHOOK: type: QUERY
PREHOOK: Input: default@x4
#### A masked pattern was here ####
-POSTHOOK: query: select * from x4
+POSTHOOK: query: select * from x4 order by key, value, rr
POSTHOOK: type: QUERY
POSTHOOK: Input: default@x4
#### A masked pattern was here ####
@@ -453,33 +453,33 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from x5
+PREHOOK: query: select * from x5 order by key, value, tok_windowspec
PREHOOK: type: QUERY
PREHOOK: Input: default@x5
#### A masked pattern was here ####
-POSTHOOK: query: select * from x5
+POSTHOOK: query: select * from x5 order by key, value, tok_windowspec
POSTHOOK: type: QUERY
POSTHOOK: Input: default@x5
#### A masked pattern was here ####
+0 val_0 NULL
0 val_0 0
0 val_0 0
-0 val_0 NULL
10 val_10 NULL
-100 val_100 100
100 val_100 NULL
-103 val_103 103
+100 val_100 100
103 val_103 NULL
-104 val_104 104
+103 val_103 103
104 val_104 NULL
+104 val_104 104
105 val_105 NULL
11 val_11 NULL
111 val_111 NULL
-113 val_113 113
113 val_113 NULL
+113 val_113 113
114 val_114 NULL
116 val_116 NULL
-118 val_118 118
118 val_118 NULL
+118 val_118 118
119 val_119 119
PREHOOK: query: -- sub queries
explain
@@ -606,11 +606,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from x6
+PREHOOK: query: select * from x6 order by `_col0`, `_c1`
PREHOOK: type: QUERY
PREHOOK: Input: default@x6
#### A masked pattern was here ####
-POSTHOOK: query: select * from x6
+POSTHOOK: query: select * from x6 order by `_col0`, `_c1`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@x6
#### A masked pattern was here ####
@@ -740,11 +740,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from x7
+PREHOOK: query: select * from x7 order by `_col0`
PREHOOK: type: QUERY
PREHOOK: Input: default@x7
#### A masked pattern was here ####
-POSTHOOK: query: select * from x7
+POSTHOOK: query: select * from x7 order by `_col0`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@x7
#### A masked pattern was here ####
@@ -1186,11 +1186,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from x8
+PREHOOK: query: select * from x8 order by `_col0`
PREHOOK: type: QUERY
PREHOOK: Input: default@x8
#### A masked pattern was here ####
-POSTHOOK: query: select * from x8
+POSTHOOK: query: select * from x8 order by `_col0`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@x8
#### A masked pattern was here ####
@@ -1344,11 +1344,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from x9
+PREHOOK: query: select * from x9 order by key, `_c0`
PREHOOK: type: QUERY
PREHOOK: Input: default@x9
#### A masked pattern was here ####
-POSTHOOK: query: select * from x9
+POSTHOOK: query: select * from x9 order by key, `_c0`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@x9
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out Wed Jun 12 17:13:50 2013
@@ -19,7 +19,7 @@ SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b
PREHOOK: type: QUERY
POSTHOOK: query: -- This tests that cubes and rollups work fine inside sub-queries.
EXPLAIN
@@ -27,15 +27,16 @@ SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_TABLE_OR_COL b)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count))) (TOK_WHERE (< (TOK_TABLE_OR_COL a) 3)) (TOK_CUBE_GROUPBY (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b)))) subq1) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_TABLE_OR_COL b)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count))) (TOK_WHERE (< (TOK_TABLE_OR_COL a) 3)) (TOK_CUBE_GROUPBY (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b)))) subq2) (= (. (TOK_TABLE_OR_COL subq1) a) (. (TOK_TABLE_OR_COL subq2) a)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
+ (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_TABLE_OR_COL b)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count))) (TOK_WHERE (< (TOK_TABLE_OR_COL a) 3)) (TOK_CUBE_GROUPBY (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b)))) subq1) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_TABLE_OR_COL b)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count))) (TOK_WHERE (< (TOK_TABLE_OR_COL a) 3)) (TOK_CUBE_GROUPBY (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b)))) subq2) (= (. (TOK_TABLE_OR_COL subq1) a) (. (TOK_TABLE_OR_COL subq2) a)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL subq1) a)) (TOK_TABSORTCOLNAMEASC (.
(TOK_TABLE_OR_COL subq1) b)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL subq2) a)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL subq2) b)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3
- Stage-3 is a root stage
+ Stage-2 depends on stages: Stage-1, Stage-4
+ Stage-3 depends on stages: Stage-2
+ Stage-4 is a root stage
Stage-0 is a root stage
STAGE PLANS:
@@ -184,12 +185,50 @@ STAGE PLANS:
compressed: false
GlobalTableId: 0
table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
+#### A masked pattern was here ####
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col3
+ type: string
+ expr: _col4
+ type: string
+ sort order: ++++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: bigint
+ expr: _col3
+ type: string
+ expr: _col4
+ type: string
+ expr: _col5
+ type: bigint
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-4
+ Map Reduce
+ Alias -> Map Operator Tree:
subq2:t1
TableScan
alias: t1
@@ -276,7 +315,7 @@ PREHOOK: query: SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
@@ -284,7 +323,7 @@ POSTHOOK: query: SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
#### A masked pattern was here ####
@@ -308,7 +347,7 @@ SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b
PREHOOK: type: QUERY
POSTHOOK: query: -- Since 4 grouping sets would be generated for each sub-query, an additional MR job should be created
-- for each of them
@@ -317,17 +356,18 @@ SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_TABLE_OR_COL b)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count))) (TOK_WHERE (< (TOK_TABLE_OR_COL a) 3)) (TOK_CUBE_GROUPBY (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b)))) subq1) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_TABLE_OR_COL b)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count))) (TOK_WHERE (< (TOK_TABLE_OR_COL a) 3)) (TOK_CUBE_GROUPBY (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b)))) subq2) (= (. (TOK_TABLE_OR_COL subq1) a) (. (TOK_TABLE_OR_COL subq2) a)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
+ (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_TABLE_OR_COL b)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count))) (TOK_WHERE (< (TOK_TABLE_OR_COL a) 3)) (TOK_CUBE_GROUPBY (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b)))) subq1) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_TABLE_OR_COL b)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count))) (TOK_WHERE (< (TOK_TABLE_OR_COL a) 3)) (TOK_CUBE_GROUPBY (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b)))) subq2) (= (. (TOK_TABLE_OR_COL subq1) a) (. (TOK_TABLE_OR_COL subq2) a)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL subq1) a)) (TOK_TABSORTCOLNAMEASC (.
(TOK_TABLE_OR_COL subq1) b)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL subq2) a)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL subq2) b)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1
- Stage-3 depends on stages: Stage-2, Stage-5
- Stage-4 is a root stage
- Stage-5 depends on stages: Stage-4
+ Stage-3 depends on stages: Stage-2, Stage-6
+ Stage-4 depends on stages: Stage-3
+ Stage-5 is a root stage
+ Stage-6 depends on stages: Stage-5
Stage-0 is a root stage
STAGE PLANS:
@@ -515,12 +555,50 @@ STAGE PLANS:
compressed: false
GlobalTableId: 0
table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
+#### A masked pattern was here ####
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col3
+ type: string
+ expr: _col4
+ type: string
+ sort order: ++++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: bigint
+ expr: _col3
+ type: string
+ expr: _col4
+ type: string
+ expr: _col5
+ type: bigint
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-5
+ Map Reduce
+ Alias -> Map Operator Tree:
subq2:t1
TableScan
alias: t1
@@ -583,7 +661,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -646,7 +724,7 @@ PREHOOK: query: SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
@@ -654,7 +732,7 @@ POSTHOOK: query: SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq2
-on subq1.a = subq2.a
+on subq1.a = subq2.a order by subq1.a, subq1.b, subq2.a, subq2.b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out Wed Jun 12 17:13:50 2013
@@ -375,11 +375,11 @@ POSTHOOK: Output: default@dest_j1
POSTHOOK: Lineage: dest_j1.key SIMPLE [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.val2 EXPRESSION [(src)y.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from dest_j1 x order by x.key
+PREHOOK: query: select * from dest_j1 x order by x.value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j1
#### A masked pattern was here ####
-POSTHOOK: query: select * from dest_j1 x order by x.key
+POSTHOOK: query: select * from dest_j1 x order by x.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j1
#### A masked pattern was here ####
@@ -1540,11 +1540,11 @@ POSTHOOK: Lineage: dest_j1.val2 EXPRESSI
POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(src)y.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.value SIMPLE [(src1)z.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from dest_j1 x order by x.key
+PREHOOK: query: select * from dest_j1 x order by x.value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j1
#### A masked pattern was here ####
-POSTHOOK: query: select * from dest_j1 x order by x.key
+POSTHOOK: query: select * from dest_j1 x order by x.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j1
#### A masked pattern was here ####
@@ -2021,11 +2021,11 @@ POSTHOOK: Lineage: dest_j1.value SIMPLE
POSTHOOK: Lineage: dest_j2.key SIMPLE [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.val2 SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from dest_j2 x order by x.key
+PREHOOK: query: select * from dest_j2 x order by x.value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j2
#### A masked pattern was here ####
-POSTHOOK: query: select * from dest_j2 x order by x.key
+POSTHOOK: query: select * from dest_j2 x order by x.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j2
#### A masked pattern was here ####
@@ -2521,11 +2521,11 @@ POSTHOOK: Lineage: dest_j2.val2 SIMPLE [
POSTHOOK: Lineage: dest_j2.val2 SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from dest_j2 x order by x.key
+PREHOOK: query: select * from dest_j2 x order by x.value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j2
#### A masked pattern was here ####
-POSTHOOK: query: select * from dest_j2 x order by x.key
+POSTHOOK: query: select * from dest_j2 x order by x.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j2
#### A masked pattern was here ####
@@ -2541,23 +2541,16 @@ POSTHOOK: Lineage: dest_j2.val2 SIMPLE [
POSTHOOK: Lineage: dest_j2.val2 SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
- val_27 val_27
- val_165 val_165
- val_409 val_409
- val_409 val_409
- val_409 val_409
- val_165 val_165
- val_484 val_484
- val_265 val_265
- val_265 val_265
- val_193 val_193
- val_193 val_193
- val_193 val_193
146 val_146 val_146
146 val_146 val_146
146 val_146 val_146
146 val_146 val_146
150 val_150 val_150
+ val_165 val_165
+ val_165 val_165
+ val_193 val_193
+ val_193 val_193
+ val_193 val_193
213 val_213 val_213
213 val_213 val_213
213 val_213 val_213
@@ -2570,6 +2563,9 @@ POSTHOOK: Lineage: dest_j2.value SIMPLE
255 val_255 val_255
255 val_255 val_255
255 val_255 val_255
+ val_265 val_265
+ val_265 val_265
+ val_27 val_27
273 val_273 val_273
273 val_273 val_273
273 val_273 val_273
@@ -2633,6 +2629,10 @@ POSTHOOK: Lineage: dest_j2.value SIMPLE
406 val_406 val_406
406 val_406 val_406
406 val_406 val_406
+ val_409 val_409
+ val_409 val_409
+ val_409 val_409
+ val_484 val_484
66 val_66 val_66
98 val_98 val_98
98 val_98 val_98
@@ -2833,11 +2833,11 @@ POSTHOOK: Lineage: dest_j2.val2 SIMPLE [
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)x.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from dest_j2 x order by x.key
+PREHOOK: query: select * from dest_j2 x order by x.value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j2
#### A masked pattern was here ####
-POSTHOOK: query: select * from dest_j2 x order by x.key
+POSTHOOK: query: select * from dest_j2 x order by x.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j2
#### A masked pattern was here ####
@@ -3142,11 +3142,11 @@ POSTHOOK: Lineage: dest_j2.value SIMPLE
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)x.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j2.value SIMPLE [(srcpart)y.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from dest_j2 x order by x.key
+PREHOOK: query: select * from dest_j2 x order by x.value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j2
#### A masked pattern was here ####
-POSTHOOK: query: select * from dest_j2 x order by x.key
+POSTHOOK: query: select * from dest_j2 x order by x.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j2
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out Wed Jun 12 17:13:50 2013
@@ -289,11 +289,11 @@ POSTHOOK: Lineage: src_lv1.key SCRIPT [(
POSTHOOK: Lineage: src_lv1.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv2.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-PREHOOK: query: select * from src_lv1
+PREHOOK: query: select * from src_lv1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1
+POSTHOOK: query: select * from src_lv1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -301,31 +301,31 @@ POSTHOOK: Lineage: src_lv1.key SCRIPT [(
POSTHOOK: Lineage: src_lv1.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv2.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-238 239.0
-238 240.0
-86 87.0
-86 88.0
-311 312.0
-311 313.0
-27 28.0
-27 29.0
165 166.0
165 167.0
-409 410.0
-409 411.0
+238 239.0
+238 240.0
255 256.0
255 257.0
+27 28.0
+27 29.0
278 279.0
278 280.0
-98 99.0
-98 100.0
+311 312.0
+311 313.0
+409 410.0
+409 411.0
484 485.0
484 486.0
-PREHOOK: query: select * from src_lv2
+86 87.0
+86 88.0
+98 100.0
+98 99.0
+PREHOOK: query: select * from src_lv2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2
+POSTHOOK: query: select * from src_lv2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -333,26 +333,26 @@ POSTHOOK: Lineage: src_lv1.key SCRIPT [(
POSTHOOK: Lineage: src_lv1.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv2.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-238 241.0
-238 242.0
-86 89.0
-86 90.0
-311 314.0
-311 315.0
-27 30.0
-27 31.0
165 168.0
165 169.0
-409 412.0
-409 413.0
+238 241.0
+238 242.0
255 258.0
255 259.0
+27 30.0
+27 31.0
278 281.0
278 282.0
-98 101.0
-98 102.0
+311 314.0
+311 315.0
+409 412.0
+409 413.0
484 487.0
484 488.0
+86 89.0
+86 90.0
+98 101.0
+98 102.0
PREHOOK: query: -- 2(LV+GBY)
-- TS[0]-LVF[1]-SEL[2]-LVJ[5]-SEL[11]-GBY[12]-RS[13]-GBY[14]-SEL[15]-FS[16]
-- -SEL[3]-UDTF[4]-LVJ[5]
@@ -646,11 +646,11 @@ POSTHOOK: Lineage: src_lv2.key SCRIPT [(
POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv2.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-PREHOOK: query: select * from src_lv1
+PREHOOK: query: select * from src_lv1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1
+POSTHOOK: query: select * from src_lv1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -672,11 +672,11 @@ POSTHOOK: Lineage: src_lv2.value EXPRESS
484 971.0
86 175.0
98 199.0
-PREHOOK: query: select * from src_lv2
+PREHOOK: query: select * from src_lv2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2
+POSTHOOK: query: select * from src_lv2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -1011,11 +1011,11 @@ POSTHOOK: Lineage: src_lv2.value EXPRESS
POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.null, ]
POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.null, ]
-PREHOOK: query: select * from src_lv1
+PREHOOK: query: select * from src_lv1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1
+POSTHOOK: query: select * from src_lv1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -1043,11 +1043,11 @@ POSTHOOK: Lineage: src_lv3.value EXPRESS
484 971.0
86 175.0
98 199.0
-PREHOOK: query: select * from src_lv2
+PREHOOK: query: select * from src_lv2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2
+POSTHOOK: query: select * from src_lv2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -1071,11 +1071,11 @@ POSTHOOK: Lineage: src_lv3.value EXPRESS
311 1
409 1
484 1
-PREHOOK: query: select * from src_lv3
+PREHOOK: query: select * from src_lv3 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv3
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv3
+POSTHOOK: query: select * from src_lv3 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv3
#### A masked pattern was here ####
@@ -1520,11 +1520,11 @@ POSTHOOK: Lineage: src_lv3.key SIMPLE [(
POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.null, ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-PREHOOK: query: select * from src_lv1
+PREHOOK: query: select * from src_lv1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1
+POSTHOOK: query: select * from src_lv1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -1548,11 +1548,6 @@ POSTHOOK: Lineage: src_lv3.key SIMPLE [(
POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.null, ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-28.0 27.0
-29.0 27.0
-87.0 86.0
-88.0 86.0
-99.0 98.0
100.0 98.0
166.0 165.0
167.0 165.0
@@ -1561,18 +1556,23 @@ POSTHOOK: Lineage: src_lv3.value EXPRESS
256.0 255.0
257.0 255.0
279.0 278.0
+28.0 27.0
280.0 278.0
+29.0 27.0
312.0 311.0
313.0 311.0
410.0 409.0
411.0 409.0
485.0 484.0
486.0 484.0
-PREHOOK: query: select * from src_lv2
+87.0 86.0
+88.0 86.0
+99.0 98.0
+PREHOOK: query: select * from src_lv2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2
+POSTHOOK: query: select * from src_lv2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -1596,10 +1596,6 @@ POSTHOOK: Lineage: src_lv3.key SIMPLE [(
POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.null, ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-30.0 27.0
-31.0 27.0
-89.0 86.0
-90.0 86.0
101.0 98.0
102.0 98.0
168.0 165.0
@@ -1610,17 +1606,21 @@ POSTHOOK: Lineage: src_lv3.value EXPRESS
259.0 255.0
281.0 278.0
282.0 278.0
+30.0 27.0
+31.0 27.0
314.0 311.0
315.0 311.0
412.0 409.0
413.0 409.0
487.0 484.0
488.0 484.0
-PREHOOK: query: select * from src_lv3
+89.0 86.0
+90.0 86.0
+PREHOOK: query: select * from src_lv3 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv3
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv3
+POSTHOOK: query: select * from src_lv3 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv3
#### A masked pattern was here ####
@@ -2146,11 +2146,11 @@ POSTHOOK: Lineage: src_lv3.value EXPRESS
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION []
POSTHOOK: Lineage: src_lv4.value EXPRESSION []
-PREHOOK: query: select * from src_lv1
+PREHOOK: query: select * from src_lv1 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv1
+POSTHOOK: query: select * from src_lv1 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv1
#### A masked pattern was here ####
@@ -2190,11 +2190,11 @@ POSTHOOK: Lineage: src_lv4.value EXPRESS
484 971.0
86 175.0
98 199.0
-PREHOOK: query: select * from src_lv2
+PREHOOK: query: select * from src_lv2 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv2
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv2
+POSTHOOK: query: select * from src_lv2 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv2
#### A masked pattern was here ####
@@ -2234,11 +2234,11 @@ POSTHOOK: Lineage: src_lv4.value EXPRESS
484 975.0
86 179.0
98 203.0
-PREHOOK: query: select * from src_lv3
+PREHOOK: query: select * from src_lv3 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv3
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv3
+POSTHOOK: query: select * from src_lv3 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv3
#### A masked pattern was here ####
@@ -2274,11 +2274,11 @@ val_278 278.0
val_311 311.0
val_409 409.0
val_484 484.0
-PREHOOK: query: select * from src_lv4
+PREHOOK: query: select * from src_lv4 order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv4
#### A masked pattern was here ####
-POSTHOOK: query: select * from src_lv4
+POSTHOOK: query: select * from src_lv4 order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_lv4
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out?rev=1492291&r1=1492290&r2=1492291&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out Wed Jun 12 17:13:50 2013
@@ -48,13 +48,13 @@ POSTHOOK: Output: default@test_orc@part=
POSTHOOK: Lineage: test_orc PARTITION(part=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: test_orc PARTITION(part=2).cnt EXPRESSION [(src)src.null, ]
POSTHOOK: Lineage: test_orc PARTITION(part=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT * FROM test_orc
+PREHOOK: query: SELECT * FROM test_orc ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@test_orc
PREHOOK: Input: default@test_orc@part=1
PREHOOK: Input: default@test_orc@part=2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM test_orc
+POSTHOOK: query: SELECT * FROM test_orc ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_orc
POSTHOOK: Input: default@test_orc@part=1
@@ -63,13 +63,13 @@ POSTHOOK: Input: default@test_orc@part=2
POSTHOOK: Lineage: test_orc PARTITION(part=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: test_orc PARTITION(part=2).cnt EXPRESSION [(src)src.null, ]
POSTHOOK: Lineage: test_orc PARTITION(part=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-238 NULL 1
-86 NULL 1
-311 NULL 1
-27 NULL 1
-165 NULL 1
0 3 2
10 1 2
100 2 2
103 2 2
104 2 2
+165 NULL 1
+238 NULL 1
+27 NULL 1
+311 NULL 1
+86 NULL 1