You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2011/03/23 00:05:53 UTC
svn commit: r1084403 [14/26] - in /hive/trunk:
contrib/src/test/results/clientpositive/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/org/apache/hadoop/hive/ql/
ql/src/test/org/apache/hadoop/hive/ql/hooks/
ql/src/test/queries/clientnegative/...
Modified: hive/trunk/ql/src/test/results/clientpositive/stats11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats11.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats11.q.out Tue Mar 22 23:05:48 2011
@@ -5,11 +5,13 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@srcbucket_mapjoin
PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin
PREHOOK: type: LOAD
+PREHOOK: Output: default@srcbucket_mapjoin
POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin
POSTHOOK: type: LOAD
POSTHOOK: Output: default@srcbucket_mapjoin
PREHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin
PREHOOK: type: LOAD
+PREHOOK: Output: default@srcbucket_mapjoin
POSTHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin
POSTHOOK: type: LOAD
POSTHOOK: Output: default@srcbucket_mapjoin
@@ -20,21 +22,26 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@srcbucket_mapjoin_part
PREHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
PREHOOK: type: LOAD
+PREHOOK: Output: default@srcbucket_mapjoin_part
POSTHOOK: query: load data local inpath '../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+POSTHOOK: Output: default@srcbucket_mapjoin_part
POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
PREHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
PREHOOK: type: LOAD
+PREHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
POSTHOOK: query: load data local inpath '../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
PREHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
PREHOOK: type: LOAD
+PREHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
POSTHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
PREHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
PREHOOK: type: LOAD
+PREHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
POSTHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
@@ -45,11 +52,14 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@srcbucket_mapjoin_part_2
PREHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08')
PREHOOK: type: LOAD
+PREHOOK: Output: default@srcbucket_mapjoin_part_2
POSTHOOK: query: load data local inpath '../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+POSTHOOK: Output: default@srcbucket_mapjoin_part_2
POSTHOOK: Output: default@srcbucket_mapjoin_part_2@ds=2008-04-08
PREHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08')
PREHOOK: type: LOAD
+PREHOOK: Output: default@srcbucket_mapjoin_part_2@ds=2008-04-08
POSTHOOK: query: load data local inpath '../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@srcbucket_mapjoin_part_2@ds=2008-04-08
@@ -117,10 +127,10 @@ STAGE PLANS:
Alias Bucket Base File Name Mapping:
b {srcbucket20.txt=[srcbucket20.txt, srcbucket22.txt], srcbucket21.txt=[srcbucket21.txt, srcbucket23.txt]}
Alias Bucket File Name Mapping:
- b {pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt=[pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket20.txt, pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket22.txt], pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt=[pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket21.txt, pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket23.txt]}
+ b {pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt=[pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket20.txt, pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket22.txt], pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt=[pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket21.txt, pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket23.txt]}
Alias Bucket Output File Name Mapping:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt 0
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt 1
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt 0
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt 1
Stage: Stage-1
Map Reduce
@@ -169,9 +179,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10002
+ directory: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -181,12 +191,12 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297387207
+ transient_lastDdlTime 1300710057
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.bucketmapjoin_tmp_result
TotalFiles: 1
@@ -196,9 +206,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin [a]
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin [a]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin
Partition
base file name: srcbucket_mapjoin
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -210,12 +220,12 @@ 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/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin
name default.srcbucket_mapjoin
serialization.ddl struct srcbucket_mapjoin { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297387202
+ transient_lastDdlTime 1300710056
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -227,12 +237,12 @@ 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/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin
name default.srcbucket_mapjoin
serialization.ddl struct srcbucket_mapjoin { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297387202
+ transient_lastDdlTime 1300710056
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcbucket_mapjoin
name: default.srcbucket_mapjoin
@@ -244,14 +254,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10002
- destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10000
+ source: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10002
+ destination: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10000
+ source: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -261,28 +271,28 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297387207
+ transient_lastDdlTime 1300710057
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.bucketmapjoin_tmp_result
- tmp directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10001
+ tmp directory: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10002
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10000
+ directory: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -293,12 +303,12 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297387207
+ transient_lastDdlTime 1300710057
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.bucketmapjoin_tmp_result
TotalFiles: 1
@@ -306,9 +316,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10002 [pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10002]
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10002 [pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-07_364_154513288032551963/-ext-10002
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-20-57_210_1735801303200210364/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -319,12 +329,12 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297387207
+ transient_lastDdlTime 1300710057
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -335,12 +345,12 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
serialization.ddl struct bucketmapjoin_tmp_result { string key, string value1, string value2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297387207
+ transient_lastDdlTime 1300710057
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.bucketmapjoin_tmp_result
name: default.bucketmapjoin_tmp_result
@@ -368,11 +378,11 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
PREHOOK: query: select count(1) from bucketmapjoin_tmp_result
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_tmp_result
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-20-15_968_1125756249721011170/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-03_626_299969529303494516/-mr-10000
POSTHOOK: query: select count(1) from bucketmapjoin_tmp_result
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_tmp_result
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-20-15_968_1125756249721011170/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-03_626_299969529303494516/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_tmp_result.key SIMPLE [(srcbucket_mapjoin)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value1 SIMPLE [(srcbucket_mapjoin)a.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_tmp_result.value2 SIMPLE [(srcbucket_mapjoin_part)b.FieldSchema(name:value, type:string, comment:null), ]
@@ -421,11 +431,11 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
PREHOOK: query: select count(1) from bucketmapjoin_tmp_result
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_tmp_result
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-20-30_766_2105267363067245062/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-16_986_1006242769236888206/-mr-10000
POSTHOOK: query: select count(1) from bucketmapjoin_tmp_result
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_tmp_result
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-20-30_766_2105267363067245062/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-16_986_1006242769236888206/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value2 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value2, type:string, comment:null), ]
@@ -464,14 +474,14 @@ on a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_hash_result_1
PREHOOK: Input: default@bucketmapjoin_hash_result_2
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-20-38_810_7752212067999903025/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-24_395_5559927002432627417/-mr-10000
POSTHOOK: query: select a.key-b.key, a.value1-b.value1, a.value2-b.value2
from bucketmapjoin_hash_result_1 a left outer join bucketmapjoin_hash_result_2 b
on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_hash_result_1
POSTHOOK: Input: default@bucketmapjoin_hash_result_2
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-20-38_810_7752212067999903025/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-24_395_5559927002432627417/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value2 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value2, type:string, comment:null), ]
@@ -546,12 +556,12 @@ STAGE PLANS:
Alias Bucket Base File Name Mapping:
a {srcbucket20.txt=[srcbucket20.txt], srcbucket21.txt=[srcbucket21.txt], srcbucket22.txt=[srcbucket20.txt], srcbucket23.txt=[srcbucket21.txt]}
Alias Bucket File Name Mapping:
- a {pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket20.txt=[pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt], pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket21.txt=[pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt], pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket22.txt=[pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt], pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket23.txt=[pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt]}
+ a {pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket20.txt=[pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt], pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket21.txt=[pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt], pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket22.txt=[pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket20.txt], pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket23.txt=[pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin/srcbucket21.txt]}
Alias Bucket Output File Name Mapping:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket20.txt 0
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket21.txt 1
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket22.txt 2
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket23.txt 3
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket20.txt 0
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket21.txt 1
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket22.txt 2
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08/srcbucket23.txt 3
Stage: Stage-1
Map Reduce
@@ -600,9 +610,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10002
+ directory: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -612,7 +622,7 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -621,7 +631,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1297387230
+ transient_lastDdlTime 1300710076
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.bucketmapjoin_tmp_result
TotalFiles: 1
@@ -631,9 +641,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08 [b]
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08 [b]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08
Partition
base file name: ds=2008-04-08
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -647,13 +657,13 @@ 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/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part/ds=2008-04-08
name default.srcbucket_mapjoin_part
partition_columns ds
serialization.ddl struct srcbucket_mapjoin_part { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297387202
+ transient_lastDdlTime 1300710056
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -665,13 +675,13 @@ 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/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcbucket_mapjoin_part
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/srcbucket_mapjoin_part
name default.srcbucket_mapjoin_part
partition_columns ds
serialization.ddl struct srcbucket_mapjoin_part { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297387202
+ transient_lastDdlTime 1300710056
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcbucket_mapjoin_part
name: default.srcbucket_mapjoin_part
@@ -683,14 +693,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10002
- destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10000
+ source: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10002
+ destination: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10000
+ source: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -700,7 +710,7 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -709,23 +719,23 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1297387230
+ transient_lastDdlTime 1300710076
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.bucketmapjoin_tmp_result
- tmp directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10001
+ tmp directory: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10002
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10000
+ directory: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -736,7 +746,7 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -745,7 +755,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1297387230
+ transient_lastDdlTime 1300710076
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.bucketmapjoin_tmp_result
TotalFiles: 1
@@ -753,9 +763,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10002 [pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10002]
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10002 [pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-20-42_595_5942527123247023220/-ext-10002
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-21-27_505_5694559335488987924/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -766,7 +776,7 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -775,7 +785,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1297387230
+ transient_lastDdlTime 1300710076
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -786,7 +796,7 @@ STAGE PLANS:
columns.types string: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/bucketmapjoin_tmp_result
+ location pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/bucketmapjoin_tmp_result
name default.bucketmapjoin_tmp_result
numFiles 1
numPartitions 0
@@ -795,7 +805,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 8983
- transient_lastDdlTime 1297387230
+ transient_lastDdlTime 1300710076
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.bucketmapjoin_tmp_result
name: default.bucketmapjoin_tmp_result
@@ -835,11 +845,11 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
PREHOOK: query: select count(1) from bucketmapjoin_tmp_result
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_tmp_result
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-20-51_020_1869017956345120053/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-33_922_5419122136862053042/-mr-10000
POSTHOOK: query: select count(1) from bucketmapjoin_tmp_result
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_tmp_result
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-20-51_020_1869017956345120053/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-33_922_5419122136862053042/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value2 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value2, type:string, comment:null), ]
@@ -924,11 +934,11 @@ POSTHOOK: Lineage: bucketmapjoin_tmp_res
PREHOOK: query: select count(1) from bucketmapjoin_tmp_result
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_tmp_result
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-21-05_911_8128278775729131857/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-47_733_1327316401701654234/-mr-10000
POSTHOOK: query: select count(1) from bucketmapjoin_tmp_result
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_tmp_result
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-21-05_911_8128278775729131857/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-47_733_1327316401701654234/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
@@ -991,14 +1001,14 @@ on a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucketmapjoin_hash_result_1
PREHOOK: Input: default@bucketmapjoin_hash_result_2
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-21-13_975_8790024981585336234/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-55_208_8308369922911968975/-mr-10000
POSTHOOK: query: select a.key-b.key, a.value1-b.value1, a.value2-b.value2
from bucketmapjoin_hash_result_1 a left outer join bucketmapjoin_hash_result_2 b
on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucketmapjoin_hash_result_1
POSTHOOK: Input: default@bucketmapjoin_hash_result_2
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-21-13_975_8790024981585336234/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-21-55_208_8308369922911968975/-mr-10000
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.key EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: bucketmapjoin_hash_result_1.value1 EXPRESSION [(bucketmapjoin_tmp_result)bucketmapjoin_tmp_result.FieldSchema(name:value1, type:string, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/stats3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats3.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats3.q.out Tue Mar 22 23:05:48 2011
@@ -13,6 +13,7 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@hive_test_src
PREHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table hive_test_src
PREHOOK: type: LOAD
+PREHOOK: Output: default@hive_test_src
POSTHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table hive_test_src
POSTHOOK: type: LOAD
POSTHOOK: Output: default@hive_test_src
@@ -33,11 +34,11 @@ POSTHOOK: Lineage: hive_test_dst PARTITI
PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part'
PREHOOK: type: QUERY
PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-05_659_2221029887224696014/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-28_652_6586721606321003478/-mr-10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-05_659_2221029887224696014/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-28_652_6586721606321003478/-mr-10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
1 test_part test_Part
2 test_part test_Part
@@ -48,11 +49,11 @@ POSTHOOK: Lineage: hive_test_dst PARTITI
PREHOOK: query: select count(1) from hive_test_dst
PREHOOK: type: QUERY
PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-05_953_2557790695855173848/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-28_776_220190187790387003/-mr-10000
POSTHOOK: query: select count(1) from hive_test_dst
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-05_953_2557790695855173848/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-28_776_220190187790387003/-mr-10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
6
PREHOOK: query: insert overwrite table hive_test_dst partition ( pCol1='test_part', pcol2='test_Part') select col1 from hive_test_src
@@ -67,31 +68,31 @@ POSTHOOK: Lineage: hive_test_dst PARTITI
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
PREHOOK: type: QUERY
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-12_148_1009430033459434884/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-36_044_8444747323785684087/-mr-10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
POSTHOOK: type: QUERY
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-12_148_1009430033459434884/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-36_044_8444747323785684087/-mr-10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: select count(1) from hive_test_dst
PREHOOK: type: QUERY
PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-12_203_7564156689753325528/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-36_081_7812855910433487408/-mr-10000
POSTHOOK: query: select count(1) from hive_test_dst
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-12_203_7564156689753325528/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-36_081_7812855910433487408/-mr-10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
6
PREHOOK: query: select * from hive_test_dst where pcol1='test_part'
PREHOOK: type: QUERY
PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_501_1219457432996411183/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_072_3368639497562855026/-mr-10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_part'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_501_1219457432996411183/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_072_3368639497562855026/-mr-10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
1 test_part test_Part
@@ -102,18 +103,18 @@ POSTHOOK: Lineage: hive_test_dst PARTITI
6 test_part test_Part
PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
PREHOOK: type: QUERY
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_632_4106385047710132007/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_191_1429175641027987882/-mr-10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
POSTHOOK: type: QUERY
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_632_4106385047710132007/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_191_1429175641027987882/-mr-10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: select * from hive_test_dst where pcol1='test_Part'
PREHOOK: type: QUERY
-PREHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_678_6099443731469838470/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_229_5765689340005511689/-mr-10000
POSTHOOK: query: select * from hive_test_dst where pcol1='test_Part'
POSTHOOK: type: QUERY
-POSTHOOK: Output: file:/tmp/thiruvel/hive_2010-10-11_12-44-14_678_6099443731469838470/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_229_5765689340005511689/-mr-10000
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: describe extended hive_test_dst
@@ -126,7 +127,7 @@ col1 string
pcol1 string
pcol2 string
-Detailed Table Information Table(tableName:hive_test_dst, dbName:default, owner:thiruvel, createTime:1286826241, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/hive_test_dst, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, transient_lastDdlTime=1286826252, numRows=6, total
Size=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:hive_test_dst, dbName:default, owner:krishnak, createTime:1300710144, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/hive_test_dst, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, transient_lastDdlTime=1300710155, numRows=6, totalSi
ze=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: drop table hive_test_src
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@hive_test_src
Modified: hive/trunk/ql/src/test/results/clientpositive/udaf_context_ngrams.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udaf_context_ngrams.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udaf_context_ngrams.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udaf_context_ngrams.q.out Tue Mar 22 23:05:48 2011
@@ -5,44 +5,45 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@kafka
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
PREHOOK: type: LOAD
+PREHOOK: Output: default@kafka
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
POSTHOOK: type: LOAD
POSTHOOK: Output: default@kafka
PREHOOK: query: SELECT context_ngrams(sentences(lower(contents)), array("he",null), 100, 1000) FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-27-03_343_1002290107772020180/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-28_043_6264783832009774512/-mr-10000
POSTHOOK: query: SELECT context_ngrams(sentences(lower(contents)), array("he",null), 100, 1000) FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-27-03_343_1002290107772020180/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-28_043_6264783832009774512/-mr-10000
[{"ngram":["was"],"estfrequency":17.0},{"ngram":["had"],"estfrequency":16.0},{"ngram":["thought"],"estfrequency":13.0},{"ngram":["could"],"estfrequency":9.0},{"ngram":["would"],"estfrequency":7.0},{"ngram":["lay"],"estfrequency":5.0},{"ngram":["looked"],"estfrequency":4.0},{"ngram":["s"],"estfrequency":4.0},{"ngram":["wanted"],"estfrequency":4.0},{"ngram":["did"],"estfrequency":4.0},{"ngram":["felt"],"estfrequency":4.0},{"ngram":["needed"],"estfrequency":3.0},{"ngram":["must"],"estfrequency":3.0},{"ngram":["told"],"estfrequency":3.0},{"ngram":["lifted"],"estfrequency":3.0},{"ngram":["tried"],"estfrequency":3.0},{"ngram":["finally"],"estfrequency":3.0},{"ngram":["slid"],"estfrequency":3.0},{"ngram":["reported"],"estfrequency":2.0},{"ngram":["drew"],"estfrequency":2.0},{"ngram":["is"],"estfrequency":2.0},{"ngram":["wouldn't"],"estfrequency":2.0},{"ngram":["always"],"estfrequency":2.0},{"ngram":["really"],"estfrequency":2.0},{"ngram":["let"],"estfrequency":2.0},{"ngram":["threw
"],"estfrequency":2.0},{"ngram":["found"],"estfrequency":2.0},{"ngram":["also"],"estfrequency":2.0},{"ngram":["made"],"estfrequency":2.0},{"ngram":["didn't"],"estfrequency":2.0},{"ngram":["touched"],"estfrequency":2.0},{"ngram":["do"],"estfrequency":2.0},{"ngram":["began"],"estfrequency":2.0},{"ngram":["preferred"],"estfrequency":1.0},{"ngram":["maintained"],"estfrequency":1.0},{"ngram":["managed"],"estfrequency":1.0},{"ngram":["urged"],"estfrequency":1.0},{"ngram":["will"],"estfrequency":1.0},{"ngram":["failed"],"estfrequency":1.0},{"ngram":["have"],"estfrequency":1.0},{"ngram":["heard"],"estfrequency":1.0},{"ngram":["were"],"estfrequency":1.0},{"ngram":["caught"],"estfrequency":1.0},{"ngram":["hit"],"estfrequency":1.0},{"ngram":["turned"],"estfrequency":1.0},{"ngram":["slowly"],"estfrequency":1.0},{"ngram":["stood"],"estfrequency":1.0},{"ngram":["chose"],"estfrequency":1.0},{"ngram":["swung"],"estfrequency":1.0},{"ngram":["denied"],"estfrequency":1.0},{"ngram":["intended"]
,"estfrequency":1.0},{"ngram":["became"],"estfrequency":1.0},{"ngram":["sits"],"estfrequency":1.0},{"ngram":["discovered"],"estfrequency":1.0},{"ngram":["called"],"estfrequency":1.0},{"ngram":["never"],"estfrequency":1.0},{"ngram":["cut"],"estfrequency":1.0},{"ngram":["directed"],"estfrequency":1.0},{"ngram":["hoped"],"estfrequency":1.0},{"ngram":["remembered"],"estfrequency":1.0},{"ngram":["said"],"estfrequency":1.0},{"ngram":["allowed"],"estfrequency":1.0},{"ngram":["confined"],"estfrequency":1.0},{"ngram":["almost"],"estfrequency":1.0},{"ngram":["retracted"],"estfrequency":1.0}]
PREHOOK: query: SELECT context_ngrams(sentences(lower(contents)), array(null,"salesmen"), 100, 1000) FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-27-09_129_3462618851006508964/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-30_950_8654688534928169394/-mr-10000
POSTHOOK: query: SELECT context_ngrams(sentences(lower(contents)), array(null,"salesmen"), 100, 1000) FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-27-09_129_3462618851006508964/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-30_950_8654688534928169394/-mr-10000
[{"ngram":["travelling"],"estfrequency":3.0}]
PREHOOK: query: SELECT context_ngrams(sentences(lower(contents)), array("what","i",null), 100, 1000) FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-27-14_440_1498206600885141414/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-33_931_3608359412747870955/-mr-10000
POSTHOOK: query: SELECT context_ngrams(sentences(lower(contents)), array("what","i",null), 100, 1000) FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-27-14_440_1498206600885141414/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-33_931_3608359412747870955/-mr-10000
[{"ngram":["think"],"estfrequency":3.0},{"ngram":["feel"],"estfrequency":2.0}]
PREHOOK: query: SELECT context_ngrams(sentences(lower(contents)), array(null,null), 100, 1000).estfrequency FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-27-19_700_7323220829543312705/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-36_962_3275191356992261099/-mr-10000
POSTHOOK: query: SELECT context_ngrams(sentences(lower(contents)), array(null,null), 100, 1000).estfrequency FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-27-19_700_7323220829543312705/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-36_962_3275191356992261099/-mr-10000
[23.0,20.0,18.0,17.0,17.0,16.0,16.0,16.0,16.0,15.0,14.0,13.0,12.0,12.0,12.0,11.0,11.0,11.0,10.0,10.0,10.0,10.0,10.0,10.0,9.0,9.0,9.0,8.0,8.0,8.0,8.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0]
PREHOOK: query: DROP TABLE kafka
PREHOOK: type: DROPTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/udaf_corr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udaf_corr.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udaf_corr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udaf_corr.q.out Tue Mar 22 23:05:48 2011
@@ -14,6 +14,7 @@ POSTHOOK: Output: default@covar_tab
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab
PREHOOK: type: LOAD
+PREHOOK: Output: default@covar_tab
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab
POSTHOOK: type: LOAD
@@ -40,38 +41,38 @@ and STDDEV_POP is the population standar
PREHOOK: query: SELECT corr(b, c) FROM covar_tab WHERE a < 1
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-44-58_681_3541590287509550544/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-40_474_1464411412371229362/-mr-10000
POSTHOOK: query: SELECT corr(b, c) FROM covar_tab WHERE a < 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-44-58_681_3541590287509550544/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-40_474_1464411412371229362/-mr-10000
NULL
PREHOOK: query: SELECT corr(b, c) FROM covar_tab WHERE a < 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-45-03_289_9041510910213817151/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-43_568_218125804315734633/-mr-10000
POSTHOOK: query: SELECT corr(b, c) FROM covar_tab WHERE a < 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-45-03_289_9041510910213817151/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-43_568_218125804315734633/-mr-10000
NULL
PREHOOK: query: SELECT corr(b, c) FROM covar_tab WHERE a = 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-45-06_480_8481295633393615585/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-46_666_315265665655580607/-mr-10000
POSTHOOK: query: SELECT corr(b, c) FROM covar_tab WHERE a = 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-45-06_480_8481295633393615585/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-46_666_315265665655580607/-mr-10000
NULL
PREHOOK: query: SELECT a, corr(b, c) FROM covar_tab GROUP BY a ORDER BY a
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-45-09_655_4572224946166536614/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-49_755_5099432257211714656/-mr-10000
POSTHOOK: query: SELECT a, corr(b, c) FROM covar_tab GROUP BY a ORDER BY a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-45-09_655_4572224946166536614/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-49_755_5099432257211714656/-mr-10000
1 NULL
2 NULL
3 NULL
@@ -81,11 +82,11 @@ POSTHOOK: Output: file:/tmp/nhuyn/hive_2
PREHOOK: query: SELECT corr(b, c) FROM covar_tab
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-45-20_421_6697314491903913524/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-55_446_716792391654480974/-mr-10000
POSTHOOK: query: SELECT corr(b, c) FROM covar_tab
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/nhuyn/hive_2010-08-18_14-45-20_421_6697314491903913524/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-55_446_716792391654480974/-mr-10000
0.6633880657639323
PREHOOK: query: DROP TABLE covar_tab
PREHOOK: type: DROPTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/udaf_covar_pop.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_pop.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udaf_covar_pop.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udaf_covar_pop.q.out Tue Mar 22 23:05:48 2011
@@ -14,6 +14,7 @@ POSTHOOK: Output: default@covar_tab
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab
PREHOOK: type: LOAD
+PREHOOK: Output: default@covar_tab
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab
POSTHOOK: type: LOAD
@@ -36,38 +37,38 @@ where neither x nor y is null.
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 1
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-35_725_9220435062879687360/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-58_968_4806438013320076077/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-35_725_9220435062879687360/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-58_968_4806438013320076077/-mr-10000
NULL
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-39_060_5804491211864153160/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-02_070_2692729689314573082/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-39_060_5804491211864153160/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-02_070_2692729689314573082/-mr-10000
NULL
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a = 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-43_110_8178433514900125768/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-05_164_5674819400682657915/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a = 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-43_110_8178433514900125768/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-05_164_5674819400682657915/-mr-10000
0.0
PREHOOK: query: SELECT a, covar_pop(b, c) FROM covar_tab GROUP BY a ORDER BY a
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-46_833_2681562938221634943/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-08_179_5503395149806188837/-mr-10000
POSTHOOK: query: SELECT a, covar_pop(b, c) FROM covar_tab GROUP BY a ORDER BY a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-46_833_2681562938221634943/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-08_179_5503395149806188837/-mr-10000
1 NULL
2 NULL
3 0.0
@@ -77,11 +78,11 @@ POSTHOOK: Output: file:/tmp/njain/hive_2
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-54_062_1334234285764687063/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-13_878_767643551906327366/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-54_062_1334234285764687063/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-13_878_767643551906327366/-mr-10000
3.624999999999999
PREHOOK: query: DROP TABLE covar_tab
PREHOOK: type: DROPTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/udaf_covar_samp.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_samp.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udaf_covar_samp.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udaf_covar_samp.q.out Tue Mar 22 23:05:48 2011
@@ -14,6 +14,7 @@ POSTHOOK: Output: default@covar_tab
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab
PREHOOK: type: LOAD
+PREHOOK: Output: default@covar_tab
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab
POSTHOOK: type: LOAD
@@ -36,38 +37,38 @@ where neither x nor y is null.
PREHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a < 1
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-59_096_7271177916507722521/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-17_378_6696300001997901058/-mr-10000
POSTHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a < 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-59_096_7271177916507722521/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-17_378_6696300001997901058/-mr-10000
NULL
PREHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a < 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-03_150_1003473188528906420/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-20_477_2774316055568842870/-mr-10000
POSTHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a < 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-03_150_1003473188528906420/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-20_477_2774316055568842870/-mr-10000
NULL
PREHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a = 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-06_694_3640563402690561692/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-23_642_8763585771148638371/-mr-10000
POSTHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a = 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-06_694_3640563402690561692/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-23_642_8763585771148638371/-mr-10000
0.0
PREHOOK: query: SELECT a, covar_samp(b, c) FROM covar_tab GROUP BY a ORDER BY a
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-11_096_5525901401424019584/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-26_774_8935173777638589884/-mr-10000
POSTHOOK: query: SELECT a, covar_samp(b, c) FROM covar_tab GROUP BY a ORDER BY a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-11_096_5525901401424019584/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-26_774_8935173777638589884/-mr-10000
1 NULL
2 NULL
3 0.0
@@ -77,11 +78,11 @@ POSTHOOK: Output: file:/tmp/njain/hive_2
PREHOOK: query: SELECT covar_samp(b, c) FROM covar_tab
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-17_685_5481614396851397426/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-32_487_573421382923999994/-mr-10000
POSTHOOK: query: SELECT covar_samp(b, c) FROM covar_tab
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-17_685_5481614396851397426/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-32_487_573421382923999994/-mr-10000
4.833333333333332
PREHOOK: query: DROP TABLE covar_tab
PREHOOK: type: DROPTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/udaf_ngrams.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udaf_ngrams.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udaf_ngrams.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udaf_ngrams.q.out Tue Mar 22 23:05:48 2011
@@ -5,44 +5,45 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@kafka
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
PREHOOK: type: LOAD
+PREHOOK: Output: default@kafka
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
POSTHOOK: type: LOAD
POSTHOOK: Output: default@kafka
PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000).estfrequency FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-20-28_700_4504555411999483963/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-48_288_5632959439216928755/-mr-10000
POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000).estfrequency FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-20-28_700_4504555411999483963/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-48_288_5632959439216928755/-mr-10000
[23.0,20.0,18.0,17.0,17.0,16.0,16.0,16.0,16.0,15.0,14.0,13.0,12.0,12.0,12.0,11.0,11.0,11.0,10.0,10.0,10.0,10.0,10.0,10.0,9.0,9.0,9.0,8.0,8.0,8.0,8.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0]
PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000).estfrequency FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-20-38_243_2736308572212717278/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-51_425_7596742202423993299/-mr-10000
POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000).estfrequency FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-20-38_243_2736308572212717278/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-51_425_7596742202423993299/-mr-10000
[7.0,6.0,6.0,6.0,6.0,5.0,5.0,5.0,5.0,5.0,5.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0]
PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000).estfrequency FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-20-43_391_795623401480182291/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-54_498_1141616962882375479/-mr-10000
POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000).estfrequency FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-20-43_391_795623401480182291/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-54_498_1141616962882375479/-mr-10000
[5.0,4.0,4.0,4.0,4.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0]
PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000).estfrequency FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-20-49_396_1621786218886954648/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-58_347_4459903181683954594/-mr-10000
POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000).estfrequency FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-08-18_10-20-49_396_1621786218886954648/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-58_347_4459903181683954594/-mr-10000
[4.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0]
PREHOOK: query: DROP TABLE kafka
PREHOOK: type: DROPTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_field.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_field.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_field.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_field.q.out Tue Mar 22 23:05:48 2011
@@ -16,7 +16,7 @@ PREHOOK: query: SELECT
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-12_715_3200523781855195298/10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-16_431_1630675993955239365/-mr-10000
POSTHOOK: query: SELECT
field("x", "a", "b", "c", "d"),
field(NULL, "a", "b", "c", "d"),
@@ -24,7 +24,7 @@ POSTHOOK: query: SELECT
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-12_715_3200523781855195298/10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-16_431_1630675993955239365/-mr-10000
0 0 0
PREHOOK: query: SELECT
field("a", "a", "b", "c", "d"),
@@ -35,7 +35,7 @@ PREHOOK: query: SELECT
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-15_174_5120124527305231631/10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-19_522_8239635445336730838/-mr-10000
POSTHOOK: query: SELECT
field("a", "a", "b", "c", "d"),
field("b", "a", "b", "c", "d"),
@@ -45,7 +45,7 @@ POSTHOOK: query: SELECT
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-15_174_5120124527305231631/10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-19_522_8239635445336730838/-mr-10000
1 2 3 4 4
PREHOOK: query: SELECT
field(1, 1, 2, 3, 4),
@@ -56,7 +56,7 @@ PREHOOK: query: SELECT
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-17_642_1728575695911963493/10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-22_470_7020781626233826997/-mr-10000
POSTHOOK: query: SELECT
field(1, 1, 2, 3, 4),
field(2, 1, 2, 3, 4),
@@ -66,7 +66,7 @@ POSTHOOK: query: SELECT
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-17_642_1728575695911963493/10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-22_470_7020781626233826997/-mr-10000
1 2 3 4 4
PREHOOK: query: CREATE TABLE test_table(col1 STRING, col2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
@@ -75,6 +75,7 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@test_table
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE test_table
PREHOOK: type: LOAD
+PREHOOK: Output: default@test_table
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE test_table
POSTHOOK: type: LOAD
POSTHOOK: Output: default@test_table
@@ -92,7 +93,7 @@ PREHOOK: query: select col1,col2,
from test_table where col1="86" or col1="66"
PREHOOK: type: QUERY
PREHOOK: Input: default@test_table
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-20_226_722121447925099635/10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-25_536_3123360498424168428/-mr-10000
POSTHOOK: query: select col1,col2,
field("66",col1),
field("66",col1, col2),
@@ -107,7 +108,7 @@ POSTHOOK: query: select col1,col2,
from test_table where col1="86" or col1="66"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_table
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-20_226_722121447925099635/10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-25_536_3123360498424168428/-mr-10000
86 val_86 0 0 2 0 0 0 0 0 2 0
66 val_66 1 1 0 0 0 1 0 0 2 2
PREHOOK: query: CREATE TABLE test_table1(col1 int, col2 string) STORED AS TEXTFILE
@@ -117,6 +118,7 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@test_table1
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE test_table1
PREHOOK: type: LOAD
+PREHOOK: Output: default@test_table1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE test_table1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@test_table1
@@ -131,7 +133,7 @@ PREHOOK: query: select col1,col2,
from (select col1, col2, NULL as n from test_table1 where col1=86 or col1=66) t
PREHOOK: type: QUERY
PREHOOK: Input: default@test_table1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-22_921_8146473053376578748/10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-28_737_3548755281830392909/-mr-10000
POSTHOOK: query: select col1,col2,
field(66,col1),
field(66,col1, col2),
@@ -143,6 +145,6 @@ POSTHOOK: query: select col1,col2,
from (select col1, col2, NULL as n from test_table1 where col1=86 or col1=66) t
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_table1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_12-09-22_921_8146473053376578748/10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-32-28_737_3548755281830392909/-mr-10000
86 val_86 0 0 2 1 1 0 0
66 val_66 1 1 0 0 0 0 0
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out?rev=1084403&r1=1084402&r2=1084403&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out Tue Mar 22 23:05:48 2011
@@ -59,7 +59,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-36-11_031_6373562727275009655/-ext-10000
+ destination: pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-34-26_324_5327305333350769794/-ext-10000
Stage: Stage-0
Move Operator
@@ -77,7 +77,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-36-11_031_6373562727275009655/-ext-10002
+ pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/scratchdir/hive_2011-03-21_05-34-26_324_5327305333350769794/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -100,11 +100,11 @@ POSTHOOK: Lineage: dest1.len EXPRESSION
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-36-15_723_4993295365073539383/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-34-30_517_1435949390197102187/-mr-10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-36-15_723_4993295365073539383/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-34-30_517_1435949390197102187/-mr-10000
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
7
0
@@ -150,6 +150,7 @@ POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1
PREHOOK: type: LOAD
+PREHOOK: Output: default@dest1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@dest1
@@ -193,10 +194,10 @@ STAGE PLANS:
PREHOOK: query: SELECT length(dest1.name) FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-36-16_907_1406444163456788090/-mr-10000
+PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-34-30_836_6536693317435884383/-mr-10000
POSTHOOK: query: SELECT length(dest1.name) FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-36-16_907_1406444163456788090/-mr-10000
+POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-34-30_836_6536693317435884383/-mr-10000
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
2