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 [1/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/
Author: cws
Date: Tue Sep 13 02:06:03 2011
New Revision: 1170005
URL: http://svn.apache.org/viewvc?rev=1170005&view=rev
Log:
HIVE-2303. Files with control-A,B are not delimited correctly (Amareshwari Sriramadasu via cws)
Added:
hive/trunk/data/files/in7.txt
hive/trunk/ql/src/test/queries/clientpositive/delimiter.q
hive/trunk/ql/src/test/results/clientpositive/delimiter.q.out
Modified:
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java
hive/trunk/ql/src/test/results/clientpositive/combine2.q.out
hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out
hive/trunk/ql/src/test/results/clientpositive/input23.q.out
hive/trunk/ql/src/test/results/clientpositive/input42.q.out
hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out
hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out
hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out
hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
hive/trunk/ql/src/test/results/clientpositive/pcr.q.out
hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out
hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out
hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out
hive/trunk/ql/src/test/results/clientpositive/router_join_ppr.q.out
hive/trunk/ql/src/test/results/clientpositive/sample10.q.out
hive/trunk/ql/src/test/results/clientpositive/sample6.q.out
hive/trunk/ql/src/test/results/clientpositive/sample8.q.out
hive/trunk/ql/src/test/results/clientpositive/sample9.q.out
hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out
hive/trunk/ql/src/test/results/clientpositive/transform_ppr2.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_reflect.q.out
hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out
hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out
hive/trunk/ql/src/test/results/compiler/plan/cast1.q.xml
hive/trunk/ql/src/test/results/compiler/plan/groupby2.q.xml
hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml
hive/trunk/ql/src/test/results/compiler/plan/groupby4.q.xml
hive/trunk/ql/src/test/results/compiler/plan/groupby5.q.xml
hive/trunk/ql/src/test/results/compiler/plan/groupby6.q.xml
hive/trunk/ql/src/test/results/compiler/plan/input20.q.xml
hive/trunk/ql/src/test/results/compiler/plan/input8.q.xml
hive/trunk/ql/src/test/results/compiler/plan/input_part1.q.xml
hive/trunk/ql/src/test/results/compiler/plan/input_testxpath.q.xml
hive/trunk/ql/src/test/results/compiler/plan/input_testxpath2.q.xml
hive/trunk/ql/src/test/results/compiler/plan/join4.q.xml
hive/trunk/ql/src/test/results/compiler/plan/join5.q.xml
hive/trunk/ql/src/test/results/compiler/plan/join6.q.xml
hive/trunk/ql/src/test/results/compiler/plan/join7.q.xml
hive/trunk/ql/src/test/results/compiler/plan/join8.q.xml
hive/trunk/ql/src/test/results/compiler/plan/sample1.q.xml
hive/trunk/ql/src/test/results/compiler/plan/udf1.q.xml
hive/trunk/ql/src/test/results/compiler/plan/udf4.q.xml
hive/trunk/ql/src/test/results/compiler/plan/udf6.q.xml
hive/trunk/ql/src/test/results/compiler/plan/udf_case.q.xml
hive/trunk/ql/src/test/results/compiler/plan/udf_when.q.xml
Added: hive/trunk/data/files/in7.txt
URL: http://svn.apache.org/viewvc/hive/trunk/data/files/in7.txt?rev=1170005&view=auto
==============================================================================
--- hive/trunk/data/files/in7.txt (added)
+++ hive/trunk/data/files/in7.txt Tue Sep 13 02:06:03 2011
@@ -0,0 +1,3 @@
+35 40
+48 32
+100100 40
Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java Tue Sep 13 02:06:03 2011
@@ -209,8 +209,10 @@ public final class PlanUtils {
public static TableDesc getDefaultQueryOutputTableDesc(String cols, String colTypes,
String fileFormat) {
- return getTableDesc(LazySimpleSerDe.class, "" + Utilities.ctrlaCode, cols, colTypes,
+ TableDesc tblDesc = getTableDesc(LazySimpleSerDe.class, "" + Utilities.ctrlaCode, cols, colTypes,
false, false, fileFormat);
+ tblDesc.getProperties().setProperty(Constants.ESCAPE_CHAR, "\\");
+ return tblDesc;
}
/**
Added: hive/trunk/ql/src/test/queries/clientpositive/delimiter.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/delimiter.q?rev=1170005&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/delimiter.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/delimiter.q Tue Sep 13 02:06:03 2011
@@ -0,0 +1,12 @@
+create table impressions (imp string, msg string)
+row format delimited
+fields terminated by '\t'
+lines terminated by '\n'
+stored as textfile;
+LOAD DATA LOCAL INPATH '../data/files/in7.txt' INTO TABLE impressions;
+
+select * from impressions;
+
+select imp,msg from impressions;
+
+drop table impressions;
\ No newline at end of file
Modified: hive/trunk/ql/src/test/results/clientpositive/combine2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/combine2.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/combine2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/combine2.q.out Tue Sep 13 02:06:03 2011
@@ -128,7 +128,7 @@ PREHOOK: Input: default@combine2@value=v
PREHOOK: Input: default@combine2@value=val_8
PREHOOK: Input: default@combine2@value=val_9
PREHOOK: Input: default@combine2@value=|
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_18-51-37_725_5254308986550821577/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-14-22_741_2285484594643850014/-mr-10000
POSTHOOK: query: select key, value from combine2 where value is not null order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@combine2@value=2010-04-21 09%3A45%3A00
@@ -139,7 +139,7 @@ POSTHOOK: Input: default@combine2@value=
POSTHOOK: Input: default@combine2@value=val_8
POSTHOOK: Input: default@combine2@value=val_9
POSTHOOK: Input: default@combine2@value=|
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_18-51-37_725_5254308986550821577/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-14-22_741_2285484594643850014/-mr-10000
POSTHOOK: Lineage: combine2 PARTITION(value=2010-04-21 09:45:00).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine2 PARTITION(value=val_0).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine2 PARTITION(value=val_2).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -204,16 +204,16 @@ STAGE PLANS:
type: bigint
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=2010-04-21 09%3A45%3A00 [combine2]
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_0 [combine2]
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_2 [combine2]
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_4 [combine2]
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_5 [combine2]
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_8 [combine2]
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_9 [combine2]
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=| [combine2]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=2010-04-21 09%3A45%3A00 [combine2]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_0 [combine2]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_2 [combine2]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_4 [combine2]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_5 [combine2]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_8 [combine2]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_9 [combine2]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=| [combine2]
Path -> Partition:
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=2010-04-21 09%3A45%3A00
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=2010-04-21 09%3A45%3A00
Partition
base file name: value=2010-04-21 09%3A45%3A00
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -226,7 +226,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=2010-04-21 09%3A45%3A00
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=2010-04-21 09%3A45%3A00
name default.combine2
numFiles 1
numPartitions 8
@@ -237,7 +237,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 3
- transient_lastDdlTime 1306979496
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -248,7 +248,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2
name default.combine2
numFiles 8
numPartitions 8
@@ -259,11 +259,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 26
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.combine2
name: default.combine2
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_0
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_0
Partition
base file name: value=val_0
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -276,7 +276,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_0
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_0
name default.combine2
numFiles 1
numPartitions 8
@@ -287,7 +287,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 6
- transient_lastDdlTime 1306979496
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -298,7 +298,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2
name default.combine2
numFiles 8
numPartitions 8
@@ -309,11 +309,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 26
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.combine2
name: default.combine2
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_2
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_2
Partition
base file name: value=val_2
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -326,7 +326,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_2
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_2
name default.combine2
numFiles 1
numPartitions 8
@@ -337,7 +337,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -348,7 +348,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2
name default.combine2
numFiles 8
numPartitions 8
@@ -359,11 +359,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 26
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.combine2
name: default.combine2
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_4
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_4
Partition
base file name: value=val_4
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -376,7 +376,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_4
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_4
name default.combine2
numFiles 1
numPartitions 8
@@ -387,7 +387,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -398,7 +398,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2
name default.combine2
numFiles 8
numPartitions 8
@@ -409,11 +409,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 26
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.combine2
name: default.combine2
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_5
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_5
Partition
base file name: value=val_5
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -426,7 +426,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_5
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_5
name default.combine2
numFiles 1
numPartitions 8
@@ -437,7 +437,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 6
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -448,7 +448,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2
name default.combine2
numFiles 8
numPartitions 8
@@ -459,11 +459,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 26
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.combine2
name: default.combine2
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_8
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_8
Partition
base file name: value=val_8
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -476,7 +476,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_8
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_8
name default.combine2
numFiles 1
numPartitions 8
@@ -487,7 +487,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -498,7 +498,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2
name default.combine2
numFiles 8
numPartitions 8
@@ -509,11 +509,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 26
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.combine2
name: default.combine2
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_9
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_9
Partition
base file name: value=val_9
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -526,7 +526,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=val_9
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=val_9
name default.combine2
numFiles 1
numPartitions 8
@@ -537,7 +537,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -548,7 +548,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2
name default.combine2
numFiles 8
numPartitions 8
@@ -559,11 +559,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 26
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.combine2
name: default.combine2
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=|
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=|
Partition
base file name: value=|
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -576,7 +576,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2/value=|
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2/value=|
name default.combine2
numFiles 1
numPartitions 8
@@ -587,7 +587,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 3
- transient_lastDdlTime 1306979496
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -598,7 +598,7 @@ STAGE PLANS:
columns.types string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/combine2
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/combine2
name default.combine2
numFiles 8
numPartitions 8
@@ -609,7 +609,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 26
- transient_lastDdlTime 1306979497
+ transient_lastDdlTime 1311927262
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.combine2
name: default.combine2
@@ -628,15 +628,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/tomasz/hive_2011-06-01_18-51-41_419_8501262958534635510/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_01-14-25_785_3311326813954316235/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_18-51-41_419_8501262958534635510/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_01-14-25_785_3311326813954316235/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0
columns.types bigint
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
@@ -657,7 +658,7 @@ PREHOOK: Input: default@combine2@value=v
PREHOOK: Input: default@combine2@value=val_8
PREHOOK: Input: default@combine2@value=val_9
PREHOOK: Input: default@combine2@value=|
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_18-51-41_554_2942361479619017336/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-14-25_892_527486031009601879/-mr-10000
POSTHOOK: query: select count(1) from combine2 where value is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@combine2@value=2010-04-21 09%3A45%3A00
@@ -668,7 +669,7 @@ POSTHOOK: Input: default@combine2@value=
POSTHOOK: Input: default@combine2@value=val_8
POSTHOOK: Input: default@combine2@value=val_9
POSTHOOK: Input: default@combine2@value=|
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_18-51-41_554_2942361479619017336/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-14-25_892_527486031009601879/-mr-10000
POSTHOOK: Lineage: combine2 PARTITION(value=2010-04-21 09:45:00).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine2 PARTITION(value=val_0).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine2 PARTITION(value=val_2).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -767,14 +768,14 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_18-51-45_373_517425372919749437/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-14-29_008_4318866609287968840/-mr-10000
POSTHOOK: query: select ds, count(1) from srcpart where ds is not null group by ds
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_18-51-45_373_517425372919749437/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-14-29_008_4318866609287968840/-mr-10000
POSTHOOK: Lineage: combine2 PARTITION(value=2010-04-21 09:45:00).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine2 PARTITION(value=val_0).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: combine2 PARTITION(value=val_2).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ]
Added: hive/trunk/ql/src/test/results/clientpositive/delimiter.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/delimiter.q.out?rev=1170005&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delimiter.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/delimiter.q.out Tue Sep 13 02:06:03 2011
@@ -0,0 +1,49 @@
+PREHOOK: query: create table impressions (imp string, msg string)
+row format delimited
+fields terminated by '\t'
+lines terminated by '\n'
+stored as textfile
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table impressions (imp string, msg string)
+row format delimited
+fields terminated by '\t'
+lines terminated by '\n'
+stored as textfile
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@impressions
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in7.txt' INTO TABLE impressions
+PREHOOK: type: LOAD
+PREHOOK: Output: default@impressions
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in7.txt' INTO TABLE impressions
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@impressions
+PREHOOK: query: select * from impressions
+PREHOOK: type: QUERY
+PREHOOK: Input: default@impressions
+PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-07-28_22-22-05_087_4079188620089903829/-mr-10000
+POSTHOOK: query: select * from impressions
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@impressions
+POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-07-28_22-22-05_087_4079188620089903829/-mr-10000
+35 40
+48 32
+100100 40
+PREHOOK: query: select imp,msg from impressions
+PREHOOK: type: QUERY
+PREHOOK: Input: default@impressions
+PREHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-07-28_22-22-05_611_3078194510979662520/-mr-10000
+POSTHOOK: query: select imp,msg from impressions
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@impressions
+POSTHOOK: Output: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-07-28_22-22-05_611_3078194510979662520/-mr-10000
+35 40
+48 32
+100100 40
+PREHOOK: query: drop table impressions
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@impressions
+PREHOOK: Output: default@impressions
+POSTHOOK: query: drop table impressions
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@impressions
+POSTHOOK: Output: default@impressions
Modified: hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out Tue Sep 13 02:06:03 2011
@@ -85,9 +85,9 @@ STAGE PLANS:
type: string
Needs Tagging: true
Path -> Alias:
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08 [f, m]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08 [f, m]
Path -> Partition:
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08
Partition
base file name: ds=2008-04-08
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -100,7 +100,7 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08
name default.filter_join_breaktask
numFiles 1
numPartitions 1
@@ -111,7 +111,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 236
- transient_lastDdlTime 1306980051
+ transient_lastDdlTime 1311927721
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -122,7 +122,7 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/filter_join_breaktask
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/filter_join_breaktask
name default.filter_join_breaktask
numFiles 1
numPartitions 1
@@ -133,7 +133,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 236
- transient_lastDdlTime 1306980051
+ transient_lastDdlTime 1311927721
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.filter_join_breaktask
name: default.filter_join_breaktask
@@ -149,7 +149,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/amarsri/hive_2011-07-11_01-46-22_446_957936931018191228/-mr-10002
+ directory: file:/tmp/amarsri/hive_2011-07-29_01-22-01_246_748904726780254946/-mr-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -196,10 +196,10 @@ STAGE PLANS:
type: string
Needs Tagging: true
Path -> Alias:
- file:/tmp/tomasz/hive_2011-06-01_19-00-51_695_3409169030364207424/-mr-10002 [$INTNAME]
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08 [g]
+ file:/tmp/amarsri/hive_2011-07-29_01-22-01_246_748904726780254946/-mr-10002 [$INTNAME]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08 [g]
Path -> Partition:
- file:/tmp/tomasz/hive_2011-06-01_19-00-51_695_3409169030364207424/-mr-10002
+ file:/tmp/amarsri/hive_2011-07-29_01-22-01_246_748904726780254946/-mr-10002
Partition
base file name: -mr-10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -215,7 +215,7 @@ STAGE PLANS:
columns _col0,_col6,_col7
columns.types int,string,string
escape.delim \
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08
Partition
base file name: ds=2008-04-08
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -228,7 +228,7 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08
name default.filter_join_breaktask
numFiles 1
numPartitions 1
@@ -239,7 +239,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 236
- transient_lastDdlTime 1306980051
+ transient_lastDdlTime 1311927721
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -250,7 +250,7 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/filter_join_breaktask
+ location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/filter_join_breaktask
name default.filter_join_breaktask
numFiles 1
numPartitions 1
@@ -261,7 +261,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 236
- transient_lastDdlTime 1306980051
+ transient_lastDdlTime 1311927721
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.filter_join_breaktask
name: default.filter_join_breaktask
@@ -284,15 +284,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/tomasz/hive_2011-06-01_19-00-51_695_3409169030364207424/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_01-22-01_246_748904726780254946/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/tomasz/hive_2011-06-01_19-00-51_695_3409169030364207424/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_01-22-01_246_748904726780254946/-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:string
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
@@ -308,13 +309,13 @@ FROM filter_join_breaktask f JOIN filter
JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !='')
PREHOOK: type: QUERY
PREHOOK: Input: default@filter_join_breaktask@ds=2008-04-08
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_19-00-51_894_7598558703345729633/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-22-01_372_3915857844458948119/-mr-10000
POSTHOOK: query: SELECT f.key, g.value
FROM filter_join_breaktask f JOIN filter_join_breaktask m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' AND f.key is not null)
JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !='')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@filter_join_breaktask@ds=2008-04-08
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_19-00-51_894_7598558703345729633/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-22-01_372_3915857844458948119/-mr-10000
POSTHOOK: Lineage: filter_join_breaktask PARTITION(ds=2008-04-08).key EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: filter_join_breaktask PARTITION(ds=2008-04-08).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
146 val_146
Modified: hive/trunk/ql/src/test/results/clientpositive/input23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input23.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input23.q.out Tue Sep 13 02:06:03 2011
@@ -54,9 +54,9 @@ STAGE PLANS:
type: string
Needs Tagging: true
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
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
@@ -70,13 +70,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -87,13 +87,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -129,15 +129,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-17_09-04-29_865_6849719999466698028/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_01-40-44_842_8292826286568721646/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/var/folders/uc/ucuNeMAVGQGzy3459D8z2+++Z0Q/-Tmp-/amarsri/hive_2011-03-17_09-04-29_865_6849719999466698028/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_01-40-44_842_8292826286568721646/-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,_col7
columns.types string:string:string:string:string:string:string:string
+ escape.delim \
serialization.format 1
TotalFiles: 1
GatherStats: false
@@ -151,8 +152,8 @@ STAGE PLANS:
PREHOOK: query: select * from srcpart a join srcpart b where a.ds = '2008-04-08' and a.hr = '11' and b.ds = '2008-04-08' and b.hr = '14' limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-28_401_3522044426043645674/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-40-44_922_7457740430101750979/-mr-10000
POSTHOOK: query: select * from srcpart a join srcpart b where a.ds = '2008-04-08' and a.hr = '11' and b.ds = '2008-04-08' and b.hr = '14' limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-28_401_3522044426043645674/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-40-44_922_7457740430101750979/-mr-10000
Modified: hive/trunk/ql/src/test/results/clientpositive/input42.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input42.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input42.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input42.q.out Tue Sep 13 02:06:03 2011
@@ -49,10 +49,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 [a]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
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
@@ -66,13 +66,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -83,17 +83,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 1297378962
+ transient_lastDdlTime 1311925579
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
@@ -107,13 +107,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 1297378962
+ transient_lastDdlTime 1311925580
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -124,13 +124,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -139,15 +139,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_15-57-07_635_1521570938566507437/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_01-42-41_270_4261154033200724464/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_15-57-07_635_1521570938566507437/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_01-42-41_270_4261154033200724464/-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
@@ -162,12 +163,12 @@ PREHOOK: query: select * from srcpart a
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_15-57-07_771_8008897996969692319/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-42-41_332_9190712678024537343/-mr-10000
POSTHOOK: query: select * from srcpart a where a.ds='2008-04-08' order by a.key, 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_15-57-07_771_8008897996969692319/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-42-41_332_9190712678024537343/-mr-10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
@@ -1224,10 +1225,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 [a]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
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
@@ -1241,13 +1242,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1258,17 +1259,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 1297378962
+ transient_lastDdlTime 1311925579
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
@@ -1282,13 +1283,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 1297378962
+ transient_lastDdlTime 1311925580
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1299,13 +1300,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -1314,15 +1315,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_15-57-11_395_7120694435411643442/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_01-42-44_028_7659839805392216215/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_15-57-11_395_7120694435411643442/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_01-42-44_028_7659839805392216215/-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
@@ -1337,12 +1339,12 @@ PREHOOK: query: select * from srcpart a
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_15-57-11_528_2337093511070491628/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-42-44_086_7013432585177983169/-mr-10000
POSTHOOK: query: select * from srcpart a where a.ds='2008-04-08' and key < 200 order by a.key, 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_15-57-11_528_2337093511070491628/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-42-44_086_7013432585177983169/-mr-10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
@@ -1777,10 +1779,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 [a]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
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
@@ -1794,13 +1796,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1811,17 +1813,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 1297378962
+ transient_lastDdlTime 1311925579
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
@@ -1835,13 +1837,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 1297378962
+ transient_lastDdlTime 1311925580
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1852,13 +1854,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -1867,15 +1869,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_15-57-16_627_3731606838809054192/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_01-42-46_792_1531603330643616455/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_15-57-16_627_3731606838809054192/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_01-42-46_792_1531603330643616455/-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
@@ -1890,12 +1893,12 @@ PREHOOK: query: select * from srcpart a
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_15-57-16_775_373089209553050307/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-42-46_851_4742753378737114592/-mr-10000
POSTHOOK: query: select * from srcpart a where a.ds='2008-04-08' and rand(100) < 0.1 order by a.key, 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_15-57-16_775_373089209553050307/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-42-46_851_4742753378737114592/-mr-10000
113 val_113 2008-04-08 11
118 val_118 2008-04-08 11
12 val_12 2008-04-08 12
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out Tue Sep 13 02:06:03 2011
@@ -133,10 +133,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
@@ -150,13 +150,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -167,17 +167,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 1297378962
+ transient_lastDdlTime 1311925579
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
@@ -191,13 +191,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 1297378962
+ transient_lastDdlTime 1311925580
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -208,13 +208,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -223,15 +223,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_16-00-32_374_3794920009693271746/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_01-44-25_271_2784975647188750974/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_16-00-32_374_3794920009693271746/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_01-44-25_271_2784975647188750974/-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
@@ -251,7 +252,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_16-00-32_521_3587854096568220275/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-44-25_355_7230411336825408646/-mr-10000
POSTHOOK: query: SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.ds = '2008-04-08' and X.key < 100
UNION ALL
@@ -261,7 +262,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_16-00-32_521_3587854096568220275/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-44-25_355_7230411336825408646/-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/clientpositive/input_part9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out?rev=1170005&r1=1170004&r2=1170005&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out Tue Sep 13 02:06:03 2011
@@ -54,10 +54,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 [x]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [x]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [x]
+ pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [x]
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
@@ -71,13 +71,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -88,17 +88,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 1297378962
+ transient_lastDdlTime 1311925579
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
@@ -112,13 +112,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 1297378962
+ transient_lastDdlTime 1311925580
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -129,13 +129,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 1297378962
+ transient_lastDdlTime 1311925579
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -144,15 +144,16 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_16-00-37_414_3110997122037603470/-ext-10001
+ directory: file:/tmp/amarsri/hive_2011-07-29_01-44-28_799_1622419837310111927/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_16-00-37_414_3110997122037603470/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/amarsri/hive_2011-07-29_01-44-28_799_1622419837310111927/-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
@@ -167,12 +168,12 @@ PREHOOK: query: SELECT x.* FROM SRCPART
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_16-00-37_541_281073495943344664/-mr-10000
+PREHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-44-28_863_3809932140328249306/-mr-10000
POSTHOOK: query: SELECT x.* FROM SRCPART x WHERE key IS NOT NULL AND ds = '2008-04-08' order by x.key, x.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_16-00-37_541_281073495943344664/-mr-10000
+POSTHOOK: Output: file:/tmp/amarsri/hive_2011-07-29_01-44-28_863_3809932140328249306/-mr-10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11