You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by dh...@apache.org on 2008/10/21 20:11:18 UTC
svn commit: r706704 [8/23] - in /hadoop/core/trunk: ./ src/contrib/hive/
src/contrib/hive/bin/
src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/
src/contrib/hive/common/src/java/org/apache/hadoop/hive/conf/
src/contrib/hive/conf/ src/contrib/hi...
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out Tue Oct 21 11:11:05 2008
@@ -1,5 +1,5 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring)) (TOK_SELEXPR ([ (TOK_COLREF src_thrift mstringstring) 'key_2')))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -16,32 +16,33 @@
type: int
expr: lintstring[0].mystring
type: string
+ expr: mstringstring['key_2']
+ type: string
File Output Operator
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
-
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
-0 0
-2 1
-4 8
-6 27
-8 64
-10 125
-12 216
-14 343
-16 512
-18 729
+0 0 NULL
+2 1 NULL
+4 8 value_2
+6 27 NULL
+8 64 NULL
+10 125 NULL
+12 216 NULL
+14 343 NULL
+16 512 NULL
+18 729 NULL
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath2.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath2.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath2.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,52 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION size (TOK_COLREF src_thrift lint))) (TOK_SELEXPR (TOK_FUNCTION size (TOK_COLREF src_thrift lintstring))) (TOK_SELEXPR (TOK_FUNCTION size (TOK_COLREF src_thrift mstringstring)))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_COLREF src_thrift lint)) (NOT (TOK_FUNCTION TOK_ISNULL (TOK_COLREF src_thrift mstringstring)))))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src_thrift
+ 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
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+
+3 1 1
+3 1 1
+3 1 1
+3 1 1
+3 1 1
+3 1 1
+3 1 1
+3 1 1
+3 1 1
+3 1 1
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath3.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath3.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath3.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,38 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift mstringstring) 'key_9')) (TOK_SELEXPR (. (TOK_COLREF src_thrift lintstring) myint)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src_thrift
+ Select Operator
+ expressions:
+ expr: mstringstring['key_9']
+ type: string
+ expr: lintstring.myint
+ type: array<int>
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+NULL [0]
+NULL [1]
+NULL [4]
+NULL [9]
+NULL [16]
+NULL [25]
+NULL [36]
+NULL [49]
+NULL [64]
+value_9 [81]
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out Tue Oct 21 11:11:05 2008
@@ -8,10 +8,10 @@
Stage: Stage-0
Create Table Operator:
Create Table
- isExternal:
- name: INPUTDDL1
+ columns: key int, value string
# buckets: -1
+ name: INPUTDDL1
+ isExternal:
isSequenceFile:
- columns: key int, value string
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out Tue Oct 21 11:11:05 2008
@@ -8,12 +8,12 @@
Stage: Stage-0
Create Table Operator:
Create Table
- isExternal:
- name: INPUTDDL2
- # buckets: -1
- isSequenceFile:
columns: key int, value string
+ # buckets: -1
partition columns: ds datetime, country string
+ name: INPUTDDL2
+ isExternal:
+ isSequenceFile:
key int
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out Tue Oct 21 11:11:05 2008
@@ -8,12 +8,12 @@
Stage: Stage-0
Create Table Operator:
Create Table
- isExternal:
- name: INPUTDDL3
- # buckets: -1
+ columns: key int, value string
field delimiter:
+ # buckets: -1
+ name: INPUTDDL3
+ isExternal:
isSequenceFile:
- columns: key int, value string
key int
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl4.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl4.q.out Tue Oct 21 11:11:05 2008
@@ -7,3 +7,14 @@
ip string 'IP Address of the User'
ds datetime
country string
+viewtime datetime
+userid int
+page_url string
+referrer_url string
+friends array<bigint>
+properties map<string,string>
+ip string 'IP Address of the User'
+ds datetime
+country string
+Detailed Table Information:
+Table(tableName:inputddl4,dbName:default,owner:njain,createTime:1224285030,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:viewtime,type:datetime,comment:null), FieldSchema(name:userid,type:int,comment:null), FieldSchema(name:page_url,type:string,comment:null), FieldSchema(name:referrer_url,type:string,comment:null), FieldSchema(name:friends,type:array<bigint>,comment:null), FieldSchema(name:properties,type:map<string,string>,comment:null), FieldSchema(name:ip,type:string,comment:'IP Address of the User')],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/inputddl4,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:32,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[userid],sortCols:[Order(col:viewtime,order:1)]
,parameters:{}),partitionKeys:[FieldSchema(name:ds,type:datetime,comment:null), FieldSchema(name:country,type:string,comment:null)],parameters:{comment='This is the page view table'})
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl5.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl5.q.out Tue Oct 21 11:11:05 2008
@@ -1,5 +1,3 @@
name string
éµé®
-
1
-
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl6.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl6.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl6.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,29 @@
+key string
+value string
+ds datetime
+Detailed Table Information:
+Table(tableName:inputddl6,dbName:default,owner:njain,createTime:1224285279,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:key,type:string,comment:null), FieldSchema(name:value,type:string,comment:null)],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/inputddl6,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[FieldSchema(name:ds,type:datetime,comment:null)],parameters:{SORTBUCKETCOLSPREFIX=TRUE})
+key string
+value string
+ds datetime
+
+Detailed Partition Information:
+Partition(values:[2008-04-08],dbName:default,tableName:inputddl6,createTime:0,lastAccessTime:0,sd:StorageDescriptor(cols:[FieldSchema(name:key,type:string,comment:null), FieldSchema(name:value,type:string,comment:null)],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/inputddl6/ds=2008-04-08,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),parameters:{})
+ds=2008-04-08
+ds=2008-04-09
+ds=2008-04-09
+ABSTRACT SYNTAX TREE:
+ (TOK_DESCTABLE (TOK_TAB INPUTDDL6 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-09'))) EXTENDED)
+
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Describe Table Operator:
+ Describe Table
+ partition:
+ ds 2008-04-09
+ table: INPUTDDL6
+
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out Tue Oct 21 11:11:05 2008
@@ -8,60 +8,60 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- condition map:
- Inner Join 0 to 1
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 3
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
src2
Reduce Output Operator
- tag: 1
key expressions:
expr: key
type: string
+ # partition fields: 1
+ tag: 1
value expressions:
expr: key
type: string
expr: value
type: string
- # partition fields: 1
src1
Reduce Output Operator
- tag: 0
key expressions:
expr: key
type: string
+ # partition fields: 1
+ tag: 0
value expressions:
expr: key
type: string
expr: value
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
0 val_0
@@ -1092,4 +1092,3 @@
98 val_98
98 val_98
98 val_98
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out Tue Oct 21 11:11:05 2008
@@ -10,83 +10,65 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- condition map:
- Inner Join 0 to 1
- File Output Operator
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
src2
Reduce Output Operator
- tag: 1
key expressions:
expr: key
type: string
+ # partition fields: 1
+ tag: 1
value expressions:
expr: key
type: string
expr: value
type: string
- # partition fields: 1
src1
Reduce Output Operator
- tag: 0
key expressions:
expr: key
type: string
+ # partition fields: 1
+ tag: 0
value expressions:
expr: key
type: string
expr: value
type: string
- # partition fields: 1
-
- Stage: Stage-2
- Map Reduce
Reduce Operator Tree:
Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
- 1 {VALUE.0} {VALUE.1}
condition map:
Inner Join 0 to 1
- Select Operator
- expressions:
- expr: 2
- type: string
- expr: 5
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-2
+ Map Reduce
Alias -> Map Operator Tree:
src3
Reduce Output Operator
- tag: 1
key expressions:
expr: UDFToDouble(key)
type: double
+ # partition fields: 1
+ tag: 1
value expressions:
expr: key
type: string
expr: value
type: string
- # partition fields: 1
$INTNAME
Reduce Output Operator
- tag: 0
key expressions:
expr: (UDFToDouble(0) + UDFToDouble(2))
type: double
+ # partition fields: 1
+ tag: 0
value expressions:
expr: 2
type: string
@@ -96,17 +78,35 @@
type: string
expr: 1
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
+ 1 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 2
+ type: string
+ expr: 5
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
0 val_0
@@ -581,4 +581,3 @@
42 val_84
42 val_84
43 val_86
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out Tue Oct 21 11:11:05 2008
@@ -8,74 +8,74 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- 2 {VALUE.0} {VALUE.1}
- condition map:
- Inner Join 0 to 1
- Inner Join 0 to 1
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 5
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
src2
Reduce Output Operator
- tag: 1
key expressions:
expr: key
type: string
+ # partition fields: 1
+ tag: 1
value expressions:
expr: key
type: string
expr: value
type: string
- # partition fields: 1
src3
Reduce Output Operator
- tag: 2
key expressions:
expr: key
type: string
+ # partition fields: 1
+ tag: 2
value expressions:
expr: key
type: string
expr: value
type: string
- # partition fields: 1
src1
Reduce Output Operator
- tag: 0
key expressions:
expr: key
type: string
+ # partition fields: 1
+ tag: 0
value expressions:
expr: key
type: string
expr: value
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ 2 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 5
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
0 val_0
@@ -2732,4 +2732,3 @@
98 val_98
98 val_98
98 val_98
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out Tue Oct 21 11:11:05 2008
@@ -8,39 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- condition map:
- Left Outer Join0 to 1
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
c:b:src2
Filter Operator
@@ -54,16 +21,16 @@
expr: value
type: string
Reduce Output Operator
- tag: 1
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 1
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
c:a:src1
Filter Operator
predicate:
@@ -76,26 +43,59 @@
expr: value
type: string
Reduce Output Operator
- tag: 0
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 0
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
11 val_11 NULL NULL
@@ -109,4 +109,3 @@
18 val_18 18 val_18
18 val_18 18 val_18
19 val_19 19 val_19
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out Tue Oct 21 11:11:05 2008
@@ -8,39 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- condition map:
- Right Outer Join0 to 1
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
c:b:src2
Filter Operator
@@ -54,16 +21,16 @@
expr: value
type: string
Reduce Output Operator
- tag: 1
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 1
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
c:a:src1
Filter Operator
predicate:
@@ -76,26 +43,59 @@
expr: value
type: string
Reduce Output Operator
- tag: 0
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 0
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Right Outer Join0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
17 val_17 17 val_17
@@ -107,4 +107,3 @@
NULL NULL 20 val_20
NULL NULL 24 val_24
NULL NULL 24 val_24
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out Tue Oct 21 11:11:05 2008
@@ -8,39 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- condition map:
- Outer Join 0 to 1
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
c:b:src2
Filter Operator
@@ -54,16 +21,16 @@
expr: value
type: string
Reduce Output Operator
- tag: 1
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 1
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
c:a:src1
Filter Operator
predicate:
@@ -76,26 +43,59 @@
expr: value
type: string
Reduce Output Operator
- tag: 0
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 0
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Outer Join 0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
11 val_11 NULL NULL
@@ -112,4 +112,3 @@
NULL NULL 20 val_20
NULL NULL 24 val_24
NULL NULL 24 val_24
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out Tue Oct 21 11:11:05 2008
@@ -8,49 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- 2 {VALUE.0} {VALUE.1}
- condition map:
- Outer Join 0 to 1
- Left Outer Join0 to 1
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- expr: 4
- type: string
- expr: 5
- type: string
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- expr: 4
- type: string
- expr: 5
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
c:b:src2
Filter Operator
@@ -64,16 +21,16 @@
expr: value
type: string
Reduce Output Operator
- tag: 1
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 1
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
c:a:src1
Filter Operator
predicate:
@@ -86,16 +43,16 @@
expr: value
type: string
Reduce Output Operator
- tag: 0
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 0
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
c:c:src3
Filter Operator
predicate:
@@ -108,26 +65,69 @@
expr: value
type: string
Reduce Output Operator
- tag: 2
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 2
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Outer Join 0 to 1
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ 2 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
11 val_11 NULL NULL NULL NULL
@@ -146,4 +146,3 @@
NULL NULL 24 val_24 NULL NULL
NULL NULL 24 val_24 NULL NULL
NULL NULL 24 val_24 NULL NULL
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out Tue Oct 21 11:11:05 2008
@@ -8,43 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- condition map:
- Left Outer Join0 to 1
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- Filter Operator
- predicate:
- expr: (2 is null and 0 is not null)
- type: Boolean
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
c:b:src2
Filter Operator
@@ -58,16 +21,16 @@
expr: value
type: string
Reduce Output Operator
- tag: 1
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 1
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
c:a:src1
Filter Operator
predicate:
@@ -80,26 +43,63 @@
expr: value
type: string
Reduce Output Operator
- tag: 0
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 0
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Filter Operator
+ predicate:
+ expr: (2 is null and 0 is not null)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
11 val_11 NULL NULL
@@ -107,4 +107,3 @@
12 val_12 NULL NULL
15 val_15 NULL NULL
15 val_15 NULL NULL
-
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join9.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join9.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join9.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,1169 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF srcpart src1) (TOK_TABREF src src2) (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key)) (TOK_SELEXPR (TOK_COLREF src2 value))) (TOK_WHERE (and (= (TOK_COLREF src1 ds) '2008-04-08') (= (TOK_COLREF src1 hr) '12')))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src2
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ # partition fields: 1
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ src1
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ # partition fields: 1
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/src
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/src
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name src
+ serialization.ddl struct src { string key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/src
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: src
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 12
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcpart
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
+ 1 {VALUE.0} {VALUE.1}
+ Filter Operator
+ predicate:
+ expr: ((2 = '2008-04-08') and (3 = '12'))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 5
+ type: string
+ File Output Operator
+ directory: /tmp/hive-njain/465936460/211979279.10000.insclause-0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace:
+ source: /tmp/hive-njain/465936460/211979279.10000.insclause-0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ SORTBUCKETCOLSPREFIX TRUE
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+0 val_0
+10 val_10
+100 val_100
+100 val_100
+100 val_100
+100 val_100
+103 val_103
+103 val_103
+103 val_103
+103 val_103
+104 val_104
+104 val_104
+104 val_104
+104 val_104
+105 val_105
+11 val_11
+111 val_111
+113 val_113
+113 val_113
+113 val_113
+113 val_113
+114 val_114
+116 val_116
+118 val_118
+118 val_118
+118 val_118
+118 val_118
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+119 val_119
+12 val_12
+12 val_12
+12 val_12
+12 val_12
+120 val_120
+120 val_120
+120 val_120
+120 val_120
+125 val_125
+125 val_125
+125 val_125
+125 val_125
+126 val_126
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+128 val_128
+129 val_129
+129 val_129
+129 val_129
+129 val_129
+131 val_131
+133 val_133
+134 val_134
+134 val_134
+134 val_134
+134 val_134
+136 val_136
+137 val_137
+137 val_137
+137 val_137
+137 val_137
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+143 val_143
+145 val_145
+146 val_146
+146 val_146
+146 val_146
+146 val_146
+149 val_149
+149 val_149
+149 val_149
+149 val_149
+15 val_15
+15 val_15
+15 val_15
+15 val_15
+150 val_150
+152 val_152
+152 val_152
+152 val_152
+152 val_152
+153 val_153
+155 val_155
+156 val_156
+157 val_157
+158 val_158
+160 val_160
+162 val_162
+163 val_163
+164 val_164
+164 val_164
+164 val_164
+164 val_164
+165 val_165
+165 val_165
+165 val_165
+165 val_165
+166 val_166
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+167 val_167
+168 val_168
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+17 val_17
+170 val_170
+172 val_172
+172 val_172
+172 val_172
+172 val_172
+174 val_174
+174 val_174
+174 val_174
+174 val_174
+175 val_175
+175 val_175
+175 val_175
+175 val_175
+176 val_176
+176 val_176
+176 val_176
+176 val_176
+177 val_177
+178 val_178
+179 val_179
+179 val_179
+179 val_179
+179 val_179
+18 val_18
+18 val_18
+18 val_18
+18 val_18
+180 val_180
+181 val_181
+183 val_183
+186 val_186
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+187 val_187
+189 val_189
+19 val_19
+190 val_190
+191 val_191
+191 val_191
+191 val_191
+191 val_191
+192 val_192
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+193 val_193
+194 val_194
+195 val_195
+195 val_195
+195 val_195
+195 val_195
+196 val_196
+197 val_197
+197 val_197
+197 val_197
+197 val_197
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+199 val_199
+2 val_2
+20 val_20
+200 val_200
+200 val_200
+200 val_200
+200 val_200
+201 val_201
+202 val_202
+203 val_203
+203 val_203
+203 val_203
+203 val_203
+205 val_205
+205 val_205
+205 val_205
+205 val_205
+207 val_207
+207 val_207
+207 val_207
+207 val_207
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+208 val_208
+209 val_209
+209 val_209
+209 val_209
+209 val_209
+213 val_213
+213 val_213
+213 val_213
+213 val_213
+214 val_214
+216 val_216
+216 val_216
+216 val_216
+216 val_216
+217 val_217
+217 val_217
+217 val_217
+217 val_217
+218 val_218
+219 val_219
+219 val_219
+219 val_219
+219 val_219
+221 val_221
+221 val_221
+221 val_221
+221 val_221
+222 val_222
+223 val_223
+223 val_223
+223 val_223
+223 val_223
+224 val_224
+224 val_224
+224 val_224
+224 val_224
+226 val_226
+228 val_228
+229 val_229
+229 val_229
+229 val_229
+229 val_229
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+233 val_233
+233 val_233
+233 val_233
+233 val_233
+235 val_235
+237 val_237
+237 val_237
+237 val_237
+237 val_237
+238 val_238
+238 val_238
+238 val_238
+238 val_238
+239 val_239
+239 val_239
+239 val_239
+239 val_239
+24 val_24
+24 val_24
+24 val_24
+24 val_24
+241 val_241
+242 val_242
+242 val_242
+242 val_242
+242 val_242
+244 val_244
+247 val_247
+248 val_248
+249 val_249
+252 val_252
+255 val_255
+255 val_255
+255 val_255
+255 val_255
+256 val_256
+256 val_256
+256 val_256
+256 val_256
+257 val_257
+258 val_258
+26 val_26
+26 val_26
+26 val_26
+26 val_26
+260 val_260
+262 val_262
+263 val_263
+265 val_265
+265 val_265
+265 val_265
+265 val_265
+266 val_266
+27 val_27
+272 val_272
+272 val_272
+272 val_272
+272 val_272
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+273 val_273
+274 val_274
+275 val_275
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+278 val_278
+278 val_278
+278 val_278
+278 val_278
+28 val_28
+280 val_280
+280 val_280
+280 val_280
+280 val_280
+281 val_281
+281 val_281
+281 val_281
+281 val_281
+282 val_282
+282 val_282
+282 val_282
+282 val_282
+283 val_283
+284 val_284
+285 val_285
+286 val_286
+287 val_287
+288 val_288
+288 val_288
+288 val_288
+288 val_288
+289 val_289
+291 val_291
+292 val_292
+296 val_296
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+298 val_298
+30 val_30
+302 val_302
+305 val_305
+306 val_306
+307 val_307
+307 val_307
+307 val_307
+307 val_307
+308 val_308
+309 val_309
+309 val_309
+309 val_309
+309 val_309
+310 val_310
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+311 val_311
+315 val_315
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+316 val_316
+317 val_317
+317 val_317
+317 val_317
+317 val_317
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+318 val_318
+321 val_321
+321 val_321
+321 val_321
+321 val_321
+322 val_322
+322 val_322
+322 val_322
+322 val_322
+323 val_323
+325 val_325
+325 val_325
+325 val_325
+325 val_325
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+327 val_327
+33 val_33
+331 val_331
+331 val_331
+331 val_331
+331 val_331
+332 val_332
+333 val_333
+333 val_333
+333 val_333
+333 val_333
+335 val_335
+336 val_336
+338 val_338
+339 val_339
+34 val_34
+341 val_341
+342 val_342
+342 val_342
+342 val_342
+342 val_342
+344 val_344
+344 val_344
+344 val_344
+344 val_344
+345 val_345
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+35 val_35
+351 val_351
+353 val_353
+353 val_353
+353 val_353
+353 val_353
+356 val_356
+360 val_360
+362 val_362
+364 val_364
+365 val_365
+366 val_366
+367 val_367
+367 val_367
+367 val_367
+367 val_367
+368 val_368
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+369 val_369
+37 val_37
+37 val_37
+37 val_37
+37 val_37
+373 val_373
+374 val_374
+375 val_375
+377 val_377
+378 val_378
+379 val_379
+382 val_382
+382 val_382
+382 val_382
+382 val_382
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+384 val_384
+386 val_386
+389 val_389
+392 val_392
+393 val_393
+394 val_394
+395 val_395
+395 val_395
+395 val_395
+395 val_395
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+396 val_396
+397 val_397
+397 val_397
+397 val_397
+397 val_397
+399 val_399
+399 val_399
+399 val_399
+399 val_399
+4 val_4
+400 val_400
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+402 val_402
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+403 val_403
+404 val_404
+404 val_404
+404 val_404
+404 val_404
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+407 val_407
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+409 val_409
+41 val_41
+411 val_411
+413 val_413
+413 val_413
+413 val_413
+413 val_413
+414 val_414
+414 val_414
+414 val_414
+414 val_414
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+417 val_417
+418 val_418
+419 val_419
+42 val_42
+42 val_42
+42 val_42
+42 val_42
+421 val_421
+424 val_424
+424 val_424
+424 val_424
+424 val_424
+427 val_427
+429 val_429
+429 val_429
+429 val_429
+429 val_429
+43 val_43
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+430 val_430
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+431 val_431
+432 val_432
+435 val_435
+436 val_436
+437 val_437
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+438 val_438
+439 val_439
+439 val_439
+439 val_439
+439 val_439
+44 val_44
+443 val_443
+444 val_444
+446 val_446
+448 val_448
+449 val_449
+452 val_452
+453 val_453
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+454 val_454
+455 val_455
+457 val_457
+458 val_458
+458 val_458
+458 val_458
+458 val_458
+459 val_459
+459 val_459
+459 val_459
+459 val_459
+460 val_460
+462 val_462
+462 val_462
+462 val_462
+462 val_462
+463 val_463
+463 val_463
+463 val_463
+463 val_463
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+466 val_466
+467 val_467
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+47 val_47
+470 val_470
+472 val_472
+475 val_475
+477 val_477
+478 val_478
+478 val_478
+478 val_478
+478 val_478
+479 val_479
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+480 val_480
+481 val_481
+482 val_482
+483 val_483
+484 val_484
+485 val_485
+487 val_487
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+490 val_490
+491 val_491
+492 val_492
+492 val_492
+492 val_492
+492 val_492
+493 val_493
+494 val_494
+495 val_495
+496 val_496
+497 val_497
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+498 val_498
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+5 val_5
+51 val_51
+51 val_51
+51 val_51
+51 val_51
+53 val_53
+54 val_54
+57 val_57
+58 val_58
+58 val_58
+58 val_58
+58 val_58
+64 val_64
+65 val_65
+66 val_66
+67 val_67
+67 val_67
+67 val_67
+67 val_67
+69 val_69
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+70 val_70
+72 val_72
+72 val_72
+72 val_72
+72 val_72
+74 val_74
+76 val_76
+76 val_76
+76 val_76
+76 val_76
+77 val_77
+78 val_78
+8 val_8
+80 val_80
+82 val_82
+83 val_83
+83 val_83
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+84 val_84
+84 val_84
+85 val_85
+86 val_86
+87 val_87
+9 val_9
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+90 val_90
+92 val_92
+95 val_95
+95 val_95
+95 val_95
+95 val_95
+96 val_96
+97 val_97
+97 val_97
+97 val_97
+97 val_97
+98 val_98
+98 val_98
+98 val_98
+98 val_98
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/nullinput.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/nullinput.q.out?rev=706704&view=auto
==============================================================================
(empty)
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out Tue Oct 21 11:11:05 2008
@@ -8,31 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Path -> Alias:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- Path -> Partition:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- Partition
-
- properties:
- name srcpart
- bucket_field_name
- serialization.format 1
- columns key,value
- partition_columns ds/hr
- field_to_dimension
- bucket_count -1
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
- name: srcpart
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- partition values:
- ds 2008-04-08
- hr 11
Alias -> Map Operator Tree:
s
Filter Operator
@@ -50,48 +25,70 @@
expr: hr
type: string
File Output Operator
+ directory: /tmp/hive-njain/1799446246/1449752317.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
serialization.format 1
columns key,value,dt,hr
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-zshao/640225297.10000.insclause-0
Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 11
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcpart
Stage: Stage-0
Move Operator
tables:
+ replace:
+ source: /tmp/hive-njain/1799446246/1449752317.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
serialization.format 1
columns key,value,dt,hr
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-zshao/640225297.10000.insclause-0
238 val_238 2008-04-08 11
@@ -594,4 +591,3 @@
400 val_400 2008-04-08 11
200 val_200 2008-04-08 11
97 val_97 2008-04-08 11
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out Tue Oct 21 11:11:05 2008
@@ -8,27 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Path -> Alias:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
- Path -> Partition:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
s
Select Operator
@@ -38,48 +17,66 @@
expr: value
type: string
File Output Operator
+ directory: /tmp/hive-njain/1178661057/1120939755.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-zshao/83464218.10000.insclause-0
Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ serialization.ddl struct srcbucket { string key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count 2
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcbucket
Stage: Stage-0
Move Operator
tables:
+ replace:
+ source: /tmp/hive-njain/1178661057/1120939755.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-zshao/83464218.10000.insclause-0
238 val_238
@@ -582,4 +579,3 @@
400 val_400
200 val_200
97 val_97
-