You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by zs...@apache.org on 2009/06/23 06:35:07 UTC
svn commit: r787539 [5/20] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/conf/ conf/
ql/src/java/org/apache/hadoop/hive/ql/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/or...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out Tue Jun 23 04:35:01 2009
@@ -14,13 +14,15 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-4
+ Stage-2 depends on stages: Stage-1, Stage-7
Stage-3 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-3
- Stage-4 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-4
+ Stage-6 depends on stages: Stage-3
+ Stage-0 depends on stages: Stage-6
+ Stage-7 is a root stage
+ Stage-2 depends on stages: Stage-1, Stage-7
Stage-3 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-3
+ Stage-6 depends on stages: Stage-3
+ Stage-0 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-1
@@ -56,9 +58,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -73,7 +75,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -93,7 +95,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -106,7 +108,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10002
Union
Common Join Operator
condition map:
@@ -121,14 +123,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
columns _col0,_col1,_col2,_col3
columns.types string,bigint,string,string
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10005
Union
Common Join Operator
condition map:
@@ -143,7 +145,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -171,7 +173,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -180,10 +182,10 @@
columns.types string,bigint,string,string
Needs Tagging: false
Path -> Alias:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10002
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10005
Path -> Partition:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -193,7 +195,7 @@
serialization.ddl struct binary_table { string _col0, i64 _col1}
serialization.format com.facebook.thrift.protocol.TBinaryProtocol
name: binary_table
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10005
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -207,7 +209,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
Select Operator
Select Operator
expressions:
@@ -228,7 +230,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366087396/10000
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -242,14 +244,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Needs Tagging: false
Path -> Alias:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
Path -> Partition:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -258,30 +260,99 @@
columns _col0,_col1,_col2,_col3
columns.types string,bigint,string,string
+ Stage: Stage-6
+ Conditional Operator
+ list of dependent Tasks:
+ Move Operator
+ files:
+ hdfs directory: true
+ source: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
+ destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/387190739/10000
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: val2
+ type: int
+ Needs Tagging: false
+ Path -> Alias:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
+ Path -> Partition:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest_j1
+ columns.types string:string:int
+ serialization.ddl struct dest_j1 { string key, string value, i32 val2}
+ serialization.format 1
+ columns key,value,val2
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest_j1
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/387190739/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest_j1
+ columns.types string:string:int
+ serialization.ddl struct dest_j1 { string key, string value, i32 val2}
+ serialization.format 1
+ columns key,value,val2
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest_j1
+
Stage: Stage-0
Move Operator
tables:
- replace: true
- source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366087396/10000
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name dest_j1
- columns.types string:string:int
- serialization.ddl struct dest_j1 { string key, string value, i32 val2}
- serialization.format 1
- columns key,value,val2
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest_j1
- tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366087396/10001
+ replace: true
+ source: file:/data/users/njain/hive4/hive4/build/ql/tmp/387190739/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest_j1
+ columns.types string:string:int
+ serialization.ddl struct dest_j1 { string key, string value, i32 val2}
+ serialization.format 1
+ columns key,value,val2
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest_j1
+ tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/387190739/10001
- Stage: Stage-4
+ Stage: Stage-7
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:subq1-subquery2:x1
@@ -314,9 +385,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -331,7 +402,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -351,7 +422,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10005
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -375,7 +446,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1938414388/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/636059953/10000
128 3
146 val_146 2
150 val_150 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out Tue Jun 23 04:35:01 2009
@@ -22,7 +22,8 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
+ Stage-5 depends on stages: Stage-2
+ Stage-0 depends on stages: Stage-5
STAGE PLANS:
Stage: Stage-1
@@ -73,7 +74,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/596423728/10002
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/1544683463/10002
Select Operator
Select Operator
expressions:
@@ -92,15 +93,49 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
+ Stage: Stage-5
+ Conditional Operator
+ list of dependent Tasks:
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1680197079/10000
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/1544683463/10003
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: int
+ expr: value
+ type: int
+ expr: val2
+ type: int
+ 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
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest_j1
+
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: dest_j1
+ 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: dest_j1
query: INSERT OVERWRITE TABLE dest_j1
@@ -111,7 +146,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/976050144/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1167058397/10000
0 3 3
2 1 1
4 1 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out Tue Jun 23 04:35:01 2009
@@ -123,12 +123,12 @@
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: dest1
+ 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: dest1
query: FROM (
@@ -148,7 +148,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/432444875/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/530052399/10000
11 val_11 NULL NULL
12 val_12 NULL NULL
12 val_12 NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out Tue Jun 23 04:35:01 2009
@@ -123,12 +123,12 @@
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: dest1
+ 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: dest1
query: FROM (
@@ -148,7 +148,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/253563009/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1067150280/10000
17 val_17 17 val_17
18 val_18 18 val_18
18 val_18 18 val_18
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out Tue Jun 23 04:35:01 2009
@@ -123,12 +123,12 @@
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: dest1
+ 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: dest1
query: FROM (
@@ -148,7 +148,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1692074558/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/432321775/10000
11 val_11 NULL NULL
12 val_12 NULL NULL
12 val_12 NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out Tue Jun 23 04:35:01 2009
@@ -167,12 +167,12 @@
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: dest1
+ 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: dest1
query: FROM (
@@ -197,7 +197,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2100931525/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/220580216/10000
11 val_11 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out Tue Jun 23 04:35:01 2009
@@ -127,12 +127,12 @@
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: dest1
+ 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: dest1
query: FROM (
@@ -152,7 +152,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1676684235/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1351311232/10000
11 val_11 NULL NULL
12 val_12 NULL NULL
12 val_12 NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out Tue Jun 23 04:35:01 2009
@@ -49,10 +49,10 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -67,10 +67,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -89,7 +89,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -118,7 +118,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1807871128/10000
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2045025830/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -132,32 +132,32 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Stage: Stage-0
Move Operator
tables:
- replace: true
- source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1807871128/10000
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name dest1
- columns.types int:string
- serialization.ddl struct dest1 { i32 key, string value}
- serialization.format 1
- columns key,value
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest1
- tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1807871128/10001
+ replace: true
+ source: file:/data/users/njain/hive4/hive4/build/ql/tmp/2045025830/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+ tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2045025830/10001
query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
@@ -167,7 +167,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2004673341/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/253334300/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out Tue Jun 23 04:35:01 2009
@@ -79,12 +79,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -97,7 +97,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1089837380/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/632753703/10000
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out Tue Jun 23 04:35:01 2009
@@ -73,12 +73,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -90,7 +90,7 @@
Output: default/dest1
query: SELECT * FROM (SELECT dest1.* FROM dest1 DISTRIBUTE BY key SORT BY key, ten, one, value) T
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/784757508/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/330342098/10000
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out Tue Jun 23 04:35:01 2009
@@ -73,12 +73,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -90,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/66680643/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1070435913/10000
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out Tue Jun 23 04:35:01 2009
@@ -79,12 +79,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -97,7 +97,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/8701971/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1878933561/10000
90 9 0 val_90
90 9 0 val_90
90 9 0 val_90
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out Tue Jun 23 04:35:01 2009
@@ -73,12 +73,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -90,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1149070891/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1868021425/10000
490 49 0 val_490
491 49 1 val_491
492 49 2 val_492
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out Tue Jun 23 04:35:01 2009
@@ -73,12 +73,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -90,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2144690037/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1682992868/10000
490 49 0 val_490
491 49 1 val_491
492 49 2 val_492
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out Tue Jun 23 04:35:01 2009
@@ -85,12 +85,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -102,7 +102,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/842155825/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/222952583/10000
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out Tue Jun 23 04:35:01 2009
@@ -89,12 +89,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -107,7 +107,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1993582864/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1055686084/10000
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out Tue Jun 23 04:35:01 2009
@@ -77,12 +77,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -91,7 +91,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/632604195/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1874640355/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out Tue Jun 23 04:35:01 2009
@@ -77,12 +77,12 @@
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: dest1
+ 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: dest1
query: FROM src
@@ -91,7 +91,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1744225611/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1499013571/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out Tue Jun 23 04:35:01 2009
@@ -7,7 +7,8 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
+ Stage-4 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-4
STAGE PLANS:
Stage: Stage-1
@@ -39,15 +40,49 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: ppd_constant_expr
+ Stage: Stage-4
+ Conditional Operator
+ list of dependent Tasks:
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1953683192/10000
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/734263802/10002
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: c1
+ type: string
+ expr: c2
+ type: int
+ expr: c3
+ type: double
+ 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
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: ppd_constant_expr
+
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: ppd_constant_expr
+ 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: ppd_constant_expr
query: FROM src1
@@ -56,7 +91,7 @@
Output: default/ppd_constant_expr
query: SELECT ppd_constant_expr.* FROM ppd_constant_expr
Input: default/ppd_constant_expr
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1781694301/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/413785403/10000
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out Tue Jun 23 04:35:01 2009
@@ -14,11 +14,14 @@
(TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src a) (TOK_TABREF src b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB mi1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF a))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL a) key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB mi2)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL a) key) 100) (< (. (TOK_TABLE_OR_COL a) key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB mi3 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL a) key) 200) (< (. (TOK_TABLE_OR_COL a) key) 300)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../build/ql/test/data/warehouse/mi4.out')) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value))) (TOK_WHERE (>= (. (TOK_TABLE_OR_COL a) key) 300))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
+ Stage-4 is a root stage
+ Stage-0 depends on stages: Stage-4
+ Stage-1 depends on stages: Stage-4
+ Stage-2 depends on stages: Stage-4
+ Stage-3 depends on stages: Stage-4
STAGE PLANS:
- Stage: Stage-1
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
b
@@ -143,31 +146,42 @@
Stage: Stage-0
Move Operator
- files:
- hdfs directory: true
- destination: ../build/ql/test/data/warehouse/mi4.out
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: mi1
- 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: mi2
- partition:
- ds 2008-04-08
- hr 12
- 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: mi3
+ 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: mi1
+
+ Stage: Stage-1
+ 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: mi2
+
+ Stage: Stage-2
+ Move Operator
+ tables:
+ partition:
+ ds 2008-04-08
+ hr 12
+ 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: mi3
+
+ Stage: Stage-3
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: ../build/ql/test/data/warehouse/mi4.out
query: FROM src a JOIN src b ON (a.key = b.key)
@@ -182,7 +196,7 @@
Output: ../build/ql/test/data/warehouse/mi4.out
query: SELECT mi1.* FROM mi1
Input: default/mi1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1570869193/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1767221832/10000
0 val_0
0 val_0
0 val_0
@@ -333,7 +347,7 @@
98 val_98
query: SELECT mi2.* FROM mi2
Input: default/mi2
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1383174916/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/255224107/10000
100 val_100
100 val_100
100 val_100
@@ -547,7 +561,7 @@
199 val_199
query: SELECT mi3.* FROM mi3
Input: default/mi3/ds=2008-04-08/hr=12
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/851984137/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/928924656/10000
200 2008-04-08 12
200 2008-04-08 12
200 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out Tue Jun 23 04:35:01 2009
@@ -7,7 +7,8 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
+ Stage-4 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-4
STAGE PLANS:
Stage: Stage-1
@@ -39,17 +40,49 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ Stage: Stage-4
+ Conditional Operator
+ list of dependent Tasks:
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/427744862/10000
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/1826844590/10002
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: location
+ type: int
+ expr: type
+ 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
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+
Stage: Stage-0
Move Operator
tables:
- partition:
- table 2008-04-08
- 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: dest1
+ partition:
+ table 2008-04-08
+ 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: dest1
query: EXPLAIN
@@ -96,7 +129,7 @@
Output: default/dest1/table=2008-04-08
query: SELECT `int`.`location`, `int`.`type`, `int`.`table` FROM dest1 `int` WHERE `int`.`table` = '2008-04-08'
Input: default/dest1/table=2008-04-08
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2000628515/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1598405104/10000
238 val_238 2008-04-08
255 val_255 2008-04-08
278 val_278 2008-04-08
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out Tue Jun 23 04:35:01 2009
@@ -9,7 +9,8 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
+ Stage-4 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-4
STAGE PLANS:
Stage: Stage-1
@@ -33,7 +34,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/193426468/98433997.10000.insclause-0
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1442257033/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -47,15 +48,15 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/tmptable
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/tmptable
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -74,10 +75,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -96,32 +97,103 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
+ Stage: Stage-4
+ Conditional Operator
+ list of dependent Tasks:
+ Move Operator
+ files:
+ hdfs directory: true
+ source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1442257033/10002
+ destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/221347159/10000
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/1442257033/10002
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: hr
+ type: string
+ expr: ds
+ type: string
+ Needs Tagging: false
+ Path -> Alias:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/1442257033/10002
+ Path -> Partition:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/1442257033/10002
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name tmptable
+ columns.types string:string:string:string
+ serialization.ddl struct tmptable { string key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/tmptable
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/221347159/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name tmptable
+ columns.types string:string:string:string
+ serialization.ddl struct tmptable { string key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/tmptable
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
+
Stage: Stage-0
Move Operator
tables:
- replace: true
- source: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/193426468/98433997.10000.insclause-0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name tmptable
- columns.types string:string:string:string
- serialization.ddl struct tmptable { string key, string value, string hr, string ds}
- serialization.format 1
- columns key,value,hr,ds
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/tmptable
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: tmptable
- tmp directory: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/193426468/98433997.10001
+ replace: true
+ source: file:/data/users/njain/hive4/hive4/build/ql/tmp/221347159/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name tmptable
+ columns.types string:string:string:string
+ serialization.ddl struct tmptable { string key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/tmptable
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
+ tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/221347159/10001
query: insert overwrite table tmptable
@@ -129,119 +201,119 @@
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
Output: default/tmptable
-query: select * from tmptable x sort by x.key
+query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
Input: default/tmptable
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/20138045/311110484.10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/554052416/10000
103 val_103 2008-04-08 11
103 val_103 2008-04-08 12
-133 val_133 2008-04-08 12
133 val_133 2008-04-08 11
+133 val_133 2008-04-08 12
134 val_134 2008-04-08 11
134 val_134 2008-04-08 12
-138 val_138 2008-04-08 12
138 val_138 2008-04-08 11
+138 val_138 2008-04-08 12
152 val_152 2008-04-08 11
152 val_152 2008-04-08 12
-153 val_153 2008-04-08 12
153 val_153 2008-04-08 11
+153 val_153 2008-04-08 12
169 val_169 2008-04-08 11
169 val_169 2008-04-08 12
-170 val_170 2008-04-08 12
170 val_170 2008-04-08 11
+170 val_170 2008-04-08 12
176 val_176 2008-04-08 11
176 val_176 2008-04-08 11
176 val_176 2008-04-08 12
176 val_176 2008-04-08 12
-18 val_18 2008-04-08 12
18 val_18 2008-04-08 11
+18 val_18 2008-04-08 12
197 val_197 2008-04-08 11
197 val_197 2008-04-08 12
-199 val_199 2008-04-08 12
199 val_199 2008-04-08 11
+199 val_199 2008-04-08 12
202 val_202 2008-04-08 11
202 val_202 2008-04-08 12
-203 val_203 2008-04-08 12
203 val_203 2008-04-08 11
+203 val_203 2008-04-08 12
209 val_209 2008-04-08 11
209 val_209 2008-04-08 12
-217 val_217 2008-04-08 12
217 val_217 2008-04-08 11
+217 val_217 2008-04-08 12
221 val_221 2008-04-08 11
221 val_221 2008-04-08 12
-224 val_224 2008-04-08 12
224 val_224 2008-04-08 11
+224 val_224 2008-04-08 12
233 val_233 2008-04-08 11
233 val_233 2008-04-08 12
-26 val_26 2008-04-08 12
26 val_26 2008-04-08 11
+26 val_26 2008-04-08 12
277 val_277 2008-04-08 11
277 val_277 2008-04-08 12
-288 val_288 2008-04-08 12
288 val_288 2008-04-08 11
+288 val_288 2008-04-08 12
298 val_298 2008-04-08 11
298 val_298 2008-04-08 12
-309 val_309 2008-04-08 12
309 val_309 2008-04-08 11
+309 val_309 2008-04-08 12
310 val_310 2008-04-08 11
310 val_310 2008-04-08 12
-317 val_317 2008-04-08 12
317 val_317 2008-04-08 11
+317 val_317 2008-04-08 12
331 val_331 2008-04-08 11
331 val_331 2008-04-08 12
-336 val_336 2008-04-08 12
336 val_336 2008-04-08 11
+336 val_336 2008-04-08 12
348 val_348 2008-04-08 11
348 val_348 2008-04-08 12
-37 val_37 2008-04-08 12
37 val_37 2008-04-08 11
+37 val_37 2008-04-08 12
378 val_378 2008-04-08 11
378 val_378 2008-04-08 12
-384 val_384 2008-04-08 12
384 val_384 2008-04-08 11
+384 val_384 2008-04-08 12
389 val_389 2008-04-08 11
389 val_389 2008-04-08 12
-400 val_400 2008-04-08 12
400 val_400 2008-04-08 11
+400 val_400 2008-04-08 12
409 val_409 2008-04-08 11
409 val_409 2008-04-08 12
-42 val_42 2008-04-08 12
42 val_42 2008-04-08 11
+42 val_42 2008-04-08 12
429 val_429 2008-04-08 11
429 val_429 2008-04-08 12
-431 val_431 2008-04-08 12
431 val_431 2008-04-08 11
+431 val_431 2008-04-08 12
44 val_44 2008-04-08 11
44 val_44 2008-04-08 12
-453 val_453 2008-04-08 12
453 val_453 2008-04-08 11
+453 val_453 2008-04-08 12
454 val_454 2008-04-08 11
454 val_454 2008-04-08 12
-457 val_457 2008-04-08 12
457 val_457 2008-04-08 11
+457 val_457 2008-04-08 12
458 val_458 2008-04-08 11
458 val_458 2008-04-08 12
-467 val_467 2008-04-08 12
467 val_467 2008-04-08 11
+467 val_467 2008-04-08 12
469 val_469 2008-04-08 11
469 val_469 2008-04-08 11
469 val_469 2008-04-08 11
469 val_469 2008-04-08 12
469 val_469 2008-04-08 12
469 val_469 2008-04-08 12
-489 val_489 2008-04-08 12
489 val_489 2008-04-08 11
+489 val_489 2008-04-08 12
491 val_491 2008-04-08 11
491 val_491 2008-04-08 12
-498 val_498 2008-04-08 12
498 val_498 2008-04-08 11
+498 val_498 2008-04-08 12
51 val_51 2008-04-08 11
51 val_51 2008-04-08 12
-70 val_70 2008-04-08 12
70 val_70 2008-04-08 11
+70 val_70 2008-04-08 12
74 val_74 2008-04-08 11
74 val_74 2008-04-08 12
-77 val_77 2008-04-08 12
77 val_77 2008-04-08 11
+77 val_77 2008-04-08 12
78 val_78 2008-04-08 11
78 val_78 2008-04-08 12
query: drop table tmptable
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample1.q.out?rev=787539&r1=787538&r2=787539&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample1.q.out Tue Jun 23 04:35:01 2009
@@ -9,7 +9,8 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
+ Stage-4 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-4
STAGE PLANS:
Stage: Stage-1
@@ -47,7 +48,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1122328832/10000
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1977299035/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -61,14 +62,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Path -> Partition:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -87,32 +88,103 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
+ Stage: Stage-4
+ Conditional Operator
+ list of dependent Tasks:
+ Move Operator
+ files:
+ hdfs directory: true
+ source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1977299035/10002
+ destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1662393292/10000
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/1977299035/10002
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: int
+ expr: value
+ type: string
+ expr: dt
+ type: string
+ expr: hr
+ type: string
+ Needs Tagging: false
+ Path -> Alias:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/1977299035/10002
+ Path -> Partition:
+ file:/data/users/njain/hive4/hive4/build/ql/tmp/1977299035/10002
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string:string:string
+ serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
+ serialization.format 1
+ columns key,value,dt,hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1662393292/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string:string:string
+ serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
+ serialization.format 1
+ columns key,value,dt,hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+
Stage: Stage-0
Move Operator
tables:
- replace: true
- source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1122328832/10000
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name dest1
- columns.types int:string:string:string
- serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
- serialization.format 1
- columns key,value,dt,hr
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest1
- tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1122328832/10001
+ replace: true
+ source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1662393292/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string:string:string
+ serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
+ serialization.format 1
+ columns key,value,dt,hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+ tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1662393292/10001
query: INSERT OVERWRITE TABLE dest1 SELECT s.*
@@ -122,7 +194,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1563012207/10000
+Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/483810366/10000
238 val_238 2008-04-08 11
86 val_86 2008-04-08 11
311 val_311 2008-04-08 11