You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by nz...@apache.org on 2010/02/14 03:31:44 UTC
svn commit: r909965 [12/15] - in /hadoop/hive/trunk: ./
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/test/results/clientpositive/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out Sun Feb 14 02:31:40 2010
@@ -50,63 +50,63 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/76792880/10002
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595552
+ transient_lastDdlTime 1266042831
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
Partition
base file name: srcbucket0.txt
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
@@ -118,37 +118,37 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/76792880/10002
- destination: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/687711381/10000
+ source: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10002
+ destination: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/687711381/10000
+ source: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595552
+ transient_lastDdlTime 1266042831
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/687711381/10001
+ tmp directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10001
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/76792880/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -162,41 +162,41 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/76792880/10002 [file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/76792880/10002]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10002 [file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10002]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/76792880/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10002
Partition
base file name: 10002
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595552
+ transient_lastDdlTime 1266042831
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595552
+ transient_lastDdlTime 1266042831
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
name: dest1
@@ -205,22 +205,22 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/687711381/10000
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-51_119_2219825656679729521/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dest1
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1263595552
+ transient_lastDdlTime 1266042831
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -238,11 +238,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2070048698/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-56_111_3004481512310530952/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2070048698/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-56_111_3004481512310530952/10000
468 val_469
272 val_273
448 val_449
@@ -544,43 +544,43 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket/srcbucket1.txt [s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket/srcbucket1.txt [s]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket/srcbucket1.txt
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket/srcbucket1.txt
Partition
base file name: srcbucket1.txt
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
@@ -589,14 +589,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/82512368/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-56_155_9100961642412278851/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1
- serialization.format 1
columns.types int:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -607,12 +607,12 @@
ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/618846126/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-56_202_4162487246668955241/10000
POSTHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 4 OUT OF 4 on key) s
ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/618846126/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-33-56_202_4162487246668955241/10000
3 val_4
11 val_11
11 val_12
@@ -904,43 +904,43 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
Partition
base file name: srcbucket0.txt
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
@@ -949,14 +949,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1069131344/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-01_731_6395441503427700332/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1
- serialization.format 1
columns.types int:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -967,12 +967,12 @@
ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/476394937/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-01_782_1797145005554910345/10000
POSTHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/476394937/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-01_782_1797145005554910345/10000
0 val_0
0 val_0
0 val_0
@@ -1518,43 +1518,43 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket [s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket [s]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
Partition
base file name: srcbucket
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
@@ -1563,14 +1563,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1423291663/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-06_458_5690780923487497627/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1
- serialization.format 1
columns.types int:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -1581,12 +1581,12 @@
ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1885000441/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-06_510_2608414978582447264/10000
POSTHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 3 on key) s
ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1885000441/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-06_510_2608414978582447264/10000
0 val_0
0 val_0
0 val_0
@@ -1975,43 +1975,43 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket [s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket [s]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
Partition
base file name: srcbucket
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
@@ -2020,14 +2020,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/905430948/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-12_512_700602305468578454/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1
- serialization.format 1
columns.types int:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -2038,12 +2038,12 @@
ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/491457993/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-12_563_3247760755754303761/10000
POSTHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 2 OUT OF 3 on key) s
ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/491457993/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-12_563_3247760755754303761/10000
1 val_2
4 val_4
4 val_5
@@ -2418,82 +2418,82 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2/srcbucket20.txt [s]
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2/srcbucket22.txt [s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2/srcbucket20.txt [s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2/srcbucket22.txt [s]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2/srcbucket20.txt
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2/srcbucket20.txt
Partition
base file name: srcbucket20.txt
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket2
- columns.types int:string
+ bucket_count 4
bucket_field_name key
- serialization.ddl struct srcbucket2 { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 4
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2
+ name srcbucket2
+ serialization.ddl struct srcbucket2 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket2
- columns.types int:string
+ bucket_count 4
bucket_field_name key
- serialization.ddl struct srcbucket2 { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 4
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2
+ name srcbucket2
+ serialization.ddl struct srcbucket2 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket2
name: srcbucket2
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2/srcbucket22.txt
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2/srcbucket22.txt
Partition
base file name: srcbucket22.txt
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket2
- columns.types int:string
+ bucket_count 4
bucket_field_name key
- serialization.ddl struct srcbucket2 { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 4
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2
+ name srcbucket2
+ serialization.ddl struct srcbucket2 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket2
- columns.types int:string
+ bucket_count 4
bucket_field_name key
- serialization.ddl struct srcbucket2 { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 4
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2
+ name srcbucket2
+ serialization.ddl struct srcbucket2 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket2
name: srcbucket2
@@ -2502,14 +2502,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1110665362/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-19_152_7679626437931174008/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1
- serialization.format 1
columns.types int:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -2520,12 +2520,12 @@
ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket2
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1183035972/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-19_225_4502411711216640112/10000
POSTHOOK: query: SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket2
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1183035972/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-19_225_4502411711216640112/10000
0 val_0
0 val_0
0 val_0
@@ -2700,43 +2700,43 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2/srcbucket21.txt [s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2/srcbucket21.txt [s]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2/srcbucket21.txt
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2/srcbucket21.txt
Partition
base file name: srcbucket21.txt
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket2
- columns.types int:string
+ bucket_count 4
bucket_field_name key
- serialization.ddl struct srcbucket2 { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 4
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2
+ name srcbucket2
+ serialization.ddl struct srcbucket2 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket2
- columns.types int:string
+ bucket_count 4
bucket_field_name key
- serialization.ddl struct srcbucket2 { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 4
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1263595551
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/srcbucket2
+ name srcbucket2
+ serialization.ddl struct srcbucket2 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266042830
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket2
name: srcbucket2
@@ -2745,14 +2745,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1239806329/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-24_674_8736848919113523990/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1
- serialization.format 1
columns.types int:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -2763,12 +2763,12 @@
ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket2
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2076765396/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-24_726_8933628050555327816/10000
POSTHOOK: query: SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 2 OUT OF 4 on key) s
ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket2
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2076765396/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-24_726_8933628050555327816/10000
5 val_5
5 val_5
5 val_5
@@ -2868,14 +2868,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1009963688/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-29_840_8091316488320267247/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1
- serialization.format 1
columns.types int:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -2886,12 +2886,12 @@
ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@empty_bucket
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1185613635/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-29_882_8027872574466731313/10000
POSTHOOK: query: SELECT s.* FROM empty_bucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@empty_bucket
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1185613635/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-34-29_882_8027872574466731313/10000
PREHOOK: query: drop table empty_bucket
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table empty_bucket
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out Sun Feb 14 02:31:40 2010
@@ -57,63 +57,63 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1035780131/10002
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595490
+ transient_lastDdlTime 1266043128
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
Partition
base file name: srcbucket0.txt
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595489
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266043127
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcbucket
- columns.types int:string
+ bucket_count 2
bucket_field_name key
- serialization.ddl struct srcbucket { i32 key, string value}
columns key,value
- serialization.format 1
- bucket_count 2
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1263595489
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcbucket
+ name srcbucket
+ serialization.ddl struct srcbucket { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ transient_lastDdlTime 1266043127
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
@@ -125,37 +125,37 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1035780131/10002
- destination: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/888645524/10000
+ source: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10002
+ destination: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/888645524/10000
+ source: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595490
+ transient_lastDdlTime 1266043128
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/888645524/10001
+ tmp directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10001
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1035780131/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -169,41 +169,41 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1035780131/10002 [file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1035780131/10002]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10002 [file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10002]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1035780131/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10002
Partition
base file name: 10002
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595490
+ transient_lastDdlTime 1266043128
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595490
+ transient_lastDdlTime 1266043128
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
name: dest1
@@ -212,22 +212,22 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/888645524/10000
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-48_500_8655541435915917144/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key,value
columns.types int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/test/data/warehouse/dest1
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1263595490
+ transient_lastDdlTime 1266043128
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -247,11 +247,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1338741395/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-53_265_8088248524292407998/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1338741395/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-38-53_265_8088248524292407998/10000
468 val_469
272 val_273
448 val_449
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out Sun Feb 14 02:31:40 2010
@@ -28,60 +28,60 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- t
+ s
TableScan
- alias: t
+ alias: s
Filter Operator
isSamplingPred: false
predicate:
- expr: (((hash(key) & 2147483647) % 10) = 0)
+ expr: (((((((hash(key) & 2147483647) % 1) = 0) and (ds = '2008-04-08')) and (hr = '11')) and (ds = '2008-04-08')) and (hr = '11'))
type: boolean
Filter Operator
isSamplingPred: true
predicate:
- expr: (((hash(key) & 2147483647) % 10) = 0)
+ expr: (((hash(key) & 2147483647) % 1) = 0)
type: boolean
Reduce Output Operator
sort order:
- tag: 1
+ tag: 0
value expressions:
expr: key
type: string
expr: value
type: string
- s
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ t
TableScan
- alias: s
+ alias: t
Filter Operator
isSamplingPred: false
predicate:
- expr: (((((((hash(key) & 2147483647) % 1) = 0) and (ds = '2008-04-08')) and (hr = '11')) and (ds = '2008-04-08')) and (hr = '11'))
+ expr: (((hash(key) & 2147483647) % 10) = 0)
type: boolean
Filter Operator
isSamplingPred: true
predicate:
- expr: (((hash(key) & 2147483647) % 1) = 0)
+ expr: (((hash(key) & 2147483647) % 10) = 0)
type: boolean
Reduce Output Operator
sort order:
- tag: 0
+ tag: 1
value expressions:
expr: key
type: string
expr: value
type: string
- expr: ds
- type: string
- expr: hr
- type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [t, s]
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [t]
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [t]
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [t]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [t, s]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [t]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [t]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [t]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/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
@@ -90,39 +90,39 @@
ds 2008-04-08
hr 11
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1263595550
+ transient_lastDdlTime 1266043030
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1263595550
+ transient_lastDdlTime 1266043030
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/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
@@ -131,39 +131,39 @@
ds 2008-04-08
hr 12
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1263595550
+ transient_lastDdlTime 1266043030
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1263595550
+ transient_lastDdlTime 1266043030
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -172,39 +172,39 @@
ds 2008-04-09
hr 11
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1263595550
+ transient_lastDdlTime 1266043030
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1263595550
+ transient_lastDdlTime 1266043030
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -213,35 +213,35 @@
ds 2008-04-09
hr 12
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1263595550
+ transient_lastDdlTime 1266043030
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1263595550
+ transient_lastDdlTime 1266043030
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -273,7 +273,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1204176731/10002
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-37-12_602_8370903476718056476/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -285,7 +285,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1204176731/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-37-12_602_8370903476718056476/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -310,9 +310,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1204176731/10002 [file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1204176731/10002]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-37-12_602_8370903476718056476/10002 [file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-37-12_602_8370903476718056476/10002]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1204176731/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-37-12_602_8370903476718056476/10002
Partition
base file name: 10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -333,14 +333,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1204176731/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-37-12_602_8370903476718056476/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1,_col2,_col3
- serialization.format 1
columns.types string:string:string:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -358,7 +358,7 @@
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:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/909331877/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-37-12_818_1555523030124259486/10000
POSTHOOK: query: SELECT s.key, s.value
FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON key) s
JOIN srcpart TABLESAMPLE (BUCKET 1 OUT OF 10 ON key) t
@@ -370,7 +370,7 @@
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:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/909331877/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-37-12_818_1555523030124259486/10000
0 val_0
0 val_0
0 val_0