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 2008/12/17 11:35:46 UTC
svn commit: r727337 [2/3] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/metadata/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/java/org/apache/hadoop/hive/ql/plan/ ql/src/test/queri...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out Wed Dec 17 02:35:44 2008
@@ -1,8 +1,8 @@
a int
-b float
+b double
a array<int>
-b float
-c map<float,int>
+b double
+c map<double,int>
src src1 src_sequencefile src_thrift srcbucket srcpart test2a test2b
src src1 src_sequencefile src_thrift srcbucket srcpart test2b
ABSTRACT SYNTAX TREE:
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out Wed Dec 17 02:35:44 2008
@@ -52,13 +52,19 @@
output info:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -67,7 +73,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out Wed Dec 17 02:35:44 2008
@@ -1,11 +1,11 @@
a int
-b float
+b double
a array<int>
-b float
-c map<float,int>
+b double
+c map<double,int>
src src1 src_sequencefile src_thrift srcbucket srcpart test3a test3b
ABSTRACT SYNTAX TREE:
- (TOK_ALTERTABLE_ADDCOLS TEST3b (TOK_TABCOLLIST (TOK_TABCOL X TOK_FLOAT)))
+ (TOK_ALTERTABLE_ADDCOLS TEST3b (TOK_TABCOLLIST (TOK_TABCOL X TOK_DOUBLE)))
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -15,14 +15,14 @@
Alter Table Operator:
Alter Table
type: add columns
- new columns: X float
+ new columns: X double
old name: TEST3b
a array<int>
-b float
-c map<float,int>
-x float
+b double
+c map<double,int>
+x double
ABSTRACT SYNTAX TREE:
(TOK_ALTERTABLE_RENAME TEST3b TEST3c)
@@ -39,12 +39,12 @@
a array<int>
-b float
-c map<float,int>
-x float
+b double
+c map<double,int>
+x double
src src1 src_sequencefile src_thrift srcbucket srcpart test3a test3c
ABSTRACT SYNTAX TREE:
- (TOK_ALTERTABLE_REPLACECOLS TEST3c (TOK_TABCOLLIST (TOK_TABCOL R1 TOK_INT) (TOK_TABCOL R2 TOK_FLOAT)))
+ (TOK_ALTERTABLE_REPLACECOLS TEST3c (TOK_TABCOLLIST (TOK_TABCOL R1 TOK_INT) (TOK_TABCOL R2 TOK_DOUBLE)))
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -54,11 +54,11 @@
Alter Table Operator:
Alter Table
type: replace columns
- new columns: R1 int, R2 float
+ new columns: R1 int, R2 double
old name: TEST3c
r1 int
-r2 float
+r2 double
Detailed Table Information:
-Table(tableName:test3c,dbName:default,owner:njain,createTime:1225993819,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:float,comment:null)],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/test3b,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:[],parameters:{last_modified_by=njain,last_modified_time=1225993820})
+Table(tableName:test3c,dbName:default,owner:zshao,createTime:1229498330,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:double,comment:null)],location:file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/test3b,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.dynamic_type.DynamicSerDe,parameters:{serialization.format=org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{last_modified_by=zshao,last_modified_time=1229498331})
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out Wed Dec 17 02:35:44 2008
@@ -20,13 +20,19 @@
type: string
expr: 0
type: string
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToDouble(UDFToBoolean(0))
+ type: double
+ expr: UDFToInteger(1)
+ type: int
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -35,22 +41,22 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
NULL 238
-NULL
+NULL NULL
NULL 311
-NULL
-NULL
-NULL
+NULL NULL
+NULL NULL
+NULL NULL
NULL 255
NULL 278
NULL 98
-NULL
-NULL
-NULL
+NULL NULL
+NULL NULL
+NULL NULL
NULL 401
NULL 150
NULL 273
@@ -61,6 +67,6 @@
NULL 213
NULL 146
NULL 406
-NULL
-NULL
-NULL
+NULL NULL
+NULL NULL
+NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out Wed Dec 17 02:35:44 2008
@@ -22,13 +22,21 @@
type: double
expr: (null + null)
type: tinyint
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToString(0)
+ type: string
+ expr: UDFToInteger(1)
+ type: int
+ expr: UDFToDouble(2)
+ type: double
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -37,7 +45,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out Wed Dec 17 02:35:44 2008
@@ -24,13 +24,19 @@
type: string
expr: 0
type: string
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToString(UDFToBoolean(0))
+ type: string
+ expr: UDFToInteger(1)
+ type: int
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -39,7 +45,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Wed Dec 17 02:35:44 2008
@@ -24,29 +24,39 @@
type: string
expr: ds
type: string
- File Output Operator
- compressed: false
- directory: /tmp/hive-jssarma/547047746/265807002.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, string hr, string ds}
- serialization.format 1
- columns key,value,hr,ds
- 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:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
- name: dest1
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ directory: /tmp/hive-zshao/293656751/393363001.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, string hr, string ds}
+ serialization.format org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
+ columns key,value,hr,ds
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Needs Tagging: false
Path -> Alias:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -64,7 +74,7 @@
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:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: srcpart
@@ -72,21 +82,21 @@
Move Operator
tables:
replace: true
- source: /tmp/hive-jssarma/547047746/265807002.10000.insclause-0
+ source: /tmp/hive-zshao/293656751/393363001.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, string hr, string ds}
- serialization.format 1
+ serialization.format org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
columns key,value,hr,ds
bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Wed Dec 17 02:35:44 2008
@@ -24,24 +24,34 @@
type: string
expr: ds
type: string
- File Output Operator
- compressed: false
- directory: /tmp/hive-jssarma/478508083/234898564.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, string hr, string ds}
- serialization.format 1
- columns key,value,hr,ds
- 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:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
- name: dest1
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ directory: /tmp/hive-zshao/591856793/204210378.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, string hr, string ds}
+ serialization.format org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
+ columns key,value,hr,ds
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Filter Operator
predicate:
expr: (((key < 100) and (ds = '2008-04-09')) and (hr = '12'))
@@ -56,30 +66,40 @@
type: string
expr: ds
type: string
- File Output Operator
- compressed: false
- directory: /tmp/hive-jssarma/478508083/234898564.10001.insclause-1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- properties:
- name dest2
- serialization.ddl struct dest2 { i32 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.MetadataTypedColumnsetSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest2
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
- name: dest2
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ directory: /tmp/hive-zshao/591856793/204210378.10001.insclause-1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name dest2
+ serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
+ serialization.format org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
+ columns key,value,hr,ds
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest2
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest2
Needs Tagging: false
Path -> Alias:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Path -> Partition:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -97,10 +117,10 @@
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:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: srcpart
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
partition values:
ds 2008-04-09
@@ -118,7 +138,7 @@
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:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: srcpart
@@ -126,38 +146,38 @@
Move Operator
tables:
replace: true
- source: /tmp/hive-jssarma/478508083/234898564.10000.insclause-0
+ source: /tmp/hive-zshao/591856793/204210378.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, string hr, string ds}
- serialization.format 1
+ serialization.format org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
columns key,value,hr,ds
bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
replace: true
- source: /tmp/hive-jssarma/478508083/234898564.10001.insclause-1
+ source: /tmp/hive-zshao/591856793/204210378.10001.insclause-1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest2
serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
- serialization.format 1
+ serialization.format org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
columns key,value,hr,ds
bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest2
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest2
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out Wed Dec 17 02:35:44 2008
@@ -16,13 +16,19 @@
type: string
expr: value
type: string
- File Output Operator
- compressed: false
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
- name: dest4_sequencefile
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest4_sequencefile
Stage: Stage-0
Move Operator
@@ -31,7 +37,7 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest4_sequencefile
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out Wed Dec 17 02:35:44 2008
@@ -31,7 +31,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Stage: Stage-0
@@ -41,7 +41,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out Wed Dec 17 02:35:44 2008
@@ -35,7 +35,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Stage: Stage-0
@@ -45,7 +45,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out Wed Dec 17 02:35:44 2008
@@ -1,4 +1,4 @@
-viewtime datetime
+viewtime string
userid int
page_url string
referrer_url string
@@ -7,7 +7,7 @@
ip string 'IP Address of the User'
ds datetime
country string
-viewtime datetime
+viewtime string
userid int
page_url string
referrer_url string
@@ -17,4 +17,4 @@
ds datetime
country string
Detailed Table Information:
-Table(tableName:inputddl4,dbName:default,owner:njain,createTime:1225993821,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)],p
arameters:{}),partitionKeys:[FieldSchema(name:ds,type:datetime,comment:null), FieldSchema(name:country,type:string,comment:null)],parameters:{comment=This is the page view table})
+Table(tableName:inputddl4,dbName:default,owner:zshao,createTime:1229475935,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:viewtime,type:string,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:/data/users/zshao/sync/apache-trunk-HIVE-104/build/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.dynamic_type.DynamicSerDe,parameters:{serialization.format=org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol}),bucketCol
s:[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/hive/trunk/ql/src/test/results/clientpositive/join1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out Wed Dec 17 02:35:44 2008
@@ -54,13 +54,19 @@
type: string
expr: 2
type: string
- File Output Operator
- compressed: false
- 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: dest_j1
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest_j1
Stage: Stage-0
Move Operator
@@ -69,7 +75,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest_j1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out Wed Dec 17 02:35:44 2008
@@ -72,13 +72,19 @@
type: string
expr: 2
type: string
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -87,7 +93,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join17.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join17.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join17.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join17.q.out Wed Dec 17 02:35:44 2008
@@ -41,9 +41,9 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -57,7 +57,7 @@
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:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: src
Reduce Operator Tree:
@@ -77,44 +77,54 @@
type: string
expr: 3
type: string
- File Output Operator
- compressed: false
- directory: /tmp/hive-jssarma/658145143/35270689.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 key1, string value1, i32 key2, string value2}
- serialization.format 1
- columns key1,value1,key2,value2
- 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:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
- name: dest1
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ directory: /tmp/hive-zshao/58811470/801571048.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 key1, string value1, i32 key2, string value2}
+ serialization.format org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
+ columns key1,value1,key2,value2
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
replace: true
- source: /tmp/hive-jssarma/658145143/35270689.10000.insclause-0
+ source: /tmp/hive-zshao/58811470/801571048.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 key1, string value1, i32 key2, string value2}
- serialization.format 1
+ serialization.format org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
columns key1,value1,key2,value2
bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out Wed Dec 17 02:35:44 2008
@@ -46,7 +46,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /tmp/hive-njain/73868771/373350713.10002
+ /tmp/hive-zshao/356667681/95990945.10002
Reduce Output Operator
key expressions:
expr: 0
@@ -66,7 +66,7 @@
keys:
expr: KEY.0
type: string
- mode: unknown
+ mode: final
Select Operator
expressions:
expr: 0
@@ -191,7 +191,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- /tmp/hive-njain/73868771/373350713.10004
+ /tmp/hive-zshao/356667681/95990945.10004
Reduce Output Operator
key expressions:
expr: 0
@@ -211,7 +211,7 @@
keys:
expr: KEY.0
type: string
- mode: unknown
+ mode: final
Select Operator
expressions:
expr: 0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out Wed Dec 17 02:35:44 2008
@@ -104,13 +104,19 @@
type: string
expr: 3
type: string
- File Output Operator
- compressed: false
- 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: dest_j2
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest_j2
Stage: Stage-0
Move Operator
@@ -119,7 +125,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest_j2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out?rev=727337&r1=727336&r2=727337&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out Wed Dec 17 02:35:44 2008
@@ -73,13 +73,19 @@
type: string
expr: 3
type: string
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -88,7 +94,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -86,13 +86,23 @@
type: string
expr: 3
type: string
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -101,7 +111,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -86,13 +86,23 @@
type: string
expr: 3
type: string
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -101,7 +111,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -86,13 +86,23 @@
type: string
expr: 3
type: string
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -101,7 +111,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -121,13 +121,27 @@
type: string
expr: 5
type: string
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ expr: UDFToInteger(4)
+ type: int
+ expr: 5
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -136,7 +150,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -90,13 +90,23 @@
type: string
expr: 3
type: string
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -105,7 +115,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -51,10 +51,10 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/src
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -68,10 +68,10 @@
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:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: src
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/sync/apache-trunk-HIVE-104/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.MetadataTypedColumnsetSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
name: srcpart
Reduce Operator Tree:
@@ -109,44 +109,50 @@
type: string
expr: 4
type: string
- File Output Operator
- compressed: false
- directory: /tmp/hive-jssarma/851341425.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
- 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:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
- name: dest1
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ directory: /tmp/hive-zshao/1146110304.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 org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
replace: true
- source: /tmp/hive-jssarma/851341425.10000.insclause-0
+ source: /tmp/hive-zshao/1146110304.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
+ serialization.format org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol
columns key,value
bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive-trunk-compress/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -49,13 +49,23 @@
type: string
Reduce Operator Tree:
Extract
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: UDFToInteger(1)
+ type: int
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -64,7 +74,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -44,13 +44,23 @@
type: string
Reduce Operator Tree:
Extract
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: UDFToInteger(1)
+ type: int
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -59,14 +69,94 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0
+2 0 2 val_2
+4 0 4 val_4
+5 0 5 val_5
+5 0 5 val_5
+5 0 5 val_5
+8 0 8 val_8
+9 0 9 val_9
10 1 0 val_10
+11 1 1 val_11
+12 1 2 val_12
+12 1 2 val_12
+15 1 5 val_15
+15 1 5 val_15
+17 1 7 val_17
+18 1 8 val_18
+18 1 8 val_18
+19 1 9 val_19
+20 2 0 val_20
+24 2 4 val_24
+24 2 4 val_24
+26 2 6 val_26
+26 2 6 val_26
+27 2 7 val_27
+28 2 8 val_28
+30 3 0 val_30
+33 3 3 val_33
+34 3 4 val_34
+35 3 5 val_35
+35 3 5 val_35
+35 3 5 val_35
+37 3 7 val_37
+37 3 7 val_37
+41 4 1 val_41
+42 4 2 val_42
+42 4 2 val_42
+43 4 3 val_43
+44 4 4 val_44
+47 4 7 val_47
+51 5 1 val_51
+51 5 1 val_51
+53 5 3 val_53
+54 5 4 val_54
+57 5 7 val_57
+58 5 8 val_58
+58 5 8 val_58
+64 6 4 val_64
+65 6 5 val_65
+66 6 6 val_66
+67 6 7 val_67
+67 6 7 val_67
+69 6 9 val_69
+70 7 0 val_70
+70 7 0 val_70
+70 7 0 val_70
+72 7 2 val_72
+72 7 2 val_72
+74 7 4 val_74
+76 7 6 val_76
+76 7 6 val_76
+77 7 7 val_77
+78 7 8 val_78
+80 8 0 val_80
+82 8 2 val_82
+83 8 3 val_83
+83 8 3 val_83
+84 8 4 val_84
+84 8 4 val_84
+85 8 5 val_85
+86 8 6 val_86
+87 8 7 val_87
+90 9 0 val_90
+90 9 0 val_90
+90 9 0 val_90
+92 9 2 val_92
+95 9 5 val_95
+95 9 5 val_95
+96 9 6 val_96
+97 9 7 val_97
+97 9 7 val_97
+98 9 8 val_98
+98 9 8 val_98
100 10 0 val_100
100 10 0 val_100
103 10 3 val_103
@@ -74,7 +164,6 @@
104 10 4 val_104
104 10 4 val_104
105 10 5 val_105
-11 1 1 val_11
111 11 1 val_111
113 11 3 val_113
113 11 3 val_113
@@ -85,8 +174,6 @@
119 11 9 val_119
119 11 9 val_119
119 11 9 val_119
-12 1 2 val_12
-12 1 2 val_12
120 12 0 val_120
120 12 0 val_120
125 12 5 val_125
@@ -114,8 +201,6 @@
146 14 6 val_146
149 14 9 val_149
149 14 9 val_149
-15 1 5 val_15
-15 1 5 val_15
150 15 0 val_150
152 15 2 val_152
152 15 2 val_152
@@ -140,7 +225,6 @@
169 16 9 val_169
169 16 9 val_169
169 16 9 val_169
-17 1 7 val_17
170 17 0 val_170
172 17 2 val_172
172 17 2 val_172
@@ -154,8 +238,6 @@
178 17 8 val_178
179 17 9 val_179
179 17 9 val_179
-18 1 8 val_18
-18 1 8 val_18
180 18 0 val_180
181 18 1 val_181
183 18 3 val_183
@@ -164,7 +246,6 @@
187 18 7 val_187
187 18 7 val_187
189 18 9 val_189
-19 1 9 val_19
190 19 0 val_190
191 19 1 val_191
191 19 1 val_191
@@ -181,8 +262,6 @@
199 19 9 val_199
199 19 9 val_199
199 19 9 val_199
-2 0 2 val_2
-20 2 0 val_20
200 20 0 val_200
200 20 0 val_200
201 20 1 val_201
@@ -233,8 +312,6 @@
238 23 8 val_238
239 23 9 val_239
239 23 9 val_239
-24 2 4 val_24
-24 2 4 val_24
241 24 1 val_241
242 24 2 val_242
242 24 2 val_242
@@ -249,15 +326,12 @@
256 25 6 val_256
257 25 7 val_257
258 25 8 val_258
-26 2 6 val_26
-26 2 6 val_26
260 26 0 val_260
262 26 2 val_262
263 26 3 val_263
265 26 5 val_265
265 26 5 val_265
266 26 6 val_266
-27 2 7 val_27
272 27 2 val_272
272 27 2 val_272
273 27 3 val_273
@@ -271,7 +345,6 @@
277 27 7 val_277
278 27 8 val_278
278 27 8 val_278
-28 2 8 val_28
280 28 0 val_280
280 28 0 val_280
281 28 1 val_281
@@ -292,7 +365,6 @@
298 29 8 val_298
298 29 8 val_298
298 29 8 val_298
-30 3 0 val_30
302 30 2 val_302
305 30 5 val_305
306 30 6 val_306
@@ -324,7 +396,6 @@
327 32 7 val_327
327 32 7 val_327
327 32 7 val_327
-33 3 3 val_33
331 33 1 val_331
331 33 1 val_331
332 33 2 val_332
@@ -334,7 +405,6 @@
336 33 6 val_336
338 33 8 val_338
339 33 9 val_339
-34 3 4 val_34
341 34 1 val_341
342 34 2 val_342
342 34 2 val_342
@@ -346,9 +416,6 @@
348 34 8 val_348
348 34 8 val_348
348 34 8 val_348
-35 3 5 val_35
-35 3 5 val_35
-35 3 5 val_35
351 35 1 val_351
353 35 3 val_353
353 35 3 val_353
@@ -364,8 +431,6 @@
369 36 9 val_369
369 36 9 val_369
369 36 9 val_369
-37 3 7 val_37
-37 3 7 val_37
373 37 3 val_373
374 37 4 val_374
375 37 5 val_375
@@ -391,7 +456,6 @@
397 39 7 val_397
399 39 9 val_399
399 39 9 val_399
-4 0 4 val_4
400 40 0 val_400
401 40 1 val_401
401 40 1 val_401
@@ -412,7 +476,6 @@
409 40 9 val_409
409 40 9 val_409
409 40 9 val_409
-41 4 1 val_41
411 41 1 val_411
413 41 3 val_413
413 41 3 val_413
@@ -423,15 +486,12 @@
417 41 7 val_417
418 41 8 val_418
419 41 9 val_419
-42 4 2 val_42
-42 4 2 val_42
421 42 1 val_421
424 42 4 val_424
424 42 4 val_424
427 42 7 val_427
429 42 9 val_429
429 42 9 val_429
-43 4 3 val_43
430 43 0 val_430
430 43 0 val_430
430 43 0 val_430
@@ -447,7 +507,6 @@
438 43 8 val_438
439 43 9 val_439
439 43 9 val_439
-44 4 4 val_44
443 44 3 val_443
444 44 4 val_444
446 44 6 val_446
@@ -482,7 +541,6 @@
469 46 9 val_469
469 46 9 val_469
469 46 9 val_469
-47 4 7 val_47
470 47 0 val_470
472 47 2 val_472
475 47 5 val_475
@@ -515,51 +573,3 @@
498 49 8 val_498
498 49 8 val_498
498 49 8 val_498
-5 0 5 val_5
-5 0 5 val_5
-5 0 5 val_5
-51 5 1 val_51
-51 5 1 val_51
-53 5 3 val_53
-54 5 4 val_54
-57 5 7 val_57
-58 5 8 val_58
-58 5 8 val_58
-64 6 4 val_64
-65 6 5 val_65
-66 6 6 val_66
-67 6 7 val_67
-67 6 7 val_67
-69 6 9 val_69
-70 7 0 val_70
-70 7 0 val_70
-70 7 0 val_70
-72 7 2 val_72
-72 7 2 val_72
-74 7 4 val_74
-76 7 6 val_76
-76 7 6 val_76
-77 7 7 val_77
-78 7 8 val_78
-8 0 8 val_8
-80 8 0 val_80
-82 8 2 val_82
-83 8 3 val_83
-83 8 3 val_83
-84 8 4 val_84
-84 8 4 val_84
-85 8 5 val_85
-86 8 6 val_86
-87 8 7 val_87
-9 0 9 val_9
-90 9 0 val_90
-90 9 0 val_90
-90 9 0 val_90
-92 9 2 val_92
-95 9 5 val_95
-95 9 5 val_95
-96 9 6 val_96
-97 9 7 val_97
-97 9 7 val_97
-98 9 8 val_98
-98 9 8 val_98
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -44,13 +44,23 @@
type: string
Reduce Operator Tree:
Extract
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: UDFToInteger(1)
+ type: int
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -59,7 +69,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -49,13 +49,23 @@
type: string
Reduce Operator Tree:
Extract
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: UDFToInteger(1)
+ type: int
+ expr: UDFToInteger(2)
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -64,7 +74,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1
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=727337&r1=727336&r2=727337&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 Wed Dec 17 02:35:44 2008
@@ -44,13 +44,23 @@
type: string
Reduce Operator Tree:
Extract
- File Output Operator
- compressed: false
- 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
+ Select Operator
+ expressions:
+ expr: UDFToInteger(0)
+ type: int
+ expr: 1
+ type: int
+ expr: 2
+ type: int
+ expr: 3
+ type: string
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
Stage: Stage-0
Move Operator
@@ -59,7 +69,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
name: dest1