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/07/13 18:49:42 UTC
svn commit: r1146129 [11/41] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/test/results/clientpositive/ hbase-handler/src/test/results/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/ppd/ ...
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out Wed Jul 13 16:49:22 2011
@@ -22,23 +22,19 @@ STAGE PLANS:
predicate:
expr: (key > 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 9999)
- type: boolean
- Select Operator
- Group By Operator
- aggregations:
- expr: count(1)
- bucketGroup: false
- mode: hash
- outputColumnNames: _col0
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: _col0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -96,23 +92,19 @@ STAGE PLANS:
predicate:
expr: (key > 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 9999)
- type: boolean
- Select Operator
- Group By Operator
- aggregations:
- expr: count(1)
- bucketGroup: false
- mode: hash
- outputColumnNames: _col0
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: _col0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ bucketGroup: false
+ mode: hash
+ outputColumnNames: _col0
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -171,20 +163,16 @@ STAGE PLANS:
predicate:
expr: (key > 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 9999)
- type: boolean
- Select Operator
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: 1
- type: int
+ Select Operator
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: 1
+ type: int
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -266,17 +254,13 @@ STAGE PLANS:
predicate:
expr: (key > 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 9999)
- type: boolean
- Select Operator
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 1
- type: int
+ Select Operator
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: 1
+ type: int
Reduce Operator Tree:
Group By Operator
aggregations:
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out Wed Jul 13 16:49:22 2011
@@ -23,36 +23,32 @@ STAGE PLANS:
predicate:
expr: (key > 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ outputColumnNames: key
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ bucketGroup: false
+ keys:
expr: key
type: string
- outputColumnNames: key
- Group By Operator
- aggregations:
- expr: count(1)
- bucketGroup: false
- keys:
- expr: key
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: string
- mode: hash
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ sort order: +
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -147,36 +143,32 @@ STAGE PLANS:
predicate:
expr: (key > 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ outputColumnNames: key
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ bucketGroup: false
+ keys:
expr: key
type: string
- outputColumnNames: key
- Group By Operator
- aggregations:
- expr: count(1)
- bucketGroup: false
- keys:
- expr: key
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
type: string
- mode: hash
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -239,27 +231,23 @@ STAGE PLANS:
predicate:
expr: (key > 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ outputColumnNames: key
+ Reduce Output Operator
+ key expressions:
expr: key
type: string
- outputColumnNames: key
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: 1
- type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: 1
+ type: int
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -354,27 +342,23 @@ STAGE PLANS:
predicate:
expr: (key > 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ outputColumnNames: key
+ Reduce Output Operator
+ key expressions:
expr: key
type: string
- outputColumnNames: key
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: -1
- value expressions:
- expr: 1
- type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: -1
+ value expressions:
+ expr: 1
+ type: int
Reduce Operator Tree:
Group By Operator
aggregations:
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out Wed Jul 13 16:49:22 2011
@@ -23,39 +23,35 @@ STAGE PLANS:
predicate:
expr: (key = 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key = 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: value
+ type: string
+ outputColumnNames: value
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ expr: count(DISTINCT value)
+ bucketGroup: false
+ keys:
expr: value
type: string
- outputColumnNames: value
- Group By Operator
- aggregations:
- expr: count(1)
- expr: count(DISTINCT value)
- bucketGroup: false
- keys:
- expr: value
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: string
- mode: hash
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
- expr: _col2
- type: bigint
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
+ expr: _col2
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -143,36 +139,32 @@ STAGE PLANS:
predicate:
expr: (key = 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key = 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: value
+ type: string
+ outputColumnNames: value
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ expr: count(DISTINCT value)
+ bucketGroup: false
+ keys:
expr: value
type: string
- outputColumnNames: value
- Group By Operator
- aggregations:
- expr: count(1)
- expr: count(DISTINCT value)
- bucketGroup: false
- keys:
- expr: value
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: string
- mode: hash
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
- expr: _col2
- type: bigint
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
+ expr: _col2
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -234,27 +226,23 @@ STAGE PLANS:
predicate:
expr: (key = 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key = 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: value
+ type: string
+ outputColumnNames: value
+ Reduce Output Operator
+ key expressions:
expr: value
type: string
- outputColumnNames: value
- Reduce Output Operator
- key expressions:
- expr: value
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: value
- type: string
- tag: -1
- value expressions:
- expr: 1
- type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: value
+ type: string
+ tag: -1
+ value expressions:
+ expr: 1
+ type: int
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -342,24 +330,20 @@ STAGE PLANS:
predicate:
expr: (key = 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key = 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: value
+ type: string
+ outputColumnNames: value
+ Reduce Output Operator
+ key expressions:
expr: value
type: string
- outputColumnNames: value
- Reduce Output Operator
- key expressions:
- expr: value
- type: string
- sort order: +
- tag: -1
- value expressions:
- expr: 1
- type: int
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: 1
+ type: int
Reduce Operator Tree:
Group By Operator
aggregations:
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out Wed Jul 13 16:49:22 2011
@@ -22,43 +22,39 @@ STAGE PLANS:
predicate:
expr: (key = 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key = 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: value
+ type: string
+ outputColumnNames: value
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ expr: count(DISTINCT value)
+ expr: count(DISTINCT substr(value, 5))
+ bucketGroup: false
+ keys:
expr: value
type: string
- outputColumnNames: value
- Group By Operator
- aggregations:
- expr: count(1)
- expr: count(DISTINCT value)
- expr: count(DISTINCT substr(value, 5))
- bucketGroup: false
- keys:
- expr: value
+ expr: substr(value, 5)
+ type: string
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: string
- expr: substr(value, 5)
+ expr: _col1
type: string
- mode: hash
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: _col2
- type: bigint
- expr: _col3
- type: bigint
- expr: _col4
- type: bigint
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col2
+ type: bigint
+ expr: _col3
+ type: bigint
+ expr: _col4
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -122,26 +118,22 @@ STAGE PLANS:
predicate:
expr: (key = 9999)
type: boolean
- Filter Operator
- predicate:
- expr: (key = 9999)
- type: boolean
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: value
+ type: string
+ outputColumnNames: value
+ Reduce Output Operator
+ key expressions:
expr: value
type: string
- outputColumnNames: value
- Reduce Output Operator
- key expressions:
- expr: value
- type: string
- expr: substr(value, 5)
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: 1
- type: int
+ expr: substr(value, 5)
+ type: string
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: 1
+ type: int
Reduce Operator Tree:
Group By Operator
aggregations:
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out Wed Jul 13 16:49:22 2011
@@ -56,38 +56,6 @@ STAGE PLANS:
predicate:
expr: (ds = '2009-04-05')
type: boolean
- Filter Operator
- predicate:
- expr: (ds = '2009-04-05')
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- Union
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- null-subquery2:u-subquery2:y
- TableScan
- alias: y
- Filter Operator
- predicate:
- expr: (ds = '2009-04-09')
- type: boolean
Select Operator
expressions:
expr: key
@@ -109,6 +77,30 @@ STAGE PLANS:
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ null-subquery2:u-subquery2:y
+ TableScan
+ alias: y
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Union
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ outputColumnNames: _col0, _col1
+ 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-0
Fetch Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out Wed Jul 13 16:49:22 2011
@@ -288,7 +288,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: ((((_col0 > 10) and (_col0 < 20)) and (_col4 > 15)) and (_col4 < 25))
+ expr: (((_col4 > 15) and (_col4 < 25)) and ((_col0 > 10) and (_col0 < 20)))
type: boolean
Select Operator
expressions:
@@ -650,7 +650,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (((((_col0 > 10) and (_col0 < 20)) and (_col4 > 15)) and (_col4 < 25)) and (_col6 = '2008-04-08'))
+ expr: ((((_col4 > 15) and (_col4 < 25)) and (_col6 = '2008-04-08')) and ((_col0 > 10) and (_col0 < 20)))
type: boolean
Select Operator
expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/pcr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/pcr.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/pcr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/pcr.q.out Wed Jul 13 16:49:22 2011
@@ -81,35 +81,30 @@ STAGE PLANS:
predicate:
expr: (key < 5)
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ((ds <= '2000-04-09') and (key < 5))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col2
type: string
- expr: ds
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
+ expr: _col2
type: string
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col2
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -295,29 +290,24 @@ STAGE PLANS:
predicate:
expr: ((ds <= '2000-04-09') or (key < 5))
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ((ds <= '2000-04-09') or (key < 5))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: int
- expr: value
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- sort order: +
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -591,35 +581,30 @@ STAGE PLANS:
predicate:
expr: ((key < 5) and (value <> 'val_2'))
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((ds <= '2000-04-09') and (key < 5)) and (value <> 'val_2'))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ expr: _col2
+ type: string
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col1
type: string
- expr: ds
+ expr: _col2
type: string
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col2
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -807,35 +792,30 @@ STAGE PLANS:
predicate:
expr: (((ds < '2000-04-09') and (key < 5)) or ((ds > '2000-04-09') and (value = 'val_5')))
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((ds < '2000-04-09') and (key < 5)) or ((ds > '2000-04-09') and (value = 'val_5')))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ expr: _col2
+ type: string
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col1
type: string
- expr: ds
+ expr: _col2
type: string
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col2
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -1025,35 +1005,30 @@ STAGE PLANS:
predicate:
expr: (((ds < '2000-04-10') and (key < 5)) or ((ds > '2000-04-08') and (value = 'val_5')))
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((ds < '2000-04-10') and (key < 5)) or ((ds > '2000-04-08') and (value = 'val_5')))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ expr: _col2
+ type: string
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col1
type: string
- expr: ds
+ expr: _col2
type: string
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col2
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -1304,35 +1279,30 @@ STAGE PLANS:
predicate:
expr: (((ds < '2000-04-10') or (key < 5)) and ((ds > '2000-04-08') or (value = 'val_5')))
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((ds < '2000-04-10') or (key < 5)) and ((ds > '2000-04-08') or (value = 'val_5')))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col2
type: string
- expr: ds
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
+ expr: _col2
type: string
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col2
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -1591,31 +1561,26 @@ STAGE PLANS:
predicate:
expr: (key = 14)
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((ds = '2000-04-08') or (ds = '2000-04-09')) and (key = 14))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col1
+ type: string
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -1786,31 +1751,26 @@ STAGE PLANS:
TableScan
alias: pcr_t1
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ((ds = '2000-04-08') or (ds = '2000-04-09'))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col1
+ type: string
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -2021,31 +1981,26 @@ STAGE PLANS:
TableScan
alias: pcr_t1
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ((ds >= '2000-04-08') or (ds < '2000-04-10'))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col1
+ type: string
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- sort order: ++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -2334,37 +2289,32 @@ STAGE PLANS:
predicate:
expr: (((ds = '2000-04-08') and (key = 1)) or ((ds = '2000-04-09') and (key = 2)))
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((ds = '2000-04-08') and (key = 1)) or ((ds = '2000-04-09') and (key = 2)))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ sort order: +++
+ tag: -1
+ value expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col1
type: string
- expr: ds
+ expr: _col2
type: string
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
- sort order: +++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -2537,52 +2487,42 @@ STAGE PLANS:
TableScan
alias: t1
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (ds = '2000-04-08')
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: int
- tag: 0
- value expressions:
- expr: key
- type: int
- expr: value
- type: string
- expr: ds
- type: string
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: int
+ tag: 0
+ value expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
t2
TableScan
alias: t2
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (ds = '2000-04-08')
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: int
- tag: 1
- value expressions:
- expr: key
- type: int
- expr: value
- type: string
- expr: ds
- type: string
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: int
+ tag: 1
+ value expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
Needs Tagging: true
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [t2, t1]
@@ -2822,52 +2762,42 @@ STAGE PLANS:
TableScan
alias: t1
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (ds = '2000-04-08')
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: int
- tag: 0
- value expressions:
- expr: key
- type: int
- expr: value
- type: string
- expr: ds
- type: string
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: int
+ tag: 0
+ value expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
t2
TableScan
alias: t2
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (ds = '2000-04-09')
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: int
- tag: 1
- value expressions:
- expr: key
- type: int
- expr: value
- type: string
- expr: ds
- type: string
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: int
+ tag: 1
+ value expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
Needs Tagging: true
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [t1]
@@ -3182,37 +3112,32 @@ STAGE PLANS:
predicate:
expr: (((ds > '2000-04-08') and (ds < '2000-04-11')) or (key = 2))
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((ds > '2000-04-08') and (ds < '2000-04-11')) or (((ds >= '2000-04-08') and (ds <= '2000-04-11')) and (key = 2)))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ sort order: +++
+ tag: -1
+ value expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col1
type: string
- expr: ds
+ expr: _col2
type: string
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
- sort order: +++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -3540,37 +3465,32 @@ STAGE PLANS:
predicate:
expr: ((ds > '2000-04-08') or ((ds <= '2000-04-09') and (key = 2)))
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((ds > '2000-04-08') and (ds < '2000-04-11')) or ((ds <= '2000-04-09') and (key = 2)))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ sort order: +++
+ tag: -1
+ value expressions:
+ expr: _col0
type: int
- expr: value
+ expr: _col1
type: string
- expr: ds
+ expr: _col2
type: string
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
- sort order: +++
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/pcr_t1/ds=2000-04-08 [pcr_t1]
@@ -4753,29 +4673,24 @@ STAGE PLANS:
TableScan
alias: srcpart
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ((ds = '2008-04-08') and (hr = 11))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
type: string
- expr: value
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- tag: -1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [srcpart]
@@ -4908,41 +4823,36 @@ STAGE PLANS:
predicate:
expr: (key = 11)
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((ds = '2008-04-08') and ((hr = '11') or (hr = '12'))) and (key = 11))
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
- sort order: +++
- tag: -1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ sort order: +++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [srcpart]
@@ -5122,41 +5032,36 @@ STAGE PLANS:
predicate:
expr: (key = 11)
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ((hr = '11') and (key = 11))
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
- sort order: +++
- tag: -1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ sort order: +++
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
Needs Tagging: false
Path -> Alias:
pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [srcpart]
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out Wed Jul 13 16:49:22 2011
@@ -46,11 +46,441 @@ STAGE PLANS:
PREHOOK: query: SELECT src.key as c3 from src where src.key > '2'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-18_823_4035711180151393629/-mr-10000
+PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_01-46-31_378_5424397768218246092/-mr-10000
POSTHOOK: query: SELECT src.key as c3 from src where src.key > '2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-18_823_4035711180151393629/-mr-10000
+POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_01-46-31_378_5424397768218246092/-mr-10000
+238
+86
+311
+27
+409
+255
+278
+98
+484
+265
+401
+273
+224
+369
+66
+213
+406
+429
+374
+469
+495
+37
+327
+281
+277
+209
+82
+403
+417
+430
+252
+292
+219
+287
+338
+446
+459
+394
+237
+482
+413
+494
+207
+466
+208
+399
+396
+247
+417
+489
+377
+397
+309
+365
+266
+439
+342
+367
+325
+475
+203
+339
+455
+311
+316
+57
+302
+205
+438
+345
+20
+489
+378
+221
+92
+47
+72
+4
+280
+35
+427
+277
+208
+356
+399
+382
+498
+386
+437
+469
+286
+54
+459
+51
+239
+213
+216
+430
+278
+289
+221
+65
+318
+332
+311
+275
+241
+83
+333
+284
+230
+67
+260
+404
+384
+489
+353
+373
+272
+217
+84
+348
+466
+58
+8
+411
+230
+208
+348
+24
+463
+431
+42
+496
+322
+468
+393
+454
+298
+418
+96
+26
+327
+230
+205
+51
+404
+43
+436
+469
+468
+308
+95
+288
+481
+457
+98
+282
+318
+318
+409
+470
+369
+316
+413
+85
+77
+490
+87
+364
+395
+282
+238
+419
+72
+90
+307
+435
+277
+273
+306
+224
+309
+389
+327
+242
+369
+392
+272
+331
+401
+242
+452
+226
+5
+497
+402
+396
+317
+395
+58
+35
+336
+95
+34
+229
+233
+472
+322
+498
+42
+321
+430
+489
+458
+78
+76
+41
+223
+492
+449
+218
+228
+453
+30
+209
+64
+468
+76
+74
+342
+69
+230
+33
+368
+296
+216
+367
+344
+274
+219
+239
+485
+223
+256
+263
+70
+487
+480
+401
+288
+5
+244
+438
+467
+432
+202
+316
+229
+469
+463
+280
+35
+283
+331
+235
+80
+44
+321
+335
+466
+366
+403
+483
+53
+257
+406
+409
+406
+401
+258
+90
+203
+262
+348
+424
+396
+201
+217
+431
+454
+478
+298
+431
+424
+382
+5
+70
+397
+480
+291
+24
+351
+255
+70
+438
+414
+200
+491
+237
+439
+360
+248
+479
+305
+417
+444
+429
+443
+323
+325
+277
+230
+478
+468
+310
+317
+333
+493
+460
+207
+249
+265
+480
+83
+353
+214
+462
+233
+406
+454
+375
+401
+421
+407
+384
+256
+26
+67
+384
+379
+462
+492
+298
+9
+341
+498
+458
+362
+285
+348
+273
+281
+344
+97
+469
+315
+84
+28
+37
+448
+348
+307
+414
+477
+222
+90
+403
+400
+200
+97
+PREHOOK: query: EXPLAIN
+SELECT src.key as c3 from src where src.key > '2'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT src.key as c3 from src where src.key > '2'
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key) c3)) (TOK_WHERE (> (. (TOK_TABLE_OR_COL src) key) '2'))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ TableScan
+ alias: src
+ Filter Operator
+ predicate:
+ expr: (key > '2')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ outputColumnNames: _col0
+ 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-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: SELECT src.key as c3 from src where src.key > '2'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_01-46-40_411_5342026921630284187/-mr-10000
+POSTHOOK: query: SELECT src.key as c3 from src where src.key > '2'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_01-46-40_411_5342026921630284187/-mr-10000
238
86
311
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=1146129&r1=1146128&r2=1146129&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 Wed Jul 13 16:49:22 2011
@@ -194,5 +194,195 @@ PREHOOK: Output: file:/tmp/sdong/hive_20
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:/tmp/sdong/hive_2011-02-10_16-56-25_950_4577225496126879083/-mr-10000
+POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_02-06-51_471_1696629323983265212/-mr-10000
+20 val_20 20
+PREHOOK: query: EXPLAIN
+SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME SRC) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (= (. (TOK_TABLE_OR_COL x) key) 10)) (TOK_CLUSTERBY (. (TOK_TABLE_OR_COL x) key))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ x
+ TableScan
+ alias: x
+ Filter Operator
+ predicate:
+ expr: (key = 10)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ 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-0
+ Fetch Operator
+ limit: -1
+
+
+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
+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
+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
+PREHOOK: type: QUERY
+POSTHOOK: 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
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME SRC) x) (TOK_TABREF (TOK_TABNAME SRC) y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value) v1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) key))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL x) key) 20)) (TOK_CLUSTERBY (TOK_TABLE_OR_COL v1))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ x
+ TableScan
+ alias: x
+ 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: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ 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
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0}
+ handleSkewJoin: false
+ outputColumnNames: _col0, _col1, _col4
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col4
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+
+ 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
+ Reduce Output Operator
+ key expressions:
+ expr: _col1
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col1
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ 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-0
+ Fetch Operator
+ limit: -1
+
+
+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
+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
20 val_20 20
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out Wed Jul 13 16:49:22 2011
@@ -112,7 +112,7 @@ PREHOOK: Output: file:/tmp/sdong/hive_20
POSTHOOK: query: SELECT ppd_constant_expr.* FROM ppd_constant_expr
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppd_constant_expr
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-56-37_539_4877038009687877928/-mr-10000
+POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_03-08-49_562_6227549501988296305/-mr-10000
POSTHOOK: Lineage: ppd_constant_expr.c1 EXPRESSION []
POSTHOOK: Lineage: ppd_constant_expr.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: ppd_constant_expr.c3 EXPRESSION []
@@ -141,3 +141,150 @@ NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
+PREHOOK: query: EXPLAIN
+FROM src1
+INSERT OVERWRITE TABLE ppd_constant_expr SELECT 4 + NULL, src1.key - NULL, NULL + NULL
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+FROM src1
+INSERT OVERWRITE TABLE ppd_constant_expr SELECT 4 + NULL, src1.key - NULL, NULL + NULL
+POSTHOOK: type: QUERY
+POSTHOOK: Lineage: ppd_constant_expr.c1 EXPRESSION []
+POSTHOOK: Lineage: ppd_constant_expr.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ppd_constant_expr.c3 EXPRESSION []
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src1))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME ppd_constant_expr))) (TOK_SELECT (TOK_SELEXPR (+ 4 TOK_NULL)) (TOK_SELEXPR (- (. (TOK_TABLE_OR_COL src1) key) TOK_NULL)) (TOK_SELEXPR (+ TOK_NULL TOK_NULL)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
+ Stage-4
+ Stage-0 depends on stages: Stage-4, Stage-3
+ Stage-2 depends on stages: Stage-0
+ Stage-3
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src1
+ TableScan
+ alias: src1
+ Select Operator
+ expressions:
+ expr: (4 + null)
+ type: int
+ expr: (key - null)
+ type: double
+ expr: (null + null)
+ type: tinyint
+ outputColumnNames: _col0, _col1, _col2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ expr: UDFToInteger(_col1)
+ type: int
+ expr: UDFToDouble(_col2)
+ type: double
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.ppd_constant_expr
+
+ Stage: Stage-5
+ Conditional Operator
+
+ Stage: Stage-4
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: pfile:/Users/amarsri/Documents/workspace/hive/build/ql/scratchdir/hive_2011-03-22_03-08-50_015_6932944037979128451/-ext-10000
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace: true
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.ppd_constant_expr
+
+ Stage: Stage-2
+ Stats-Aggr Operator
+
+ Stage: Stage-3
+ Map Reduce
+ Alias -> Map Operator Tree:
+ pfile:/Users/amarsri/Documents/workspace/hive/build/ql/scratchdir/hive_2011-03-22_03-08-50_015_6932944037979128451/-ext-10002
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.ppd_constant_expr
+
+
+PREHOOK: query: FROM src1
+INSERT OVERWRITE TABLE ppd_constant_expr SELECT 4 + NULL, src1.key - NULL, NULL + NULL
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src1
+PREHOOK: Output: default@ppd_constant_expr
+POSTHOOK: query: FROM src1
+INSERT OVERWRITE TABLE ppd_constant_expr SELECT 4 + NULL, src1.key - NULL, NULL + NULL
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src1
+POSTHOOK: Output: default@ppd_constant_expr
+POSTHOOK: Lineage: ppd_constant_expr.c1 EXPRESSION []
+POSTHOOK: Lineage: ppd_constant_expr.c1 EXPRESSION []
+POSTHOOK: Lineage: ppd_constant_expr.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ppd_constant_expr.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ppd_constant_expr.c3 EXPRESSION []
+POSTHOOK: Lineage: ppd_constant_expr.c3 EXPRESSION []
+PREHOOK: query: SELECT ppd_constant_expr.* FROM ppd_constant_expr
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ppd_constant_expr
+PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_03-08-58_708_3073565512234424163/-mr-10000
+POSTHOOK: query: SELECT ppd_constant_expr.* FROM ppd_constant_expr
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ppd_constant_expr
+POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-22_03-08-58_708_3073565512234424163/-mr-10000
+POSTHOOK: Lineage: ppd_constant_expr.c1 EXPRESSION []
+POSTHOOK: Lineage: ppd_constant_expr.c1 EXPRESSION []
+POSTHOOK: Lineage: ppd_constant_expr.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ppd_constant_expr.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ppd_constant_expr.c3 EXPRESSION []
+POSTHOOK: Lineage: ppd_constant_expr.c3 EXPRESSION []
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL