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 [8/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/ q...
Modified: hive/trunk/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input6.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input6.q.out Wed Jul 13 16:49:22 2011
@@ -33,25 +33,21 @@ STAGE PLANS:
predicate:
expr: key is null
type: boolean
- Filter Operator
- predicate:
- expr: key is null
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- 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.dest1
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ 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.dest1
Stage: Stage-5
Conditional Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input9.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input9.q.out Wed Jul 13 16:49:22 2011
@@ -33,32 +33,28 @@ STAGE PLANS:
predicate:
expr: (null = null)
type: boolean
- Filter Operator
- predicate:
- expr: (null = null)
- type: boolean
+ Select Operator
+ expressions:
+ expr: null
+ type: string
+ expr: key
+ type: string
+ outputColumnNames: _col0, _col1
Select Operator
expressions:
- expr: null
- type: string
- expr: key
- type: string
+ expr: _col0
+ type: void
+ expr: UDFToInteger(_col1)
+ type: int
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: void
- expr: UDFToInteger(_col1)
- type: int
- outputColumnNames: _col0, _col1
- 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.dest1
+ 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.dest1
Stage: Stage-5
Conditional Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Wed Jul 13 16:49:22 2011
@@ -35,59 +35,54 @@ STAGE PLANS:
predicate:
expr: (key < 100)
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (((key < 100) and (ds = '2008-04-08')) and (hr = '12'))
- type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: hr
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
Select Operator
expressions:
- expr: key
+ expr: UDFToInteger(_col0)
+ type: int
+ expr: _col1
type: string
- expr: value
+ expr: _col2
type: string
- expr: hr
- type: string
- expr: ds
+ expr: _col3
type: string
outputColumnNames: _col0, _col1, _col2, _col3
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- File Output Operator
- compressed: false
- GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-59-53_966_4370880936716856186/-ext-10002
- NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-59-53_966_4370880936716856186/-ext-10000/
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- bucket_count -1
- columns key,value,hr,ds
- columns.types int:string:string:string
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
- name default.dest1
- serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297382393
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- TotalFiles: 1
- GatherStats: true
- MultiFileSpray: false
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: pfile:/Users/amarsri/Documents/workspace/hive/build/ql/scratchdir/hive_2011-03-17_09-16-00_167_373354768081382011/-ext-10002
+ NumFilesPerFileSink: 1
+ Stats Publishing Key Prefix: pfile:/Users/amarsri/Documents/workspace/hive/build/ql/scratchdir/hive_2011-03-17_09-16-00_167_373354768081382011/-ext-10000/
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ bucket_count -1
+ columns key,value,hr,ds
+ columns.types int:string:string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location pfile:/Users/amarsri/Documents/workspace/hive/build/ql/test/data/warehouse/dest1
+ name default.dest1
+ serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1300378560
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
+ TotalFiles: 1
+ GatherStats: true
+ MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [srcpart]
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out Wed Jul 13 16:49:22 2011
@@ -33,29 +33,25 @@ STAGE PLANS:
predicate:
expr: (key < 100)
type: boolean
- Filter Operator
- predicate:
- expr: ((ds = '2008-04-08') and (key < 100))
- 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
- 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.tmptable
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ 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.tmptable
Stage: Stage-5
Conditional Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out Wed Jul 13 16:49:22 2011
@@ -22,28 +22,24 @@ STAGE PLANS:
predicate:
expr: (ds = ((2008 - 4) - 8))
type: boolean
- Filter Operator
- predicate:
- expr: (ds = ((2008 - 4) - 8))
- 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
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Limit
+ 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/input_part7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out Wed Jul 13 16:49:22 2011
@@ -34,25 +34,42 @@ STAGE PLANS:
predicate:
expr: (key < 100)
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ((ds = '2008-04-08') and (key < 100))
- 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
- Union
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Union
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ sort order: ++++
+ tag: -1
+ value expressions:
expr: _col0
type: string
expr: _col1
@@ -61,28 +78,6 @@ STAGE PLANS:
type: string
expr: _col3
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- expr: _col1
- 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
null-subquery2:a-subquery2:y
TableScan
alias: y
@@ -92,25 +87,42 @@ STAGE PLANS:
predicate:
expr: (key < 100)
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ((ds = '2008-04-08') and (key < 100))
- 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
- Union
- Select Operator
- expressions:
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Union
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ sort order: ++++
+ tag: -1
+ value expressions:
expr: _col0
type: string
expr: _col1
@@ -119,28 +131,6 @@ STAGE PLANS:
type: string
expr: _col3
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- expr: _col1
- 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/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out Wed Jul 13 16:49:22 2011
@@ -24,39 +24,34 @@ STAGE PLANS:
predicate:
expr: key is not null
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (key is not null and (ds = '2008-04-08'))
- type: boolean
- Select Operator
- expressions:
- expr: key
+ 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: value
+ expr: _col3
type: string
- expr: ds
+ sort order: ++
+ tag: -1
+ value expressions:
+ expr: _col0
type: string
- expr: hr
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- Reduce Output Operator
- key expressions:
- expr: _col0
- 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/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [x]
Modified: hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out Wed Jul 13 16:49:22 2011
@@ -33,27 +33,23 @@ STAGE PLANS:
predicate:
expr: (lint is not null and (not mstringstring is null))
type: boolean
- Filter Operator
- predicate:
- expr: (lint is not null and (not mstringstring is null))
- type: boolean
- Select Operator
- expressions:
- expr: size(lint)
- type: int
- expr: size(lintstring)
- type: int
- expr: size(mstringstring)
- type: int
- 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.dest1
+ Select Operator
+ expressions:
+ expr: size(lint)
+ type: int
+ expr: size(lintstring)
+ type: int
+ expr: size(mstringstring)
+ type: int
+ 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.dest1
Stage: Stage-5
Conditional Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out Wed Jul 13 16:49:22 2011
@@ -107,23 +107,19 @@ STAGE PLANS:
predicate:
expr: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null)
type: boolean
- Filter Operator
- predicate:
- expr: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null)
- type: boolean
- Select Operator
- expressions:
- expr: mstringstring['key_9']
- type: string
- expr: lintstring.myint
- type: array<int>
- 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
+ Select Operator
+ expressions:
+ expr: mstringstring['key_9']
+ type: string
+ expr: lintstring.myint
+ type: array<int>
+ 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/join0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join0.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join0.q.out Wed Jul 13 16:49:22 2011
@@ -33,25 +33,21 @@ STAGE PLANS:
predicate:
expr: (key < 10)
type: boolean
- Filter Operator
- predicate:
- expr: (key < 10)
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ sort order:
+ tag: 0
+ value expressions:
+ expr: _col0
type: string
- expr: value
+ expr: _col1
type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- sort order:
- tag: 0
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
src2:src
TableScan
alias: src
@@ -59,25 +55,21 @@ STAGE PLANS:
predicate:
expr: (key < 10)
type: boolean
- Filter Operator
- predicate:
- expr: (key < 10)
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ sort order:
+ tag: 1
+ value expressions:
+ expr: _col0
type: string
- expr: value
+ expr: _col1
type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- sort order:
- tag: 1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/join11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join11.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join11.q.out Wed Jul 13 16:49:22 2011
@@ -37,22 +37,18 @@ STAGE PLANS:
expr: key
type: string
outputColumnNames: _col0
- Filter Operator
- predicate:
- expr: (_col0 < 100)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
src2:src
TableScan
alias: src
Modified: hive/trunk/ql/src/test/results/clientpositive/join12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join12.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join12.q.out Wed Jul 13 16:49:22 2011
@@ -43,22 +43,18 @@ STAGE PLANS:
expr: key
type: string
outputColumnNames: _col0
- Filter Operator
- predicate:
- expr: (_col0 < 100)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
src2:src
TableScan
alias: src
@@ -93,19 +89,15 @@ STAGE PLANS:
expr: key
type: string
outputColumnNames: _col0
- Filter Operator
- predicate:
- expr: (_col0 < 80)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 2
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 2
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/join13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join13.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join13.q.out Wed Jul 13 16:49:22 2011
@@ -44,22 +44,18 @@ STAGE PLANS:
expr: key
type: string
outputColumnNames: _col0
- Filter Operator
- predicate:
- expr: (_col0 < 100)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
src2:src
TableScan
alias: src
@@ -130,19 +126,15 @@ STAGE PLANS:
expr: key
type: string
outputColumnNames: _col0
- Filter Operator
- predicate:
- expr: (_col0 < 200)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: UDFToDouble(_col0)
- type: double
- sort order: +
- Map-reduce partition columns:
- expr: UDFToDouble(_col0)
- type: double
- tag: 1
+ Reduce Output Operator
+ key expressions:
+ expr: UDFToDouble(_col0)
+ type: double
+ sort order: +
+ Map-reduce partition columns:
+ expr: UDFToDouble(_col0)
+ type: double
+ tag: 1
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/join14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join14.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join14.q.out Wed Jul 13 16:49:22 2011
@@ -30,29 +30,6 @@ STAGE PLANS:
predicate:
expr: (key > 100)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 100)
- 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
- srcpart
- TableScan
- alias: srcpart
- Filter Operator
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
Reduce Output Operator
key expressions:
expr: key
@@ -61,10 +38,25 @@ STAGE PLANS:
Map-reduce partition columns:
expr: key
type: string
- tag: 1
+ tag: 0
value expressions:
- expr: value
+ expr: key
type: string
+ srcpart
+ TableScan
+ alias: srcpart
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: value
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/join16.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join16.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join16.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join16.q.out Wed Jul 13 16:49:22 2011
@@ -20,37 +20,29 @@ STAGE PLANS:
predicate:
expr: ((key > 10) and (key > 20))
type: boolean
- Filter Operator
- predicate:
- expr: (key > 10)
- 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: _col1
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ expr: _col1
type: string
- expr: value
+ tag: 0
+ value expressions:
+ expr: _col0
type: string
- outputColumnNames: _col0, _col1
- Filter Operator
- predicate:
- expr: (_col0 > 20)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- sort order: ++
- Map-reduce partition columns:
- expr: _col0
- type: string
- expr: _col1
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
tab
TableScan
alias: tab
@@ -83,23 +75,19 @@ STAGE PLANS:
1 {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col3
- Filter Operator
- predicate:
- expr: (_col3 < 200)
- type: boolean
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col3
- 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
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col3
+ 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/join19.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join19.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join19.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join19.q.out Wed Jul 13 16:49:22 2011
@@ -135,27 +135,23 @@ STAGE PLANS:
predicate:
expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Citation'))
type: boolean
- Filter Operator
- predicate:
- expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Citation'))
- type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- outputColumnNames: _col0
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ outputColumnNames: _col0
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
t22:t2
TableScan
alias: t2
@@ -163,29 +159,25 @@ STAGE PLANS:
predicate:
expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
type: boolean
- Filter Operator
- predicate:
- expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
- type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- 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: _col1
- type: string
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ 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: _col1
+ type: string
t33:t3
TableScan
alias: t3
@@ -193,29 +185,25 @@ STAGE PLANS:
predicate:
expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
type: boolean
- Filter Operator
- predicate:
- expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
- type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col1
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col1
- type: string
- tag: 2
- value expressions:
- expr: _col0
- type: string
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col1
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col1
+ type: string
+ tag: 2
+ value expressions:
+ expr: _col0
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -261,24 +249,20 @@ STAGE PLANS:
predicate:
expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Author'))
type: boolean
- Filter Operator
- predicate:
- expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Author'))
- type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- outputColumnNames: _col0
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 1
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ outputColumnNames: _col0
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
t55:t5
TableScan
alias: t5
@@ -286,29 +270,25 @@ STAGE PLANS:
predicate:
expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
type: boolean
- Filter Operator
- predicate:
- expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
- type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- 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: 2
- value expressions:
- expr: _col1
- type: string
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ 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: 2
+ value expressions:
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -356,29 +336,25 @@ STAGE PLANS:
predicate:
expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
type: boolean
- Filter Operator
- predicate:
- expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
- type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- 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: _col1
- type: string
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ 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: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join20.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join20.q.out Wed Jul 13 16:49:22 2011
@@ -25,24 +25,20 @@ STAGE PLANS:
predicate:
expr: (key < 10)
type: boolean
- Filter Operator
- predicate:
- expr: (key < 10)
- 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
+ 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
src2
TableScan
alias: src2
@@ -746,24 +742,20 @@ STAGE PLANS:
predicate:
expr: (key < 10)
type: boolean
- Filter Operator
- predicate:
- expr: (key < 10)
- 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
+ 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
src2
TableScan
alias: src2
@@ -771,24 +763,20 @@ STAGE PLANS:
predicate:
expr: (key < 15)
type: boolean
- Filter Operator
- predicate:
- expr: (key < 15)
- 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 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
src3
TableScan
alias: src3
Modified: hive/trunk/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join21.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join21.q.out Wed Jul 13 16:49:22 2011
@@ -40,24 +40,20 @@ STAGE PLANS:
predicate:
expr: (key > 10)
type: boolean
- Filter Operator
- predicate:
- expr: (key > 10)
- 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 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
src3
TableScan
alias: src3
Modified: hive/trunk/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join23.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join23.q.out Wed Jul 13 16:49:22 2011
@@ -55,27 +55,23 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col4, _col5
- Filter Operator
- predicate:
- expr: ((_col0 < 10) and (_col4 < 10))
- type: boolean
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- expr: _col4
- type: string
- expr: _col5
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col4
+ type: string
+ expr: _col5
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ 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
Modified: hive/trunk/ql/src/test/results/clientpositive/join26.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join26.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join26.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join26.q.out Wed Jul 13 16:49:22 2011
@@ -76,75 +76,65 @@ STAGE PLANS:
TableScan
alias: z
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (hr = 11)
- type: boolean
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- Inner Join 0 to 2
- condition expressions:
- 0 {key}
- 1 {value}
- 2 {value}
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[key]]
- 2 [Column[key]]
- outputColumnNames: _col0, _col5, _col9
- Position of Big Table: 2
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col5
- type: string
- expr: _col9
- type: string
- outputColumnNames: _col0, _col5, _col9
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col9
- type: string
- expr: _col5
- type: string
- outputColumnNames: _col0, _col1, _col2
- File Output Operator
- compressed: false
- GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-03-56_680_8440893894140638044/-ext-10002
- NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-03-56_680_8440893894140638044/-ext-10000/
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- bucket_count -1
- columns key,value,val2
- columns.types string:string:string
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest_j1
- name default.dest_j1
- serialization.ddl struct dest_j1 { string key, string value, string val2}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297382636
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest_j1
- TotalFiles: 1
- GatherStats: true
- MultiFileSpray: false
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 0 to 2
+ condition expressions:
+ 0 {key}
+ 1 {value}
+ 2 {value}
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[key]]
+ 2 [Column[key]]
+ outputColumnNames: _col0, _col5, _col9
+ Position of Big Table: 2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col5
+ type: string
+ expr: _col9
+ type: string
+ outputColumnNames: _col0, _col5, _col9
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col9
+ type: string
+ expr: _col5
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: pfile:/Users/amarsri/Documents/workspace/hive/build/ql/scratchdir/hive_2011-03-17_09-25-32_631_7413274741403705596/-ext-10002
+ NumFilesPerFileSink: 1
+ Stats Publishing Key Prefix: pfile:/Users/amarsri/Documents/workspace/hive/build/ql/scratchdir/hive_2011-03-17_09-25-32_631_7413274741403705596/-ext-10000/
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ bucket_count -1
+ columns key,value,val2
+ columns.types string:string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location pfile:/Users/amarsri/Documents/workspace/hive/build/ql/test/data/warehouse/dest_j1
+ name default.dest_j1
+ serialization.ddl struct dest_j1 { string key, string value, string val2}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1300379132
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest_j1
+ TotalFiles: 1
+ GatherStats: true
+ MultiFileSpray: false
Local Work:
Map Reduce Local Work
Needs Tagging: false
Modified: hive/trunk/ql/src/test/results/clientpositive/join28.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join28.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join28.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join28.q.out Wed Jul 13 16:49:22 2011
@@ -57,23 +57,15 @@ STAGE PLANS:
z
TableScan
alias: z
- Filter Operator
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Filter Operator
- predicate:
- expr: (hr = 11)
- type: boolean
- HashTable Sink Operator
- condition expressions:
- 0 {_col0}
- 1 {value}
- handleSkewJoin: false
- keys:
- 0 [Column[_col0]]
- 1 [Column[key]]
- Position of Big Table: 0
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col0}
+ 1 {value}
+ handleSkewJoin: false
+ keys:
+ 0 [Column[_col0]]
+ 1 [Column[key]]
+ Position of Big Table: 0
Stage: Stage-1
Map Reduce
Modified: hive/trunk/ql/src/test/results/clientpositive/join32.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join32.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join32.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join32.q.out Wed Jul 13 16:49:22 2011
@@ -139,25 +139,15 @@ STAGE PLANS:
TableScan
alias: z
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (hr = 11)
- type: boolean
- HashTable Sink Operator
- condition expressions:
- 0 {_col5} {_col0}
- 1 {value}
- handleSkewJoin: false
- keys:
- 0 [Column[_col1]]
- 1 [Column[value]]
- Position of Big Table: 0
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col5} {_col0}
+ 1 {value}
+ handleSkewJoin: false
+ keys:
+ 0 [Column[_col1]]
+ 1 [Column[value]]
+ Position of Big Table: 0
Stage: Stage-1
Map Reduce
Modified: hive/trunk/ql/src/test/results/clientpositive/join33.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join33.q.out?rev=1146129&r1=1146128&r2=1146129&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join33.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join33.q.out Wed Jul 13 16:49:22 2011
@@ -155,28 +155,18 @@ STAGE PLANS:
TableScan
alias: z
GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: (hr = 11)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: value
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: value
- type: string
- tag: 1
- value expressions:
- expr: value
- type: string
+ Reduce Output Operator
+ key expressions:
+ expr: value
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: value
+ type: string
+ tag: 1
+ value expressions:
+ expr: value
+ type: string
Needs Tagging: true
Path -> Alias:
file:/tmp/sdong/hive_2011-02-10_16-05-42_624_7730493356150230026/-mr-10002 [file:/tmp/sdong/hive_2011-02-10_16-05-42_624_7730493356150230026/-mr-10002]