You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jv...@apache.org on 2011/09/03 07:36:54 UTC
svn commit: r1164804 [3/6] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/ conf/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/java/org/apache/hadoop/hive/ql/ppd/
ql/src/test/results/clientpositive/ ql/src/test/results/compiler...
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Sat Sep 3 05:36:52 2011
@@ -64,11 +64,11 @@ STAGE PLANS:
PREHOOK: query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-22_369_8709666241977580995/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-36-34_074_7000535872788278693/-mr-10000
POSTHOOK: query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-22_369_8709666241977580995/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-36-34_074_7000535872788278693/-mr-10000
10 val_10
PREHOOK: query: EXPLAIN
SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
@@ -112,18 +112,22 @@ STAGE PLANS:
y
TableScan
alias: y
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
+ Filter Operator
+ predicate:
+ expr: (key = 20)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -156,7 +160,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/sdong/hive_2011-02-10_16-56-25_857_6745085956410995305/-mr-10002
+ file:/tmp/charleschen/hive_2011-08-04_15-36-37_183_5233818336294938355/-mr-10002
Reduce Output Operator
key expressions:
expr: _col1
@@ -190,11 +194,11 @@ STAGE PLANS:
PREHOOK: query: SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-25_950_4577225496126879083/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-36-37_259_5028248286950507899/-mr-10000
POSTHOOK: query: SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-06-51_471_1696629323983265212/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-36-37_259_5028248286950507899/-mr-10000
20 val_20 20
PREHOOK: query: EXPLAIN
SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
@@ -258,11 +262,11 @@ STAGE PLANS:
PREHOOK: query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-07-07_755_9086280220307924310/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-36-43_271_3465064583325875867/-mr-10000
POSTHOOK: query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-07-07_755_9086280220307924310/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-36-43_271_3465064583325875867/-mr-10000
10 val_10
PREHOOK: query: EXPLAIN
SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
@@ -306,18 +310,22 @@ STAGE PLANS:
y
TableScan
alias: y
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
+ Filter Operator
+ predicate:
+ expr: (key = 20)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -346,7 +354,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-07-16_261_4934200005006221322/-mr-10002
+ file:/tmp/charleschen/hive_2011-08-04_15-36-46_356_4821991475262302737/-mr-10002
Reduce Output Operator
key expressions:
expr: _col1
@@ -380,9 +388,9 @@ STAGE PLANS:
PREHOOK: query: SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-07-16_525_2344085515974635436/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-36-46_432_7875891648142135101/-mr-10000
POSTHOOK: query: SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-07-16_525_2344085515974635436/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-36-46_432_7875891648142135101/-mr-10000
20 val_20 20
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out Sat Sep 3 05:36:52 2011
@@ -35,7 +35,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (((key > '1') and (key < '400')) and ((key > '20') and ((value < 'val_50') or (key > '2'))))
+ expr: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4'))
type: boolean
Filter Operator
predicate:
@@ -71,7 +71,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key > '2') and (key <> '4'))
+ expr: (((key > '2') and (key <> '4')) and (key > '20'))
type: boolean
Filter Operator
predicate:
@@ -131,7 +131,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-14-53_815_8679319347089159838/-mr-10002
+ file:/tmp/charleschen/hive_2011-09-02_01-42-48_535_4878843339526148696/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -210,7 +210,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (((key > '1') and (key < '400')) and ((key > '20') and ((value < 'val_50') or (key > '2'))))
+ expr: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4'))
type: boolean
Select Operator
expressions:
@@ -238,7 +238,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key > '2') and (key <> '4'))
+ expr: (((key > '2') and (key <> '4')) and (key > '20'))
type: boolean
Select Operator
expressions:
@@ -294,7 +294,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-14-54_718_7102065647101283820/-mr-10002
+ file:/tmp/charleschen/hive_2011-09-02_01-42-48_602_2740815544468478597/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out Sat Sep 3 05:36:52 2011
@@ -32,7 +32,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (((key > '1') and (key < '400')) and ((key > '20') and ((value < 'val_50') or (key > '2'))))
+ expr: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4'))
type: boolean
Filter Operator
predicate:
@@ -68,7 +68,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key > '2') and (key <> '4'))
+ expr: (((key > '2') and (key <> '4')) and (key > '20'))
type: boolean
Filter Operator
predicate:
@@ -136,7 +136,7 @@ ON src1.c1 = src2.c3 AND src1.c1 < '400'
WHERE src1.c1 > '20' and (src1.c2 < 'val_50' or src1.c1 > '2') and (src2.c3 > '50' or src1.c1 < '50') and (src2.c3 <> '4')
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-19-54_404_4275400666711143229/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-42-48_824_3632303142451515406/-mr-10000
POSTHOOK: query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key > '1' ) src1
@@ -146,7 +146,7 @@ ON src1.c1 = src2.c3 AND src1.c1 < '400'
WHERE src1.c1 > '20' and (src1.c2 < 'val_50' or src1.c1 > '2') and (src2.c3 > '50' or src1.c1 < '50') and (src2.c3 <> '4')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-19-54_404_4275400666711143229/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-42-48_824_3632303142451515406/-mr-10000
200 val_200
200 val_200
200 val_200
@@ -599,7 +599,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (((key > '1') and (key < '400')) and ((key > '20') and ((value < 'val_50') or (key > '2'))))
+ expr: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4'))
type: boolean
Select Operator
expressions:
@@ -627,7 +627,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key > '2') and (key <> '4'))
+ expr: (((key > '2') and (key <> '4')) and (key > '20'))
type: boolean
Select Operator
expressions:
@@ -691,7 +691,7 @@ ON src1.c1 = src2.c3 AND src1.c1 < '400'
WHERE src1.c1 > '20' and (src1.c2 < 'val_50' or src1.c1 > '2') and (src2.c3 > '50' or src1.c1 < '50') and (src2.c3 <> '4')
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-20-04_832_4076756605206612832/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-42-51_952_8897790092802296390/-mr-10000
POSTHOOK: query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key > '1' ) src1
@@ -701,7 +701,7 @@ ON src1.c1 = src2.c3 AND src1.c1 < '400'
WHERE src1.c1 > '20' and (src1.c2 < 'val_50' or src1.c1 > '2') and (src2.c3 > '50' or src1.c1 < '50') and (src2.c3 <> '4')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-20-04_832_4076756605206612832/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-42-51_952_8897790092802296390/-mr-10000
200 val_200
200 val_200
200 val_200
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out Sat Sep 3 05:36:52 2011
@@ -39,7 +39,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (((key <> '302') and (key < '400')) and ((key <> '311') and ((value <> 'val_50') or (key > '1'))))
+ expr: (((((key <> '302') and (key < '400')) and (key <> '311')) and ((value <> 'val_50') or (key > '1'))) and (key <> '14'))
type: boolean
Filter Operator
predicate:
@@ -75,7 +75,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key <> '305') and (key <> '14'))
+ expr: (((key <> '305') and (key <> '14')) and (key <> '311'))
type: boolean
Filter Operator
predicate:
@@ -214,7 +214,7 @@ ON src1.c2 = src3.c6
WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-22-23_609_8022409171851868425/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-42-55_124_4723588678163255919/-mr-10000
POSTHOOK: query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1
@@ -227,7 +227,7 @@ ON src1.c2 = src3.c6
WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-22-23_609_8022409171851868425/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-42-55_124_4723588678163255919/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -1787,7 +1787,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (((key <> '302') and (key < '400')) and ((key <> '311') and ((value <> 'val_50') or (key > '1'))))
+ expr: (((((key <> '302') and (key < '400')) and (key <> '311')) and ((value <> 'val_50') or (key > '1'))) and (key <> '14'))
type: boolean
Select Operator
expressions:
@@ -1815,7 +1815,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key <> '305') and (key <> '14'))
+ expr: (((key <> '305') and (key <> '14')) and (key <> '311'))
type: boolean
Select Operator
expressions:
@@ -1946,7 +1946,7 @@ ON src1.c2 = src3.c6
WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-22-44_680_6270114164732441996/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-01_070_3030707364446902556/-mr-10000
POSTHOOK: query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1
@@ -1959,7 +1959,7 @@ ON src1.c2 = src3.c6
WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-22-44_680_6270114164732441996/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-01_070_3030707364446902556/-mr-10000
0 val_0
0 val_0
0 val_0
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out Sat Sep 3 05:36:52 2011
@@ -38,7 +38,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (((key <> '11') and (key < '400')) and ((key > '0') and ((value <> 'val_500') or (key > '1'))))
+ expr: ((((((key <> '11') and (key < '400')) and (key > '0')) and ((value <> 'val_500') or (key > '1'))) and (key <> '4')) and (key <> '1'))
type: boolean
Filter Operator
predicate:
@@ -74,7 +74,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key <> '12') and (key <> '4'))
+ expr: ((((key <> '12') and (key <> '4')) and (key > '0')) and (key <> '1'))
type: boolean
Filter Operator
predicate:
@@ -106,7 +106,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key <> '13') and (key <> '1'))
+ expr: ((((key <> '13') and (key <> '1')) and (key > '0')) and (key <> '4'))
type: boolean
Filter Operator
predicate:
@@ -175,7 +175,7 @@ ON src1.c1 = src3.c5
WHERE src1.c1 > '0' and (src1.c2 <> 'val_500' or src1.c1 > '1') and (src2.c3 > '10' or src1.c1 <> '10') and (src2.c3 <> '4') and (src3.c5 <> '1')
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-25-08_238_6256269886850027827/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-07_619_1453826768084640880/-mr-10000
POSTHOOK: query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key <> '11' ) src1
@@ -188,7 +188,7 @@ ON src1.c1 = src3.c5
WHERE src1.c1 > '0' and (src1.c2 <> 'val_500' or src1.c1 > '1') and (src2.c3 > '10' or src1.c1 <> '10') and (src2.c3 <> '4') and (src3.c5 <> '1')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-25-08_238_6256269886850027827/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-07_619_1453826768084640880/-mr-10000
100 val_100
100 val_100
100 val_100
@@ -1804,7 +1804,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: (((key <> '11') and (key < '400')) and ((key > '0') and ((value <> 'val_500') or (key > '1'))))
+ expr: ((((((key <> '11') and (key < '400')) and (key > '0')) and ((value <> 'val_500') or (key > '1'))) and (key <> '4')) and (key <> '1'))
type: boolean
Select Operator
expressions:
@@ -1832,7 +1832,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key <> '12') and (key <> '4'))
+ expr: ((((key <> '12') and (key <> '4')) and (key > '0')) and (key <> '1'))
type: boolean
Select Operator
expressions:
@@ -1860,7 +1860,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key <> '13') and (key <> '1'))
+ expr: ((((key <> '13') and (key <> '1')) and (key > '0')) and (key <> '4'))
type: boolean
Select Operator
expressions:
@@ -1925,7 +1925,7 @@ ON src1.c1 = src3.c5
WHERE src1.c1 > '0' and (src1.c2 <> 'val_500' or src1.c1 > '1') and (src2.c3 > '10' or src1.c1 <> '10') and (src2.c3 <> '4') and (src3.c5 <> '1')
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-25-20_069_5364583495609185769/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-11_066_6822218162992622708/-mr-10000
POSTHOOK: query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key <> '11' ) src1
@@ -1938,7 +1938,7 @@ ON src1.c1 = src3.c5
WHERE src1.c1 > '0' and (src1.c2 <> 'val_500' or src1.c1 > '1') and (src2.c3 > '10' or src1.c1 <> '10') and (src2.c3 <> '4') and (src3.c5 <> '1')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-25-20_069_5364583495609185769/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-11_066_6822218162992622708/-mr-10000
100 val_100
100 val_100
100 val_100
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out Sat Sep 3 05:36:52 2011
@@ -51,20 +51,24 @@ STAGE PLANS:
b
TableScan
alias: b
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -110,7 +114,7 @@ PREHOOK: query: FROM
WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-30-10_517_1449004673525932594/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-05_529_7524832807059785440/-mr-10000
POSTHOOK: query: FROM
src a
LEFT OUTER JOIN
@@ -120,7 +124,7 @@ POSTHOOK: query: FROM
WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-30-10_517_1449004673525932594/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-05_529_7524832807059785440/-mr-10000
17 val_17 17 val_17
18 val_18 18 val_18
18 val_18 18 val_18
@@ -180,20 +184,24 @@ STAGE PLANS:
b
TableScan
alias: b
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: ((key > 10) and (key < 20))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -239,7 +247,7 @@ PREHOOK: query: FROM
WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-30-20_062_1274880924259137309/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-08_922_5421203911417883432/-mr-10000
POSTHOOK: query: FROM
src a
LEFT OUTER JOIN
@@ -249,7 +257,7 @@ POSTHOOK: query: FROM
WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-30-20_062_1274880924259137309/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-08_922_5421203911417883432/-mr-10000
17 val_17 17 val_17
18 val_18 18 val_18
18 val_18 18 val_18
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join2.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join2.q.out Sat Sep 3 05:36:52 2011
@@ -30,20 +30,24 @@ STAGE PLANS:
a
TableScan
alias: a
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: ((key > '15') and (key < '25'))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
b
TableScan
alias: b
@@ -110,7 +114,7 @@ PREHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-32-34_464_515670423172601583/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-12_487_4675144577619468840/-mr-10000
POSTHOOK: query: FROM
src a
RIGHT OUTER JOIN
@@ -120,7 +124,7 @@ POSTHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-32-34_464_515670423172601583/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-12_487_4675144577619468840/-mr-10000
150 val_150 150 val_150
152 val_152 152 val_152
152 val_152 152 val_152
@@ -279,20 +283,24 @@ STAGE PLANS:
a
TableScan
alias: a
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: ((key > '15') and (key < '25'))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
b
TableScan
alias: b
@@ -359,7 +367,7 @@ PREHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-32-44_509_6575656481631571931/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-15_904_8893399901344877562/-mr-10000
POSTHOOK: query: FROM
src a
RIGHT OUTER JOIN
@@ -369,7 +377,7 @@ POSTHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-32-44_509_6575656481631571931/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-15_904_8893399901344877562/-mr-10000
150 val_150 150 val_150
152 val_152 152 val_152
152 val_152 152 val_152
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join3.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join3.q.out Sat Sep 3 05:36:52 2011
@@ -106,7 +106,7 @@ PREHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-35-23_324_1018503791576708396/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-38_227_6875647004112557777/-mr-10000
POSTHOOK: query: FROM
src a
FULL OUTER JOIN
@@ -116,7 +116,7 @@ POSTHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-35-23_324_1018503791576708396/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-38_227_6875647004112557777/-mr-10000
150 val_150 150 val_150
152 val_152 152 val_152
152 val_152 152 val_152
@@ -317,7 +317,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col4, _col5
Filter Operator
predicate:
- expr: (((_col4 > '15') and (_col4 < '25')) and ((_col0 > '10') and (_col0 < '20')))
+ expr: ((((_col4 > '15') and (_col4 < '25')) and (_col0 > '10')) and (_col0 < '20'))
type: boolean
Select Operator
expressions:
@@ -351,7 +351,7 @@ PREHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-35-35_138_6944101774390059493/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-41_093_7202863058007595374/-mr-10000
POSTHOOK: query: FROM
src a
FULL OUTER JOIN
@@ -361,7 +361,7 @@ POSTHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-35-35_138_6944101774390059493/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-43-41_093_7202863058007595374/-mr-10000
150 val_150 150 val_150
152 val_152 152 val_152
152 val_152 152 val_152
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out Sat Sep 3 05:36:52 2011
@@ -36,37 +36,45 @@ STAGE PLANS:
a
TableScan
alias: a
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (sqrt(key) <> 13)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
b
TableScan
alias: b
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (sqrt(key) <> 13)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
c
TableScan
alias: c
@@ -138,7 +146,7 @@ PREHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/nt/ng21tg0n1jl4547lw0k8lg6hq_nw87/T/charleschen/hive_2011-08-31_17-04-03_652_7389043450109466394/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-01_23-11-00_875_1322768464355263916/-mr-10000
POSTHOOK: query: FROM
src a
LEFT OUTER JOIN
@@ -151,7 +159,7 @@ POSTHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/nt/ng21tg0n1jl4547lw0k8lg6hq_nw87/T/charleschen/hive_2011-08-31_17-04-03_652_7389043450109466394/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-01_23-11-00_875_1322768464355263916/-mr-10000
150 val_150 150 val_150 150
152 val_152 152 val_152 152
152 val_152 152 val_152 152
@@ -420,37 +428,45 @@ STAGE PLANS:
a
TableScan
alias: a
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (sqrt(key) <> 13)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
b
TableScan
alias: b
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (sqrt(key) <> 13)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
c
TableScan
alias: c
@@ -483,7 +499,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col4, _col5, _col8
Filter Operator
predicate:
- expr: (((_col4 > '15') and (_col4 < '25')) and ((_col0 > '10') and (_col0 < '20')))
+ expr: ((((_col4 > '15') and (_col4 < '25')) and (_col0 > '10')) and (_col0 < '20'))
type: boolean
Select Operator
expressions:
@@ -522,7 +538,7 @@ PREHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/nt/ng21tg0n1jl4547lw0k8lg6hq_nw87/T/charleschen/hive_2011-08-31_17-04-10_850_6246519718607931090/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-01_23-11-04_380_1054655426630257377/-mr-10000
POSTHOOK: query: FROM
src a
LEFT OUTER JOIN
@@ -535,7 +551,7 @@ POSTHOOK: query: FROM
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/nt/ng21tg0n1jl4547lw0k8lg6hq_nw87/T/charleschen/hive_2011-08-31_17-04-10_850_6246519718607931090/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-01_23-11-04_380_1054655426630257377/-mr-10000
150 val_150 150 val_150 150
152 val_152 152 val_152 152
152 val_152 152 val_152 152
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join5.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join5.q.out Sat Sep 3 05:36:52 2011
@@ -36,41 +36,49 @@ STAGE PLANS:
t1
TableScan
alias: t1
- Reduce Output Operator
- key expressions:
- expr: id
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: id
- type: int
- tag: 0
- value expressions:
- expr: id
- type: int
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (id = 20)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: id
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: id
+ type: int
+ tag: 0
+ value expressions:
+ expr: id
+ type: int
+ expr: key
+ type: string
+ expr: value
+ type: string
t2
TableScan
alias: t2
- Reduce Output Operator
- key expressions:
- expr: id
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: id
- type: int
- tag: 1
- value expressions:
- expr: id
- type: int
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (id = 20)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: id
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: id
+ type: int
+ tag: 1
+ value expressions:
+ expr: id
+ type: int
+ expr: key
+ type: string
+ expr: value
+ type: string
t3
TableScan
alias: t3
@@ -156,22 +164,26 @@ STAGE PLANS:
t1
TableScan
alias: t1
- Reduce Output Operator
- key expressions:
- expr: id
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: id
- type: int
- tag: 0
- value expressions:
- expr: id
- type: int
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (id = 20)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: id
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: id
+ type: int
+ tag: 0
+ value expressions:
+ expr: id
+ type: int
+ expr: key
+ type: string
+ expr: value
+ type: string
t2
TableScan
alias: t2
@@ -198,22 +210,26 @@ STAGE PLANS:
t3
TableScan
alias: t3
- Reduce Output Operator
- key expressions:
- expr: id
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: id
- type: int
- tag: 2
- value expressions:
- expr: id
- type: int
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (id = 20)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: id
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: id
+ type: int
+ tag: 2
+ value expressions:
+ expr: id
+ type: int
+ expr: key
+ type: string
+ expr: value
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -276,22 +292,26 @@ STAGE PLANS:
t1
TableScan
alias: t1
- Reduce Output Operator
- key expressions:
- expr: id
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: id
- type: int
- tag: 0
- value expressions:
- expr: id
- type: int
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (id = 20)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: id
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: id
+ type: int
+ tag: 0
+ value expressions:
+ expr: id
+ type: int
+ expr: key
+ type: string
+ expr: value
+ type: string
t2
TableScan
alias: t2
@@ -318,22 +338,26 @@ STAGE PLANS:
t3
TableScan
alias: t3
- Reduce Output Operator
- key expressions:
- expr: id
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: id
- type: int
- tag: 2
- value expressions:
- expr: id
- type: int
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (id = 20)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: id
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: id
+ type: int
+ tag: 2
+ value expressions:
+ expr: id
+ type: int
+ expr: key
+ type: string
+ expr: value
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out Sat Sep 3 05:36:52 2011
@@ -64,24 +64,28 @@ STAGE PLANS:
b
TableScan
alias: b
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
+ Filter Operator
+ predicate:
+ expr: CASE (key) WHEN ('27') THEN (true) WHEN ('38') THEN (false) ELSE (null) END
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -124,7 +128,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-19_011_6078693060764998539/-mr-10002
+ file:/tmp/charleschen/hive_2011-08-04_15-38-40_124_3085325060954835780/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -190,7 +194,7 @@ ORDER BY a.key, a.value, a.ds, a.hr, b.k
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-20_085_7457265695938103038/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-40_241_9100931972676880091/-mr-10000
POSTHOOK: query: SELECT *
FROM srcpart a JOIN srcpart b
ON a.key = b.key
@@ -205,7 +209,7 @@ ORDER BY a.key, a.value, a.ds, a.hr, b.k
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-20_085_7457265695938103038/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-40_241_9100931972676880091/-mr-10000
27 val_27 2008-04-08 11 27 val_27 2008-04-08 11
27 val_27 2008-04-08 11 27 val_27 2008-04-08 12
27 val_27 2008-04-08 12 27 val_27 2008-04-08 11
@@ -276,24 +280,28 @@ STAGE PLANS:
b
TableScan
alias: b
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
+ Filter Operator
+ predicate:
+ expr: CASE (key) WHEN ('27') THEN (true) WHEN ('38') THEN (false) ELSE (null) END
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -332,7 +340,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-40_322_7654615073140246084/-mr-10002
+ file:/tmp/charleschen/hive_2011-08-04_15-38-46_616_4592989379602081302/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -398,7 +406,7 @@ ORDER BY a.key, a.value, a.ds, a.hr, b.k
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-40_840_3692167909003016050/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-46_730_8355573912192239451/-mr-10000
POSTHOOK: query: SELECT *
FROM srcpart a JOIN srcpart b
ON a.key = b.key
@@ -413,7 +421,7 @@ ORDER BY a.key, a.value, a.ds, a.hr, b.k
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-53-40_840_3692167909003016050/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-38-46_730_8355573912192239451/-mr-10000
27 val_27 2008-04-08 11 27 val_27 2008-04-08 11
27 val_27 2008-04-08 11 27 val_27 2008-04-08 12
27 val_27 2008-04-08 12 27 val_27 2008-04-08 11
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_union.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_union.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_union.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_union.q.out Sat Sep 3 05:36:52 2011
@@ -32,7 +32,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key < '100') and ((key > '4') and (value > 'val_4')))
+ expr: (((key < '100') and (key > '4')) and (value > 'val_4'))
type: boolean
Filter Operator
predicate:
@@ -68,7 +68,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key > '150') and ((key > '4') and (value > 'val_4')))
+ expr: (((key > '150') and (key > '4')) and (value > 'val_4'))
type: boolean
Filter Operator
predicate:
@@ -114,7 +114,7 @@ SELECT unioned_query.*
WHERE key > '4' and value > 'val_4'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-56-10_639_4479616588694636353/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-44-09_715_1551540406669139169/-mr-10000
POSTHOOK: query: FROM (
FROM src select src.key, src.value WHERE src.key < '100'
UNION ALL
@@ -124,7 +124,7 @@ SELECT unioned_query.*
WHERE key > '4' and value > 'val_4'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-56-10_639_4479616588694636353/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-44-09_715_1551540406669139169/-mr-10000
86 val_86
409 val_409
98 val_98
@@ -330,7 +330,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key < '100') and ((key > '4') and (value > 'val_4')))
+ expr: (((key < '100') and (key > '4')) and (value > 'val_4'))
type: boolean
Select Operator
expressions:
@@ -358,7 +358,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key > '150') and ((key > '4') and (value > 'val_4')))
+ expr: (((key > '150') and (key > '4')) and (value > 'val_4'))
type: boolean
Select Operator
expressions:
@@ -396,7 +396,7 @@ SELECT unioned_query.*
WHERE key > '4' and value > 'val_4'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-56-19_201_5931398035634081896/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-44-12_643_7895934749177186967/-mr-10000
POSTHOOK: query: FROM (
FROM src select src.key, src.value WHERE src.key < '100'
UNION ALL
@@ -406,7 +406,7 @@ SELECT unioned_query.*
WHERE key > '4' and value > 'val_4'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-56-19_201_5931398035634081896/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-09-02_01-44-12_643_7895934749177186967/-mr-10000
86 val_86
409 val_409
98 val_98