You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by cw...@apache.org on 2011/09/13 04:06:05 UTC
svn commit: r1170005 [6/7] - in /hive/trunk: data/files/
ql/src/java/org/apache/hadoop/hive/ql/plan/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
ql/src/test/results/compiler/plan/
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out Tue Sep 13 02:06:03 2011
@@ -38,24 +38,25 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_336_1217998765382678457/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-08-23_02-56-28_075_5381552535418367629/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_336_1217998765382678457/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-08-23_02-56-28_075_5381552535418367629/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns col
columns.types int
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src [src]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src [src]
Path -> Partition:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -66,12 +67,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -82,12 +83,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
@@ -133,9 +134,9 @@ STAGE PLANS:
type: int
Needs Tagging: false
Path -> Alias:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src [a:src]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src [a:src]
Path -> Partition:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -146,12 +147,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -162,12 +163,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
@@ -191,7 +192,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_630_3763149591428470082/-mr-10002
+ directory: file:/tmp/amarsri/hive_2011-08-23_02-56-28_113_65205321316089257/-mr-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -207,7 +208,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_630_3763149591428470082/-mr-10002
+ file:/tmp/amarsri/hive_2011-08-23_02-56-28_113_65205321316089257/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -222,9 +223,9 @@ STAGE PLANS:
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_630_3763149591428470082/-mr-10002 [file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_630_3763149591428470082/-mr-10002]
+ file:/tmp/amarsri/hive_2011-08-23_02-56-28_113_65205321316089257/-mr-10002 [file:/tmp/amarsri/hive_2011-08-23_02-56-28_113_65205321316089257/-mr-10002]
Path -> Partition:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_630_3763149591428470082/-mr-10002
+ file:/tmp/amarsri/hive_2011-08-23_02-56-28_113_65205321316089257/-mr-10002
Partition
base file name: -mr-10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -260,15 +261,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_630_3763149591428470082/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-08-23_02-56-28_113_65205321316089257/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_630_3763149591428470082/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-08-23_02-56-28_113_65205321316089257/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1
columns.types int:bigint
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
@@ -282,33 +284,33 @@ STAGE PLANS:
PREHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_773_2823963726868401744/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-28_160_2910833187295504665/-mr-10000
POSTHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-27_773_2823963726868401744/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-28_160_2910833187295504665/-mr-10000
1
2
3
PREHOOK: query: SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-34_626_1423446193149465057/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-30_684_5031217605959760308/-mr-10000
POSTHOOK: query: SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-34_626_1423446193149465057/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-30_684_5031217605959760308/-mr-10000
1
2
3
PREHOOK: query: SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-39_233_5001190483366194328/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-33_209_1289105752297291373/-mr-10000
POSTHOOK: query: SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-39_233_5001190483366194328/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-33_209_1289105752297291373/-mr-10000
1 1
2 1
3 1
@@ -342,24 +344,25 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_271_8119936562156314036/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-08-23_02-56-38_255_4993331428918111884/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_271_8119936562156314036/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-08-23_02-56-38_255_4993331428918111884/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns key,value
columns.types int:string
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src [src]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src [src]
Path -> Partition:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -370,12 +373,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -386,12 +389,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
@@ -439,9 +442,9 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src [a:src]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src [a:src]
Path -> Partition:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -452,12 +455,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -468,12 +471,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
@@ -501,7 +504,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_364_1797313029396517055/-mr-10002
+ directory: file:/tmp/amarsri/hive_2011-08-23_02-56-38_293_6878248083858234444/-mr-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -517,7 +520,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_364_1797313029396517055/-mr-10002
+ file:/tmp/amarsri/hive_2011-08-23_02-56-38_293_6878248083858234444/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -536,9 +539,9 @@ STAGE PLANS:
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_364_1797313029396517055/-mr-10002 [file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_364_1797313029396517055/-mr-10002]
+ file:/tmp/amarsri/hive_2011-08-23_02-56-38_293_6878248083858234444/-mr-10002 [file:/tmp/amarsri/hive_2011-08-23_02-56-38_293_6878248083858234444/-mr-10002]
Path -> Partition:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_364_1797313029396517055/-mr-10002
+ file:/tmp/amarsri/hive_2011-08-23_02-56-38_293_6878248083858234444/-mr-10002
Partition
base file name: -mr-10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -578,15 +581,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_364_1797313029396517055/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-08-23_02-56-38_293_6878248083858234444/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_364_1797313029396517055/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-08-23_02-56-38_293_6878248083858234444/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1,_col2
columns.types int:string:bigint
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
@@ -600,22 +604,22 @@ STAGE PLANS:
PREHOOK: query: SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src LIMIT 3
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_487_4845458354353476339/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-38_345_2089047557448956718/-mr-10000
POSTHOOK: query: SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src LIMIT 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-09-55_487_4845458354353476339/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-38_345_2089047557448956718/-mr-10000
1 one
2 two
3 three
PREHOOK: query: SELECT a.key, a.val, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src LIMIT 3) a GROUP BY a.key, a.val
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-02_179_3181185311666666566/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-40_934_2953013391147671836/-mr-10000
POSTHOOK: query: SELECT a.key, a.val, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src LIMIT 3) a GROUP BY a.key, a.val
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-02_179_3181185311666666566/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_02-56-40_934_2953013391147671836/-mr-10000
1 one 1
2 two 1
3 three 1
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_reflect.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_reflect.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_reflect.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_reflect.q.out Tue Sep 13 02:06:03 2011
@@ -66,24 +66,25 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_17-39-58_293_2781390290372198499/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_03-07-30_904_4909919395426298063/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-39-58_293_2781390290372198499/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_03-07-30_904_4909919395426298063/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1,_col2,_col3,_col4,_col5,_col6
columns.types string:string:string:string:string:string:string
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [src]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src [src]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -94,12 +95,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1311925582
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -110,12 +111,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1311925582
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
@@ -135,7 +136,7 @@ PREHOOK: query: SELECT reflect("java.lan
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-58_382_6716753430415370105/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_03-07-30_943_7325147834615203404/-mr-10000
POSTHOOK: query: SELECT reflect("java.lang.String", "valueOf", 1),
reflect("java.lang.String", "isEmpty"),
reflect("java.lang.Math", "max", 2, 3),
@@ -146,5 +147,5 @@ POSTHOOK: query: SELECT reflect("java.la
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-58_382_6716753430415370105/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_03-07-30_943_7325147834615203404/-mr-10000
1 true 3 2 3 2.7182818284590455 1.0
Modified: hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out Tue Sep 13 02:06:03 2011
@@ -38,24 +38,25 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_269_8016547042485517896/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-08-23_03-07-02_928_1250194056464136663/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_269_8016547042485517896/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-08-23_03-07-02_928_1250194056464136663/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns col
columns.types int
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src [src]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src [src]
Path -> Partition:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -66,12 +67,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -82,12 +83,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
@@ -133,9 +134,9 @@ STAGE PLANS:
type: int
Needs Tagging: false
Path -> Alias:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src [a:src]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src [a:src]
Path -> Partition:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -146,12 +147,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -162,12 +163,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
@@ -191,7 +192,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_364_9146688986830460617/-mr-10002
+ directory: file:/tmp/amarsri/hive_2011-08-23_03-07-02_968_9198802378494217934/-mr-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -207,7 +208,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_364_9146688986830460617/-mr-10002
+ file:/tmp/amarsri/hive_2011-08-23_03-07-02_968_9198802378494217934/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -222,9 +223,9 @@ STAGE PLANS:
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_364_9146688986830460617/-mr-10002 [file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_364_9146688986830460617/-mr-10002]
+ file:/tmp/amarsri/hive_2011-08-23_03-07-02_968_9198802378494217934/-mr-10002 [file:/tmp/amarsri/hive_2011-08-23_03-07-02_968_9198802378494217934/-mr-10002]
Path -> Partition:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_364_9146688986830460617/-mr-10002
+ file:/tmp/amarsri/hive_2011-08-23_03-07-02_968_9198802378494217934/-mr-10002
Partition
base file name: -mr-10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -260,15 +261,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_364_9146688986830460617/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-08-23_03-07-02_968_9198802378494217934/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_364_9146688986830460617/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-08-23_03-07-02_968_9198802378494217934/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1
columns.types int:bigint
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
@@ -282,33 +284,33 @@ STAGE PLANS:
PREHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_539_2121668458147209230/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-03_015_4726265824126226982/-mr-10000
POSTHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-18_539_2121668458147209230/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-03_015_4726265824126226982/-mr-10000
1
2
3
PREHOOK: query: SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-22_954_5765527817518058297/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-05_538_8498964664323960073/-mr-10000
POSTHOOK: query: SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-22_954_5765527817518058297/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-05_538_8498964664323960073/-mr-10000
1
2
3
PREHOOK: query: SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-29_033_2839370823587806983/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-08_074_964366677410816892/-mr-10000
POSTHOOK: query: SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-29_033_2839370823587806983/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-08_074_964366677410816892/-mr-10000
1 1
2 1
3 1
@@ -388,9 +390,9 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src [a:src]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src [a:src]
Path -> Partition:
- pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -401,12 +403,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -417,12 +419,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/Users/carl/Work/repos/hive-test/build/ql/test/data/warehouse/src
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1312826964
+ transient_lastDdlTime 1314078275
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
@@ -450,7 +452,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-42_257_3751134418621976928/-mr-10002
+ directory: file:/tmp/amarsri/hive_2011-08-23_03-07-13_126_71315112476316699/-mr-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -466,7 +468,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-42_257_3751134418621976928/-mr-10002
+ file:/tmp/amarsri/hive_2011-08-23_03-07-13_126_71315112476316699/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -485,9 +487,9 @@ STAGE PLANS:
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-42_257_3751134418621976928/-mr-10002 [file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-42_257_3751134418621976928/-mr-10002]
+ file:/tmp/amarsri/hive_2011-08-23_03-07-13_126_71315112476316699/-mr-10002 [file:/tmp/amarsri/hive_2011-08-23_03-07-13_126_71315112476316699/-mr-10002]
Path -> Partition:
- file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-42_257_3751134418621976928/-mr-10002
+ file:/tmp/amarsri/hive_2011-08-23_03-07-13_126_71315112476316699/-mr-10002
Partition
base file name: -mr-10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -527,15 +529,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-42_257_3751134418621976928/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-08-23_03-07-13_126_71315112476316699/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-42_257_3751134418621976928/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-08-23_03-07-13_126_71315112476316699/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1,_col2
columns.types int:string:bigint
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
@@ -549,22 +552,22 @@ STAGE PLANS:
PREHOOK: query: SELECT explode(map(1,'one',2,'two',3,'three')) as (myKey,myVal) FROM src LIMIT 3
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-42_365_376806235545694996/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-13_174_7052821188998877991/-mr-10000
POSTHOOK: query: SELECT explode(map(1,'one',2,'two',3,'three')) as (myKey,myVal) FROM src LIMIT 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-42_365_376806235545694996/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-13_174_7052821188998877991/-mr-10000
1 one
2 two
3 three
PREHOOK: query: SELECT a.myKey, a.myVal, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) as (myKey,myVal) FROM src LIMIT 3) a GROUP BY a.myKey, a.myVal
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-51_997_5979122617246221467/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-15_728_1285366516371227133/-mr-10000
POSTHOOK: query: SELECT a.myKey, a.myVal, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) as (myKey,myVal) FROM src LIMIT 3) a GROUP BY a.myKey, a.myVal
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/b7/b7UUwNZdF1KKHtM+5la6f++++TI/-Tmp-/carl/hive_2011-08-08_11-10-51_997_5979122617246221467/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-08-23_03-07-15_728_1285366516371227133/-mr-10000
1 one 1
2 two 1
3 three 1
Modified: hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out Tue Sep 13 02:06:03 2011
@@ -135,10 +135,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -152,13 +152,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297386140
+ transient_lastDdlTime 1311932220
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -169,17 +169,17 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297386140
+ transient_lastDdlTime 1311932221
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -193,13 +193,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297386140
+ transient_lastDdlTime 1311932220
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -210,13 +210,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297386140
+ transient_lastDdlTime 1311932221
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -225,15 +225,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_17-53-20_471_4566273913089562107/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_03-17-34_171_8790156581115607702/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-53-20_471_4566273913089562107/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_03-17-34_171_8790156581115607702/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1,_col2,_col3
columns.types string:string:string:string
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
@@ -254,7 +255,7 @@ SORT BY A.key, A.value, A.ds, A.hr
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-53-20_632_2881169648637784231/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_03-17-34_260_5497182717660314412/-mr-10000
POSTHOOK: query: SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.key < 100
UNION ALL
@@ -265,7 +266,7 @@ SORT BY A.key, A.value, A.ds, A.hr
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-53-20_632_2881169648637784231/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_03-17-34_260_5497182717660314412/-mr-10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
Modified: hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml Tue Sep 13 02:06:03 2011
@@ -66,7 +66,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382265</string>
+ <string>1311936574</string>
</void>
</object>
</void>
@@ -128,7 +128,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382265</string>
+ <string>1311936574</string>
</void>
</object>
</void>
@@ -160,13 +160,13 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc">
<void property="dirName">
- <string>file:/tmp/amarsri/hive_2011-07-11_04-04-26_769_5192710661051968856/-ext-10001</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-49-35_427_6117010919874585016/-ext-10001</string>
</void>
<void property="numFiles">
<int>1</int>
</void>
<void property="statsAggPrefix">
- <string>file:/tmp/amarsri/hive_2011-07-11_04-04-26_769_5192710661051968856/-ext-10001/</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-49-35_427_6117010919874585016/-ext-10001/</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.TableDesc">
@@ -193,6 +193,10 @@
<string>columns.types</string>
<string>int:double:double:double:int:boolean:int</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
@@ -1111,7 +1115,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382265</string>
+ <string>1311936574</string>
</void>
</object>
</void>
@@ -1173,7 +1177,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382265</string>
+ <string>1311936574</string>
</void>
</object>
</void>
Modified: hive/trunk/ql/src/test/results/compiler/plan/groupby2.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/groupby2.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/groupby2.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/groupby2.q.xml Tue Sep 13 02:06:03 2011
@@ -1266,6 +1266,10 @@
<string>columns.types</string>
<string>string:bigint:string</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
Modified: hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml Tue Sep 13 02:06:03 2011
@@ -1462,6 +1462,10 @@
<string>columns.types</string>
<string>double:double:double:string:string</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
Modified: hive/trunk/ql/src/test/results/compiler/plan/groupby4.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/groupby4.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/groupby4.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/groupby4.q.xml Tue Sep 13 02:06:03 2011
@@ -924,6 +924,10 @@
<string>columns.types</string>
<string>string</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
Modified: hive/trunk/ql/src/test/results/compiler/plan/groupby5.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/groupby5.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/groupby5.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/groupby5.q.xml Tue Sep 13 02:06:03 2011
@@ -1017,6 +1017,10 @@
<string>columns.types</string>
<string>string:double</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
Modified: hive/trunk/ql/src/test/results/compiler/plan/groupby6.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/groupby6.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/groupby6.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/groupby6.q.xml Tue Sep 13 02:06:03 2011
@@ -924,6 +924,10 @@
<string>columns.types</string>
<string>string</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
Modified: hive/trunk/ql/src/test/results/compiler/plan/input20.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/input20.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/input20.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/input20.q.xml Tue Sep 13 02:06:03 2011
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-<java version="1.6.0_07" class="java.beans.XMLDecoder">
+<java version="1.6.0_01" class="java.beans.XMLDecoder">
<object class="org.apache.hadoop.hive.ql.exec.MapRedTask">
<void property="id">
<string>Stage-3</string>
@@ -62,11 +62,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060045</string>
+ <string>1311936608</string>
</void>
</object>
</void>
@@ -124,11 +124,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060045</string>
+ <string>1311936608</string>
</void>
</object>
</void>
@@ -844,7 +844,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>tmap:src</string>
@@ -856,7 +856,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.PartitionDesc">
<void property="baseFileName">
<string>src</string>
@@ -913,11 +913,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060045</string>
+ <string>1311936608</string>
</void>
</object>
</void>
@@ -975,11 +975,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060045</string>
+ <string>1311936608</string>
</void>
</object>
</void>
@@ -1009,13 +1009,13 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc">
<void property="dirName">
- <string>file:/tmp/sdong/hive_2011-04-28_23-54-07_277_1593602384616313456/-ext-10001</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-09_317_297939364232626966/-ext-10001</string>
</void>
<void property="numFiles">
<int>1</int>
</void>
<void property="statsAggPrefix">
- <string>file:/tmp/sdong/hive_2011-04-28_23-54-07_277_1593602384616313456/-ext-10001/</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-09_317_297939364232626966/-ext-10001/</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.TableDesc">
@@ -1042,6 +1042,10 @@
<string>columns.types</string>
<string>string:string</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
Modified: hive/trunk/ql/src/test/results/compiler/plan/input8.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/input8.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/input8.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/input8.q.xml Tue Sep 13 02:06:03 2011
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-<java version="1.6.0_07" class="java.beans.XMLDecoder">
+<java version="1.6.0_01" class="java.beans.XMLDecoder">
<object class="org.apache.hadoop.hive.ql.exec.MapRedTask">
<void property="id">
<string>Stage-3</string>
@@ -62,11 +62,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src1</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src1</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060101</string>
+ <string>1311936630</string>
</void>
</object>
</void>
@@ -124,11 +124,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src1</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src1</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060101</string>
+ <string>1311936630</string>
</void>
</object>
</void>
@@ -156,13 +156,13 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc">
<void property="dirName">
- <string>file:/tmp/sdong/hive_2011-04-28_23-55-03_769_3651994780978632706/-ext-10001</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-31_593_5197882376284506188/-ext-10001</string>
</void>
<void property="numFiles">
<int>1</int>
</void>
<void property="statsAggPrefix">
- <string>file:/tmp/sdong/hive_2011-04-28_23-55-03_769_3651994780978632706/-ext-10001/</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-31_593_5197882376284506188/-ext-10001/</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.TableDesc">
@@ -189,6 +189,10 @@
<string>columns.types</string>
<string>int:double:tinyint</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
@@ -628,7 +632,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src1</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src1</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src1</string>
@@ -640,7 +644,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src1</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src1</string>
<object class="org.apache.hadoop.hive.ql.plan.PartitionDesc">
<void property="baseFileName">
<string>src1</string>
@@ -697,11 +701,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src1</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src1</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060101</string>
+ <string>1311936630</string>
</void>
</object>
</void>
@@ -759,11 +763,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src1</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src1</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060101</string>
+ <string>1311936630</string>
</void>
</object>
</void>
Modified: hive/trunk/ql/src/test/results/compiler/plan/input_part1.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/input_part1.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/input_part1.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/input_part1.q.xml Tue Sep 13 02:06:03 2011
@@ -79,7 +79,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382326</string>
+ <string>1311936635</string>
</void>
</object>
</void>
@@ -145,7 +145,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382326</string>
+ <string>1311936635</string>
</void>
</object>
</void>
@@ -177,13 +177,13 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc">
<void property="dirName">
- <string>file:/tmp/amarsri/hive_2011-07-11_04-05-29_362_7332883780675641825/-ext-10001</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-38_444_1027580750179467489/-ext-10001</string>
</void>
<void property="numFiles">
<int>1</int>
</void>
<void property="statsAggPrefix">
- <string>file:/tmp/amarsri/hive_2011-07-11_04-05-29_362_7332883780675641825/-ext-10001/</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-38_444_1027580750179467489/-ext-10001/</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.TableDesc">
@@ -210,6 +210,10 @@
<string>columns.types</string>
<string>string:string:string:string</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
@@ -834,7 +838,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382326</string>
+ <string>1311936635</string>
</void>
</object>
</void>
@@ -900,7 +904,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382326</string>
+ <string>1311936635</string>
</void>
</object>
</void>
Modified: hive/trunk/ql/src/test/results/compiler/plan/input_testxpath.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/input_testxpath.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/input_testxpath.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/input_testxpath.q.xml Tue Sep 13 02:06:03 2011
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-<java version="1.6.0_07" class="java.beans.XMLDecoder">
+<java version="1.6.0_01" class="java.beans.XMLDecoder">
<object class="org.apache.hadoop.hive.ql.exec.MapRedTask">
<void property="id">
<string>Stage-3</string>
@@ -66,11 +66,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src_thrift</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src_thrift</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060141</string>
+ <string>1311936645</string>
</void>
</object>
</void>
@@ -132,11 +132,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src_thrift</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src_thrift</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060141</string>
+ <string>1311936645</string>
</void>
</object>
</void>
@@ -164,13 +164,13 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc">
<void property="dirName">
- <string>file:/tmp/sdong/hive_2011-04-28_23-55-42_511_2568007288175996973/-ext-10001</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-45_470_7470674189494615755/-ext-10001</string>
</void>
<void property="numFiles">
<int>1</int>
</void>
<void property="statsAggPrefix">
- <string>file:/tmp/sdong/hive_2011-04-28_23-55-42_511_2568007288175996973/-ext-10001/</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-45_470_7470674189494615755/-ext-10001/</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.TableDesc">
@@ -197,6 +197,10 @@
<string>columns.types</string>
<string>int:string:string</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
@@ -749,7 +753,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src_thrift</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src_thrift</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src_thrift</string>
@@ -761,7 +765,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src_thrift</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src_thrift</string>
<object class="org.apache.hadoop.hive.ql.plan.PartitionDesc">
<void property="baseFileName">
<string>src_thrift</string>
@@ -822,11 +826,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src_thrift</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src_thrift</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060141</string>
+ <string>1311936645</string>
</void>
</object>
</void>
@@ -888,11 +892,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src_thrift</string>
+ <string>pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/src_thrift</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060141</string>
+ <string>1311936645</string>
</void>
</object>
</void>
Modified: hive/trunk/ql/src/test/results/compiler/plan/input_testxpath2.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/input_testxpath2.q.xml?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/input_testxpath2.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/input_testxpath2.q.xml Tue Sep 13 02:06:03 2011
@@ -70,7 +70,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382339</string>
+ <string>1311936648</string>
</void>
</object>
</void>
@@ -136,7 +136,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382339</string>
+ <string>1311936648</string>
</void>
</object>
</void>
@@ -168,13 +168,13 @@
<void property="conf">
<object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc">
<void property="dirName">
- <string>file:/tmp/amarsri/hive_2011-07-11_04-05-39_617_1990531796790632873/-ext-10001</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-48_916_7177053709345050189/-ext-10001</string>
</void>
<void property="numFiles">
<int>1</int>
</void>
<void property="statsAggPrefix">
- <string>file:/tmp/amarsri/hive_2011-07-11_04-05-39_617_1990531796790632873/-ext-10001/</string>
+ <string>file:/tmp/amarsri/hive_2011-07-29_03-50-48_916_7177053709345050189/-ext-10001/</string>
</void>
<void property="tableInfo">
<object class="org.apache.hadoop.hive.ql.plan.TableDesc">
@@ -201,6 +201,10 @@
<string>columns.types</string>
<string>int:int:int</string>
</void>
+ <void method="put">
+ <string>escape.delim</string>
+ <string>\</string>
+ </void>
</object>
</void>
</object>
@@ -914,7 +918,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382339</string>
+ <string>1311936648</string>
</void>
</object>
</void>
@@ -980,7 +984,7 @@
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1310382339</string>
+ <string>1311936648</string>
</void>
</object>
</void>