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 2009/12/31 17:04:46 UTC
svn commit: r894876 [8/9] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/java/org/apache/hadoop/hive/ql/plan/
ql/src/test/queries/clientpositive/ 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=894876&r1=894875&r2=894876&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 Thu Dec 31 16:04:45 2009
@@ -5,12 +5,12 @@
POSTHOOK: Output: default@dest1
PREHOOK: query: -- both input pruning and sample filter
EXPLAIN EXTENDED
-INSERT OVERWRITE TABLE dest1 SELECT s.*
+INSERT OVERWRITE TABLE dest1 SELECT s.*
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 4 on key) s
PREHOOK: type: QUERY
POSTHOOK: query: -- both input pruning and sample filter
EXPLAIN EXTENDED
-INSERT OVERWRITE TABLE dest1 SELECT s.*
+INSERT OVERWRITE TABLE dest1 SELECT s.*
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 4 on key) s
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
@@ -48,7 +48,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1980594720/10002
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/984381603/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -62,16 +62,17 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1261386905
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1262221813
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
+ file:/data/users/jsichi/open/hive-trunk/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:
@@ -85,8 +86,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -102,8 +103,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
@@ -114,11 +115,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1980594720/10002
- destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1449055290/10000
+ source: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/984381603/10002
+ destination: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/935713816/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1980594720/10002
+ file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/984381603/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -132,10 +133,11 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1980594720/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1980594720/10002]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/984381603/10002 [file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/984381603/10002]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1980594720/10002
+ file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/984381603/10002
Partition
+ base file name: 10002
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
@@ -148,8 +150,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1261386905
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1262221813
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -164,8 +166,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1261386905
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1262221813
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
name: dest1
@@ -174,7 +176,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1449055290/10000
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/935713816/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -187,9 +189,9 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dest1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1261386905
+ transient_lastDdlTime 1262221813
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -197,7 +199,7 @@
Move Operator
tables:
replace: true
- source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1449055290/10000
+ source: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/935713816/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -211,19 +213,19 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1261386905
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1262221813
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1449055290/10001
+ tmp directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/935713816/10001
-PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
+PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 4 on key) s
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
PREHOOK: Output: default@dest1
-POSTHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
+POSTHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 4 on key) s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
@@ -231,11 +233,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1179380661/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/775851946/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1179380661/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/775851946/10000
468 val_469
272 val_273
448 val_449
@@ -486,11 +488,13 @@
400 val_400
200 val_200
PREHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 4 OUT OF 4 on key) s
+ORDER BY key
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 4 OUT OF 4 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 4 4 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 4 4 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -520,23 +524,24 @@
expr: value
type: string
outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1755190214/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
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket1.txt [s]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket/srcbucket1.txt [s]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket1.txt
+ file:/data/users/jsichi/open/hive-trunk/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:
@@ -550,8 +555,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -567,11 +572,24 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/297831582/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
Stage: Stage-0
Fetch Operator
@@ -579,258 +597,262 @@
PREHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 4 OUT OF 4 on key) s
+ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/940608585/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/413101710/10000
POSTHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 4 OUT OF 4 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/940608585/10000
-179 val_180
-291 val_292
-271 val_272
-135 val_136
-167 val_168
-423 val_424
-455 val_456
-231 val_232
-287 val_288
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/413101710/10000
+3 val_4
+11 val_12
+11 val_11
+11 val_12
+11 val_12
+15 val_15
+15 val_15
+15 val_16
+15 val_16
+19 val_20
+19 val_19
+23 val_24
+27 val_27
31 val_32
-447 val_448
-443 val_444
-175 val_176
-147 val_148
-371 val_372
+35 val_35
+35 val_35
35 val_36
-243 val_244
-15 val_16
-391 val_392
-343 val_344
-275 val_276
-455 val_456
-99 val_100
-335 val_336
-367 val_368
+35 val_35
+35 val_36
+35 val_36
+43 val_43
+47 val_47
+47 val_48
+51 val_51
+51 val_51
+51 val_52
59 val_60
-11 val_12
-123 val_124
63 val_64
-135 val_136
-3 val_4
-331 val_332
-239 val_240
-235 val_236
-11 val_12
+67 val_67
+67 val_67
71 val_72
-323 val_324
-467 val_468
-411 val_412
-175 val_176
-147 val_148
-119 val_120
-347 val_348
-427 val_428
-291 val_292
-375 val_376
-191 val_192
-491 val_492
-351 val_352
-23 val_24
-487 val_488
-331 val_332
-475 val_476
-463 val_464
-183 val_184
-399 val_400
-15 val_16
-275 val_276
-87 val_88
75 val_76
-443 val_444
-407 val_408
-367 val_368
-51 val_52
-355 val_356
-363 val_364
-19 val_20
-47 val_48
-239 val_240
+83 val_83
+83 val_83
+87 val_87
+87 val_88
+87 val_88
+91 val_92
+95 val_95
+95 val_95
+99 val_100
+103 val_103
+103 val_103
+111 val_111
119 val_120
-11 val_12
+119 val_119
+119 val_119
+119 val_120
+119 val_119
+119 val_120
+123 val_124
+123 val_124
+131 val_131
+135 val_136
+135 val_136
+135 val_136
143 val_144
+143 val_143
+147 val_148
+147 val_148
+151 val_152
+151 val_152
+155 val_155
+163 val_163
+167 val_167
+167 val_168
+167 val_167
+167 val_167
+175 val_175
+175 val_176
+175 val_175
+175 val_176
+179 val_180
+179 val_179
+179 val_179
+183 val_184
+183 val_183
+187 val_187
+187 val_187
+187 val_187
+191 val_191
+191 val_191
+191 val_192
+195 val_195
+195 val_195
199 val_200
-375 val_376
-363 val_364
-395 val_396
-347 val_348
+199 val_199
+199 val_199
+199 val_199
+203 val_203
+203 val_203
+207 val_207
+207 val_207
+215 val_216
+219 val_219
+219 val_219
+223 val_223
+223 val_223
+227 val_228
+231 val_232
+235 val_236
+235 val_235
+239 val_239
+239 val_240
+239 val_239
+239 val_240
+243 val_244
+243 val_244
+247 val_247
+255 val_255
+255 val_255
259 val_260
-303 val_304
-303 val_304
-451 val_452
-351 val_352
-443 val_444
-399 val_400
+259 val_260
+263 val_263
267 val_268
-375 val_376
-295 val_296
-439 val_440
-119 val_120
-375 val_376
-391 val_392
+271 val_272
+275 val_276
+275 val_275
+275 val_276
+283 val_283
287 val_288
-375 val_376
-35 val_36
-435 val_436
-151 val_152
-491 val_492
+287 val_288
+287 val_287
+291 val_292
+291 val_291
+291 val_292
295 val_296
-407 val_408
-439 val_440
+295 val_296
+303 val_304
+303 val_304
+307 val_307
+307 val_307
+311 val_311
+311 val_311
+311 val_311
+315 val_315
+323 val_323
+323 val_324
+327 val_327
+327 val_327
+327 val_327
+331 val_332
+331 val_331
+331 val_331
+331 val_332
+335 val_335
335 val_336
-371 val_372
-123 val_124
+335 val_336
+339 val_339
+343 val_344
+347 val_348
+347 val_348
+351 val_352
+351 val_352
+351 val_351
+355 val_356
355 val_356
-87 val_88
-427 val_428
-371 val_372
-495 val_496
-259 val_260
-243 val_244
-151 val_152
-415 val_416
363 val_364
-459 val_460
-379 val_380
-215 val_216
-431 val_432
-407 val_408
+363 val_364
+363 val_364
+367 val_368
+367 val_368
+367 val_367
+367 val_367
371 val_372
-135 val_136
-91 val_92
-35 val_36
-227 val_228
+371 val_372
+371 val_372
+371 val_372
+375 val_376
+375 val_376
+375 val_375
+375 val_376
+375 val_376
+375 val_376
+379 val_380
+379 val_379
+391 val_392
+391 val_392
395 val_396
-311 val_311
-27 val_27
-255 val_255
-495 val_495
-327 val_327
-15 val_15
-403 val_403
-219 val_219
-287 val_287
-459 val_459
-207 val_207
-199 val_199
+395 val_395
+395 val_395
+395 val_396
+399 val_400
+399 val_400
399 val_399
-247 val_247
-439 val_439
-367 val_367
-167 val_167
-195 val_195
-475 val_475
-155 val_155
-203 val_203
-339 val_339
-455 val_455
-311 val_311
-111 val_111
-47 val_47
-35 val_35
-427 val_427
399 val_399
-187 val_187
-459 val_459
-51 val_51
-103 val_103
-239 val_239
-311 val_311
-275 val_275
-83 val_83
-67 val_67
+403 val_403
+403 val_403
+403 val_403
+407 val_408
+407 val_407
+407 val_408
+407 val_408
411 val_411
-463 val_463
-431 val_431
-179 val_179
-119 val_119
-199 val_199
-191 val_191
-327 val_327
-131 val_131
-51 val_51
-43 val_43
-95 val_95
-187 val_187
-87 val_87
-179 val_179
-395 val_395
+411 val_412
+415 val_416
419 val_419
-15 val_15
-307 val_307
-19 val_19
-435 val_435
-327 val_327
-331 val_331
-395 val_395
-35 val_35
-95 val_95
-11 val_11
-143 val_143
-195 val_195
-119 val_119
-223 val_223
-103 val_103
-367 val_367
-167 val_167
-219 val_219
-239 val_239
-223 val_223
-263 val_263
-487 val_487
-191 val_191
-467 val_467
-463 val_463
-35 val_35
-283 val_283
-331 val_331
-235 val_235
-335 val_335
-175 val_175
-403 val_403
-483 val_483
-203 val_203
+423 val_424
+427 val_427
+427 val_428
+427 val_428
431 val_431
+431 val_432
431 val_431
-187 val_187
-291 val_291
-351 val_351
-255 val_255
-163 val_163
-119 val_119
-491 val_491
+431 val_431
+435 val_435
+435 val_436
+439 val_440
439 val_439
-479 val_479
-199 val_199
+439 val_439
+439 val_440
+443 val_444
443 val_443
-323 val_323
-207 val_207
-83 val_83
-175 val_175
-375 val_375
-407 val_407
-67 val_67
-379 val_379
-167 val_167
-183 val_183
-315 val_315
-307 val_307
-403 val_403
+443 val_444
+443 val_444
+447 val_448
+451 val_452
+455 val_456
+455 val_455
+455 val_456
+459 val_459
+459 val_459
+459 val_460
+463 val_463
+463 val_463
+463 val_464
+467 val_468
+467 val_467
+475 val_475
+475 val_476
+479 val_479
+483 val_483
+487 val_487
+487 val_488
+491 val_491
+491 val_492
+491 val_492
+495 val_495
+495 val_496
PREHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -860,23 +882,24 @@
expr: value
type: string
outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/131514835/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
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
+ file:/data/users/jsichi/open/hive-trunk/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:
@@ -890,8 +913,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -907,11 +930,24 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/548735831/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
Stage: Stage-0
Fetch Operator
@@ -919,512 +955,516 @@
PREHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/552876598/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1184313958/10000
POSTHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/552876598/10000
-474 val_475
-62 val_63
-468 val_469
-272 val_273
-448 val_449
-246 val_247
-440 val_441
-278 val_279
-296 val_297
-428 val_429
-126 val_127
-106 val_107
-356 val_357
-490 val_491
-402 val_403
-128 val_129
-10 val_11
-226 val_227
-110 val_111
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1184313958/10000
0 val_1
-240 val_241
-286 val_287
-408 val_409
-476 val_477
-482 val_483
-48 val_49
-424 val_425
-226 val_227
-494 val_495
-488 val_489
-94 val_95
-50 val_51
-402 val_403
-128 val_129
-468 val_469
-314 val_315
-224 val_225
-344 val_345
+0 val_1
+0 val_0
+0 val_0
+0 val_0
+2 val_3
+2 val_2
+4 val_4
4 val_5
-206 val_207
-114 val_115
-56 val_57
-114 val_115
-254 val_255
-390 val_391
-304 val_305
-264 val_265
-196 val_197
-238 val_239
-20 val_21
-492 val_493
-82 val_83
-58 val_59
-86 val_87
-438 val_439
-360 val_361
-222 val_223
-42 val_43
-338 val_339
-68 val_69
-16 val_17
-492 val_493
-376 val_377
-120 val_121
-306 val_307
-426 val_427
-132 val_133
-446 val_447
-386 val_387
-388 val_389
-184 val_185
-284 val_285
-246 val_247
-262 val_263
-122 val_123
-438 val_439
-390 val_391
-352 val_353
-226 val_227
-328 val_329
-382 val_383
-342 val_343
-480 val_481
-102 val_103
-480 val_481
-318 val_319
-392 val_393
-476 val_477
-258 val_259
-174 val_175
-252 val_253
-114 val_115
-264 val_265
-48 val_49
-336 val_337
-340 val_341
-390 val_391
-484 val_485
6 val_7
-260 val_261
-2 val_3
-170 val_171
-164 val_165
-118 val_119
-310 val_311
-104 val_105
-80 val_81
-326 val_327
-450 val_451
-140 val_141
-212 val_213
-308 val_309
-30 val_31
-358 val_359
-416 val_417
-42 val_43
-386 val_387
-454 val_455
-364 val_365
+6 val_7
+8 val_9
+8 val_8
+10 val_10
+10 val_11
+12 val_12
+12 val_12
+12 val_13
+16 val_17
+16 val_17
+18 val_18
+18 val_18
20 val_21
-52 val_53
+20 val_20
+20 val_21
+22 val_23
+24 val_24
+24 val_24
+26 val_26
+26 val_26
+28 val_28
+30 val_31
+30 val_30
+32 val_33
+34 val_34
40 val_41
-8 val_9
-168 val_169
-384 val_385
-324 val_325
-310 val_311
-206 val_207
-404 val_405
-206 val_207
-226 val_227
-262 val_263
-260 val_261
-328 val_329
-322 val_323
-122 val_123
-404 val_405
-384 val_385
-76 val_77
-116 val_117
+40 val_41
+42 val_42
42 val_43
-104 val_105
-406 val_407
-32 val_33
-132 val_133
-192 val_193
-58 val_59
-70 val_71
-356 val_357
-352 val_353
+42 val_43
+42 val_43
+42 val_42
+44 val_44
+46 val_47
+48 val_49
+48 val_49
+50 val_51
52 val_53
-330 val_331
-138 val_139
-160 val_161
-454 val_455
-76 val_77
-174 val_175
-412 val_413
-16 val_17
-204 val_205
-126 val_127
-274 val_275
-374 val_375
-494 val_495
-216 val_217
-470 val_471
-196 val_197
-302 val_303
-450 val_451
-12 val_13
-398 val_399
-334 val_335
-384 val_385
-60 val_61
-442 val_443
52 val_53
-404 val_405
-446 val_447
-300 val_301
-0 val_1
-268 val_269
-392 val_393
-104 val_105
-436 val_437
-156 val_157
-118 val_119
-172 val_173
-244 val_245
-6 val_7
-284 val_285
-164 val_165
-136 val_137
-462 val_463
-432 val_433
-496 val_497
-144 val_145
-408 val_409
-152 val_153
-382 val_383
-348 val_349
-122 val_123
-292 val_293
-182 val_183
-474 val_475
-310 val_311
52 val_53
-486 val_487
-152 val_153
-378 val_379
-414 val_415
-256 val_257
-292 val_293
-412 val_413
-40 val_41
-478 val_479
-178 val_179
-100 val_101
-156 val_157
-228 val_229
-22 val_23
-248 val_249
-402 val_403
+52 val_53
+54 val_54
+56 val_57
+58 val_58
+58 val_58
+58 val_59
+58 val_59
+60 val_61
62 val_63
-162 val_163
-244 val_245
-276 val_277
-46 val_47
+62 val_63
+64 val_64
+66 val_66
+68 val_69
+70 val_70
+70 val_71
+70 val_70
+70 val_70
+72 val_72
+72 val_72
+74 val_74
+76 val_77
+76 val_76
+76 val_77
+76 val_76
+76 val_77
78 val_79
-134 val_135
-196 val_197
-410 val_411
+78 val_78
+80 val_81
+80 val_80
+82 val_82
82 val_83
-440 val_441
-100 val_101
-308 val_309
-430 val_431
-468 val_469
-152 val_153
-138 val_139
-76 val_77
-300 val_301
-478 val_479
-118 val_119
-178 val_179
-242 val_243
-244 val_245
-238 val_238
+82 val_83
+84 val_84
+84 val_84
86 val_86
-278 val_278
+86 val_87
+90 val_90
+90 val_90
+90 val_90
+92 val_92
+94 val_95
+96 val_96
98 val_98
-484 val_484
-150 val_150
-224 val_224
-66 val_66
+98 val_98
+100 val_100
+100 val_101
+100 val_101
+100 val_100
+102 val_103
+104 val_105
+104 val_104
+104 val_105
+104 val_104
+104 val_105
+106 val_107
+110 val_111
+114 val_115
+114 val_114
+114 val_115
+114 val_115
+116 val_117
+116 val_116
+118 val_119
+118 val_118
+118 val_119
+118 val_119
+118 val_118
+120 val_121
+120 val_120
+120 val_120
+122 val_123
+122 val_123
+122 val_123
+126 val_127
+126 val_126
+126 val_127
+128 val_129
+128 val_128
128 val_128
+128 val_129
+128 val_128
+132 val_133
+132 val_133
+134 val_135
+134 val_134
+134 val_134
+136 val_137
+136 val_136
+138 val_138
+138 val_139
+138 val_138
+138 val_138
+138 val_138
+138 val_139
+140 val_141
+144 val_145
146 val_146
-406 val_406
-374 val_374
+146 val_146
+150 val_150
+152 val_152
+152 val_153
+152 val_153
152 val_152
-82 val_82
+152 val_153
+156 val_157
+156 val_156
+156 val_157
+158 val_158
+160 val_161
+160 val_160
+162 val_163
+162 val_162
+164 val_165
+164 val_164
+164 val_164
+164 val_165
166 val_166
-430 val_430
-252 val_252
-292 val_292
-338 val_338
-446 val_446
-394 val_394
-482 val_482
+168 val_169
+168 val_168
+170 val_170
+170 val_171
+172 val_172
+172 val_173
+172 val_172
+174 val_175
+174 val_175
174 val_174
-494 val_494
-466 val_466
-208 val_208
174 val_174
-396 val_396
-162 val_162
-266 val_266
-342 val_342
-0 val_0
-128 val_128
-316 val_316
-302 val_302
-438 val_438
-170 val_170
-20 val_20
-378 val_378
-92 val_92
-72 val_72
-4 val_4
-280 val_280
-208 val_208
-356 val_356
-382 val_382
-498 val_498
-386 val_386
-192 val_192
-286 val_286
176 val_176
-54 val_54
-138 val_138
-216 val_216
-430 val_430
-278 val_278
176 val_176
-318 val_318
-332 val_332
+178 val_179
+178 val_179
+178 val_178
180 val_180
-284 val_284
-12 val_12
+182 val_183
+184 val_185
+186 val_186
+190 val_190
+192 val_193
+192 val_192
+194 val_194
+196 val_197
+196 val_196
+196 val_197
+196 val_197
+200 val_200
+200 val_200
+202 val_202
+204 val_205
+206 val_207
+206 val_207
+206 val_207
+208 val_208
+208 val_208
+208 val_208
+212 val_213
+214 val_214
+216 val_216
+216 val_216
+216 val_217
+218 val_218
+222 val_223
+222 val_222
+224 val_225
+224 val_224
+224 val_224
+226 val_227
+226 val_227
+226 val_226
+226 val_227
+226 val_227
+228 val_228
+228 val_229
+230 val_230
+230 val_230
+230 val_230
230 val_230
+230 val_230
+238 val_238
+238 val_239
+238 val_238
+240 val_241
+242 val_242
+242 val_243
+242 val_242
+244 val_245
+244 val_245
+244 val_244
+244 val_245
+246 val_247
+246 val_247
+248 val_248
+248 val_249
+252 val_253
+252 val_252
+254 val_255
+256 val_256
+256 val_256
+256 val_257
+258 val_258
+258 val_259
260 val_260
-404 val_404
-384 val_384
+260 val_261
+260 val_261
+262 val_263
+262 val_263
+262 val_262
+264 val_265
+264 val_265
+266 val_266
+268 val_269
272 val_272
-138 val_138
-84 val_84
-348 val_348
-466 val_466
-58 val_58
-8 val_8
-230 val_230
-208 val_208
-348 val_348
-24 val_24
-172 val_172
-42 val_42
-158 val_158
-496 val_496
-0 val_0
-322 val_322
-468 val_468
-454 val_454
-100 val_100
+272 val_272
+272 val_273
+274 val_274
+274 val_275
+276 val_277
+278 val_278
+278 val_278
+278 val_279
+280 val_280
+280 val_280
+282 val_282
+282 val_282
+284 val_284
+284 val_285
+284 val_285
+286 val_286
+286 val_287
+288 val_288
+288 val_288
+292 val_293
+292 val_293
+292 val_292
+296 val_296
+296 val_297
298 val_298
-418 val_418
-96 val_96
-26 val_26
-230 val_230
-120 val_120
-404 val_404
-436 val_436
-156 val_156
-468 val_468
+298 val_298
+298 val_298
+300 val_301
+300 val_301
+302 val_302
+302 val_303
+304 val_305
+306 val_307
+306 val_306
+308 val_309
308 val_308
-196 val_196
-288 val_288
-98 val_98
-282 val_282
+308 val_309
+310 val_311
+310 val_311
+310 val_310
+310 val_311
+314 val_315
+316 val_316
+316 val_316
+316 val_316
318 val_318
318 val_318
-470 val_470
-316 val_316
-0 val_0
-490 val_490
-364 val_364
-118 val_118
-134 val_134
-282 val_282
-138 val_138
-238 val_238
-118 val_118
-72 val_72
-90 val_90
-10 val_10
-306 val_306
-224 val_224
-242 val_242
-392 val_392
-272 val_272
-242 val_242
-452 val_452
-226 val_226
-402 val_402
-396 val_396
-58 val_58
+318 val_319
+318 val_318
+322 val_323
+322 val_322
+322 val_322
+324 val_325
+326 val_327
+328 val_329
+328 val_329
+330 val_331
+332 val_332
+334 val_335
+336 val_337
336 val_336
-168 val_168
-34 val_34
-472 val_472
-322 val_322
-498 val_498
-160 val_160
-42 val_42
-430 val_430
-458 val_458
-78 val_78
-76 val_76
-492 val_492
-218 val_218
-228 val_228
-138 val_138
-30 val_30
-64 val_64
-468 val_468
-76 val_76
-74 val_74
+338 val_338
+338 val_339
+340 val_341
342 val_342
-230 val_230
-368 val_368
-296 val_296
-216 val_216
+342 val_342
+342 val_343
+344 val_345
344 val_344
-274 val_274
-116 val_116
-256 val_256
-70 val_70
-480 val_480
-288 val_288
-244 val_244
-438 val_438
-128 val_128
-432 val_432
-202 val_202
-316 val_316
-280 val_280
-2 val_2
-80 val_80
-44 val_44
-104 val_104
-466 val_466
+344 val_344
+348 val_348
+348 val_348
+348 val_349
+348 val_348
+348 val_348
+348 val_348
+352 val_353
+352 val_353
+356 val_356
+356 val_357
+356 val_357
+358 val_359
+360 val_361
+360 val_360
+362 val_362
+364 val_365
+364 val_364
366 val_366
+368 val_368
+374 val_375
+374 val_374
+376 val_377
+378 val_378
+378 val_379
+382 val_382
+382 val_382
+382 val_383
+382 val_383
+384 val_384
+384 val_384
+384 val_385
+384 val_384
+384 val_385
+384 val_385
+386 val_387
+386 val_387
+386 val_386
+388 val_389
+390 val_391
+390 val_391
+390 val_391
+392 val_392
+392 val_393
+392 val_393
+394 val_394
+396 val_396
+396 val_396
+396 val_396
+398 val_399
+400 val_400
+402 val_402
+402 val_403
+402 val_403
+402 val_403
+404 val_404
+404 val_405
+404 val_404
+404 val_405
+404 val_405
406 val_406
-190 val_190
406 val_406
-114 val_114
-258 val_258
-90 val_90
-262 val_262
-348 val_348
+406 val_407
+406 val_406
+406 val_406
+408 val_409
+408 val_409
+410 val_411
+412 val_413
+412 val_413
+414 val_415
+414 val_414
+414 val_414
+416 val_417
+418 val_418
+424 val_425
424 val_424
-12 val_12
-396 val_396
-164 val_164
-454 val_454
-478 val_478
-298 val_298
-164 val_164
424 val_424
-382 val_382
-70 val_70
-480 val_480
-24 val_24
-104 val_104
-70 val_70
+426 val_427
+428 val_429
+430 val_430
+430 val_431
+430 val_430
+430 val_430
+432 val_433
+432 val_432
+436 val_436
+436 val_437
438 val_438
-414 val_414
-200 val_200
-360 val_360
-248 val_248
+438 val_439
+438 val_438
+438 val_439
+438 val_438
+440 val_441
+440 val_441
+442 val_443
444 val_444
-120 val_120
-230 val_230
-478 val_478
-178 val_178
-468 val_468
-310 val_310
+446 val_446
+446 val_447
+446 val_447
+448 val_449
+448 val_448
+450 val_451
+450 val_451
+452 val_452
+454 val_455
+454 val_454
+454 val_454
+454 val_455
+454 val_454
+458 val_458
+458 val_458
460 val_460
-480 val_480
-136 val_136
-172 val_172
-214 val_214
+462 val_463
462 val_462
-406 val_406
-454 val_454
-384 val_384
-256 val_256
-26 val_26
-134 val_134
-384 val_384
-18 val_18
462 val_462
+466 val_466
+466 val_466
+466 val_466
+468 val_468
+468 val_469
+468 val_469
+468 val_468
+468 val_468
+468 val_468
+468 val_469
+470 val_470
+470 val_471
+472 val_472
+474 val_475
+474 val_475
+476 val_477
+476 val_477
+478 val_478
+478 val_478
+478 val_479
+478 val_479
+480 val_481
+480 val_480
+480 val_480
+480 val_481
+480 val_480
+482 val_483
+482 val_482
+484 val_484
+484 val_485
+486 val_487
+488 val_489
+490 val_490
+490 val_491
492 val_492
-100 val_100
-298 val_298
-498 val_498
-146 val_146
-458 val_458
-362 val_362
-186 val_186
-348 val_348
-18 val_18
-344 val_344
-84 val_84
-28 val_28
-448 val_448
-152 val_152
-348 val_348
-194 val_194
-414 val_414
-222 val_222
-126 val_126
-90 val_90
-400 val_400
-200 val_200
+492 val_493
+492 val_492
+492 val_493
+494 val_494
+494 val_495
+494 val_495
+496 val_496
+496 val_497
+498 val_498
+498 val_498
+498 val_498
PREHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 3 on key) s
+ORDER BY key
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 3 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 3 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 3 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -1454,23 +1494,24 @@
expr: value
type: string
outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1920519062/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
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket [s]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket [s]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ file:/data/users/jsichi/open/hive-trunk/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:
@@ -1484,8 +1525,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1501,11 +1542,24 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/454798569/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
Stage: Stage-0
Fetch Operator
@@ -1513,355 +1567,359 @@
PREHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 3 on key) s
+ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/140212699/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/562253929/10000
POSTHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 3 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/140212699/10000
-474 val_475
-468 val_469
-246 val_247
-126 val_127
-402 val_403
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/562253929/10000
0 val_1
-240 val_241
-408 val_409
+0 val_0
+0 val_0
+0 val_0
+0 val_1
+3 val_4
+6 val_7
+6 val_7
+9 val_9
+12 val_12
+12 val_12
+12 val_13
+15 val_15
+15 val_16
+15 val_15
+15 val_16
+18 val_18
+18 val_18
+21 val_22
+21 val_22
+21 val_22
+21 val_22
+24 val_24
+24 val_24
+27 val_27
+30 val_31
+30 val_30
+33 val_33
+33 val_34
+42 val_42
+42 val_42
+42 val_43
+42 val_43
+42 val_43
48 val_49
-402 val_403
-468 val_469
+48 val_49
+51 val_51
+51 val_52
+51 val_51
+54 val_54
+57 val_57
+60 val_61
+63 val_64
+66 val_66
+69 val_69
+69 val_70
+72 val_72
+72 val_72
+75 val_76
+78 val_78
+78 val_79
+84 val_84
+84 val_84
+87 val_87
+87 val_88
+87 val_88
+90 val_90
+90 val_90
+90 val_90
+93 val_94
+93 val_94
+93 val_94
+96 val_96
+99 val_100
+102 val_103
+105 val_105
+105 val_106
+105 val_106
+111 val_111
114 val_115
+114 val_114
114 val_115
-390 val_391
-264 val_265
-492 val_493
-438 val_439
-360 val_361
-222 val_223
-42 val_43
-492 val_493
+114 val_115
+117 val_118
+117 val_118
120 val_121
-306 val_307
-426 val_427
+120 val_120
+120 val_120
+123 val_124
+123 val_124
+126 val_127
+126 val_126
+126 val_127
+129 val_129
+129 val_130
+129 val_129
+129 val_130
132 val_133
-246 val_247
-438 val_439
-390 val_391
-342 val_343
-480 val_481
-102 val_103
-480 val_481
-318 val_319
-258 val_259
-174 val_175
-252 val_253
-114 val_115
-264 val_265
-48 val_49
-336 val_337
-390 val_391
-6 val_7
-450 val_451
-30 val_31
-42 val_43
-168 val_169
-384 val_385
-324 val_325
-384 val_385
-42 val_43
132 val_133
-192 val_193
-330 val_331
+135 val_136
+135 val_136
+135 val_136
+138 val_139
+138 val_138
+138 val_138
138 val_139
+138 val_138
+138 val_138
+144 val_145
+147 val_148
+147 val_148
+150 val_150
+153 val_154
+153 val_154
+153 val_153
+156 val_157
+156 val_157
+156 val_156
+162 val_162
+162 val_163
+165 val_166
+165 val_165
+165 val_165
+168 val_169
+168 val_168
+174 val_174
174 val_175
+174 val_175
+174 val_174
+177 val_178
+177 val_178
+177 val_177
+180 val_180
+183 val_184
+183 val_183
+186 val_186
+189 val_189
+189 val_190
+192 val_192
+192 val_193
+195 val_195
+195 val_195
+201 val_201
204 val_205
-126 val_127
+207 val_207
+207 val_207
+213 val_213
+213 val_213
+213 val_214
216 val_217
-450 val_451
-12 val_13
-384 val_385
-60 val_61
-300 val_301
-0 val_1
-156 val_157
-6 val_7
-462 val_463
-432 val_433
-144 val_145
-408 val_409
-348 val_349
-474 val_475
-486 val_487
-378 val_379
-414 val_415
-156 val_157
+216 val_216
+216 val_216
+219 val_219
+219 val_219
+222 val_222
+222 val_223
+228 val_228
228 val_229
-402 val_403
-162 val_163
+231 val_232
+237 val_237
+237 val_237
+240 val_241
+243 val_244
+243 val_244
+246 val_247
+246 val_247
+249 val_250
+249 val_249
+249 val_250
+252 val_253
+252 val_252
+255 val_255
+255 val_255
+258 val_259
+258 val_258
+261 val_262
+264 val_265
+264 val_265
+267 val_268
+273 val_273
+273 val_274
+273 val_273
+273 val_273
276 val_277
-78 val_79
-468 val_469
-138 val_139
+282 val_282
+282 val_282
+285 val_286
+285 val_285
+288 val_288
+288 val_288
+291 val_291
+291 val_292
+291 val_292
300 val_301
-150 val_150
-66 val_66
-252 val_252
-174 val_174
-174 val_174
-396 val_396
-162 val_162
-342 val_342
-0 val_0
-438 val_438
-378 val_378
-72 val_72
-498 val_498
-192 val_192
-54 val_54
-138 val_138
-216 val_216
+300 val_301
+303 val_304
+303 val_304
+306 val_306
+306 val_307
+309 val_309
+309 val_309
+309 val_310
+315 val_315
+318 val_319
318 val_318
-180 val_180
-12 val_12
-384 val_384
-138 val_138
-84 val_84
-348 val_348
-348 val_348
-24 val_24
-42 val_42
-0 val_0
-468 val_468
-96 val_96
-120 val_120
-156 val_156
-468 val_468
-288 val_288
-282 val_282
318 val_318
318 val_318
-0 val_0
-282 val_282
-138 val_138
-72 val_72
-90 val_90
-306 val_306
-402 val_402
-396 val_396
+321 val_321
+321 val_321
+324 val_325
+327 val_327
+327 val_327
+327 val_327
+330 val_331
+333 val_333
+333 val_334
+333 val_333
+336 val_337
336 val_336
-168 val_168
-498 val_498
-42 val_42
-78 val_78
-492 val_492
-228 val_228
-138 val_138
-30 val_30
-468 val_468
+339 val_339
+342 val_343
342 val_342
-216 val_216
-480 val_480
-288 val_288
-438 val_438
-432 val_432
-366 val_366
-114 val_114
-258 val_258
-90 val_90
+342 val_342
+345 val_345
+348 val_348
+348 val_349
+348 val_348
348 val_348
-12 val_12
-396 val_396
-480 val_480
-24 val_24
-438 val_438
-414 val_414
-360 val_360
-444 val_444
-120 val_120
-468 val_468
-480 val_480
-462 val_462
-384 val_384
-384 val_384
-18 val_18
-462 val_462
-492 val_492
-498 val_498
-186 val_186
348 val_348
-18 val_18
-84 val_84
348 val_348
-414 val_414
-222 val_222
-126 val_126
-90 val_90
-291 val_292
-135 val_136
-423 val_424
-177 val_178
-231 val_232
-447 val_448
-147 val_148
-249 val_250
-21 val_22
-273 val_274
-441 val_442
-153 val_154
-33 val_34
-243 val_244
-333 val_334
-15 val_16
-477 val_478
-99 val_100
-393 val_394
-123 val_124
-63 val_64
-135 val_136
-3 val_4
-165 val_166
-129 val_130
-453 val_454
-249 val_250
-411 val_412
-429 val_430
-147 val_148
-213 val_214
-393 val_394
-291 val_292
-375 val_376
-129 val_130
-369 val_370
351 val_352
-183 val_184
-177 val_178
-399 val_400
-15 val_16
-87 val_88
-75 val_76
-189 val_190
-51 val_52
+351 val_352
+351 val_351
+360 val_361
+360 val_360
363 val_364
-117 val_118
-405 val_406
-153 val_154
-21 val_22
-105 val_106
-375 val_376
363 val_364
-381 val_382
-69 val_70
-303 val_304
-303 val_304
-93 val_94
-351 val_352
-399 val_400
-21 val_22
-429 val_430
-267 val_268
+363 val_364
+366 val_366
+369 val_369
+369 val_370
+369 val_369
+369 val_369
375 val_376
-489 val_490
-105 val_106
-93 val_94
375 val_376
375 val_376
-435 val_436
-21 val_22
-93 val_94
-123 val_124
-87 val_88
-261 val_262
-495 val_496
-243 val_244
-363 val_364
-117 val_118
-459 val_460
-309 val_310
-135 val_136
-285 val_286
-27 val_27
-165 val_165
-255 val_255
-273 val_273
-369 val_369
-213 val_213
-429 val_429
-495 val_495
-327 val_327
-15 val_15
+375 val_376
+375 val_375
+375 val_376
+378 val_378
+378 val_379
+381 val_382
+384 val_385
+384 val_384
+384 val_384
+384 val_384
+384 val_385
+384 val_385
+390 val_391
+390 val_391
+390 val_391
+393 val_394
+393 val_393
+393 val_394
+396 val_396
+396 val_396
+396 val_396
+399 val_399
+399 val_400
+399 val_399
+399 val_400
+402 val_403
+402 val_402
+402 val_403
+402 val_403
+405 val_406
+408 val_409
+408 val_409
+411 val_412
+411 val_411
+414 val_415
+414 val_414
+414 val_414
+417 val_417
417 val_417
-219 val_219
-153 val_153
-459 val_459
-237 val_237
-207 val_207
-399 val_399
417 val_417
+423 val_424
+426 val_427
+429 val_430
+429 val_429
+429 val_429
+429 val_430
+432 val_433
+432 val_432
+435 val_436
+435 val_435
+438 val_438
+438 val_438
+438 val_439
+438 val_438
+438 val_439
+441 val_442
+444 val_444
+447 val_448
+450 val_451
+450 val_451
+453 val_453
+453 val_454
+459 val_460
+459 val_459
+459 val_459
+462 val_463
+462 val_462
+462 val_462
+468 val_468
+468 val_469
+468 val_468
+468 val_468
+468 val_469
+468 val_468
+468 val_469
+474 val_475
+474 val_475
+477 val_478
+477 val_477
+480 val_481
+480 val_480
+480 val_481
+480 val_480
+480 val_480
+483 val_483
+486 val_487
489 val_489
-309 val_309
-195 val_195
-339 val_339
-57 val_57
-345 val_345
-129 val_129
489 val_489
-111 val_111
-399 val_399
-459 val_459
-51 val_51
-213 val_213
-333 val_333
489 val_489
-411 val_411
-129 val_129
-393 val_393
-165 val_165
-327 val_327
-51 val_51
-369 val_369
-87 val_87
-15 val_15
-435 val_435
-273 val_273
-309 val_309
-327 val_327
-369 val_369
-177 val_177
-195 val_195
-321 val_321
489 val_489
-453 val_453
-69 val_69
-33 val_33
-219 val_219
-321 val_321
-483 val_483
-105 val_105
-201 val_201
-291 val_291
-351 val_351
-255 val_255
-237 val_237
-417 val_417
-429 val_429
-333 val_333
-207 val_207
-249 val_249
-189 val_189
-375 val_375
-9 val_9
-285 val_285
-273 val_273
-183 val_183
-315 val_315
-477 val_477
+489 val_490
+492 val_492
+492 val_492
+492 val_493
+492 val_493
+495 val_495
+495 val_496
+498 val_498
+498 val_498
+498 val_498
PREHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 2 OUT OF 3 on key) s
+ORDER BY key
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 2 OUT OF 3 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 2 3 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 2 3 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -1891,23 +1949,24 @@
expr: value
type: string
outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1199635563/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
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket [s]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket [s]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ file:/data/users/jsichi/open/hive-trunk/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:
@@ -1921,8 +1980,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1938,11 +1997,24 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1261386903
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
name: srcbucket
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1549496895/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
Stage: Stage-0
Fetch Operator
@@ -1950,341 +2022,345 @@
PREHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 2 OUT OF 3 on key) s
+ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/607284870/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/111722653/10000
POSTHOOK: query: SELECT s.* FROM srcbucket TABLESAMPLE (BUCKET 2 OUT OF 3 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/607284870/10000
-448 val_449
-106 val_107
-490 val_491
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/111722653/10000
+1 val_2
+4 val_5
+4 val_4
10 val_11
+10 val_10
+16 val_17
+16 val_17
+19 val_20
+19 val_19
+22 val_23
+28 val_28
+31 val_32
+34 val_34
+37 val_37
+37 val_37
+40 val_41
+40 val_41
+43 val_43
+46 val_47
+49 val_50
+49 val_50
+52 val_53
+52 val_53
+52 val_53
+52 val_53
+58 val_58
+58 val_58
+58 val_59
+58 val_59
+61 val_62
+64 val_64
+67 val_67
+67 val_67
+70 val_70
+70 val_71
+70 val_70
+70 val_70
+76 val_76
+76 val_77
+76 val_77
+76 val_76
+76 val_77
+82 val_83
+82 val_83
+82 val_82
+85 val_86
+85 val_85
+91 val_92
+94 val_95
+97 val_97
+97 val_98
+97 val_98
+97 val_97
+100 val_101
+100 val_100
+100 val_101
+100 val_100
+103 val_103
+103 val_103
+106 val_107
+118 val_119
+118 val_119
+118 val_118
+118 val_119
+118 val_118
+121 val_122
+121 val_122
+133 val_134
+133 val_133
+136 val_137
+136 val_136
+145 val_145
+151 val_152
+151 val_152
+157 val_158
+157 val_158
+157 val_157
+160 val_161
+160 val_160
+163 val_163
+166 val_166
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+172 val_172
+172 val_172
+172 val_173
+175 val_176
+175 val_175
+175 val_175
+175 val_176
+178 val_179
+178 val_178
+178 val_179
+181 val_181
+184 val_185
+187 val_187
+187 val_187
+187 val_187
+190 val_190
+193 val_193
+193 val_193
+193 val_193
+196 val_196
+196 val_197
+196 val_197
+196 val_197
+199 val_199
+199 val_200
+199 val_199
+199 val_199
+202 val_202
+205 val_206
+205 val_205
+205 val_205
+208 val_208
+208 val_208
+208 val_208
+214 val_214
+217 val_217
+217 val_218
+217 val_218
+217 val_217
+223 val_223
+223 val_223
226 val_227
-286 val_287
-424 val_425
226 val_227
-94 val_95
-4 val_5
-304 val_305
-196 val_197
-238 val_239
-82 val_83
-58 val_59
-16 val_17
-376 val_377
-388 val_389
-184 val_185
-262 val_263
-352 val_353
+226 val_226
226 val_227
-328 val_329
-382 val_383
-340 val_341
-484 val_485
-118 val_119
-310 val_311
-358 val_359
-454 val_455
-364 val_365
-52 val_53
-40 val_41
-310 val_311
226 val_227
-262 val_263
-328 val_329
-322 val_323
-76 val_77
-406 val_407
-58 val_59
-70 val_71
-352 val_353
-52 val_53
-160 val_161
-454 val_455
-76 val_77
-412 val_413
-16 val_17
-274 val_275
-196 val_197
-334 val_335
-442 val_443
-52 val_53
-268 val_269
-436 val_437
-118 val_119
-172 val_173
+229 val_229
+229 val_229
+235 val_236
+235 val_235
+238 val_239
+238 val_238
+238 val_238
+241 val_242
+241 val_242
+241 val_241
+241 val_242
+241 val_242
244 val_245
-136 val_137
-496 val_497
-382 val_383
-292 val_293
-310 val_311
-52 val_53
-256 val_257
-292 val_293
-412 val_413
-40 val_41
-478 val_479
-178 val_179
-100 val_101
-22 val_23
244 val_245
-46 val_47
-196 val_197
-82 val_83
-100 val_101
-430 val_431
-76 val_77
-478 val_479
-118 val_119
-178 val_179
+244 val_244
244 val_245
-238 val_238
-484 val_484
-406 val_406
-82 val_82
-166 val_166
-430 val_430
-292 val_292
-394 val_394
-466 val_466
-208 val_208
-316 val_316
-4 val_4
+247 val_247
+256 val_256
+256 val_256
+256 val_257
+259 val_260
+259 val_260
+262 val_263
+262 val_263
+262 val_262
+265 val_265
+265 val_265
+265 val_266
+268 val_269
+271 val_272
+274 val_275
+274 val_274
+277 val_277
+277 val_278
+277 val_277
+277 val_278
+277 val_277
+277 val_277
280 val_280
-208 val_208
-382 val_382
+280 val_280
+283 val_283
+286 val_287
286 val_286
-430 val_430
-466 val_466
-58 val_58
-208 val_208
-172 val_172
-496 val_496
-322 val_322
-454 val_454
-100 val_100
+289 val_289
+289 val_290
+292 val_293
+292 val_293
+292 val_292
+295 val_296
+295 val_296
298 val_298
-418 val_418
-436 val_436
-196 val_196
-316 val_316
-490 val_490
-364 val_364
-118 val_118
-238 val_238
-118 val_118
-10 val_10
-226 val_226
-58 val_58
-34 val_34
-472 val_472
-322 val_322
-160 val_160
-430 val_430
-76 val_76
-64 val_64
-76 val_76
-274 val_274
-256 val_256
-70 val_70
-244 val_244
-202 val_202
-316 val_316
-280 val_280
-466 val_466
-406 val_406
-190 val_190
-406 val_406
-262 val_262
-424 val_424
-454 val_454
-478 val_478
298 val_298
-424 val_424
-382 val_382
-70 val_70
-70 val_70
-478 val_478
-178 val_178
-310 val_310
-460 val_460
-136 val_136
-172 val_172
-214 val_214
-406 val_406
-454 val_454
-256 val_256
-100 val_100
298 val_298
-28 val_28
-448 val_448
-400 val_400
-271 val_272
-217 val_218
-241 val_242
-31 val_32
+304 val_305
+307 val_307
+307 val_307
+310 val_310
+310 val_311
+310 val_311
+310 val_311
+313 val_314
+316 val_316
+316 val_316
+316 val_316
+322 val_322
+322 val_322
+322 val_323
+325 val_325
+325 val_325
+328 val_329
+328 val_329
+331 val_332
+331 val_332
+331 val_331
+331 val_331
+334 val_335
+337 val_338
+340 val_341
+343 val_344
+349 val_350
+349 val_350
+349 val_350
+349 val_350
+352 val_353
+352 val_353
+355 val_356
+355 val_356
+358 val_359
+364 val_365
+364 val_364
+367 val_367
+367 val_368
+367 val_368
+367 val_367
373 val_374
-175 val_176
-217 val_218
-421 val_422
-133 val_134
+373 val_373
+376 val_377
+379 val_380
+379 val_379
+382 val_382
+382 val_383
+382 val_383
+382 val_382
+385 val_386
+385 val_386
+388 val_389
391 val_392
-343 val_344
-241 val_242
-85 val_86
-367 val_368
-349 val_350
+391 val_392
+394 val_394
+397 val_397
+397 val_397
+400 val_400
+403 val_403
+403 val_403
+403 val_403
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+406 val_407
409 val_410
-265 val_266
-277 val_278
-331 val_332
-235 val_236
-289 val_290
+409 val_409
+409 val_409
+409 val_410
+409 val_409
+412 val_413
+412 val_413
+415 val_416
+418 val_418
+421 val_421
421 val_422
-175 val_176
+421 val_422
+424 val_425
+424 val_424
+424 val_424
+427 val_427
427 val_428
-121 val_122
-349 val_350
-487 val_488
-331 val_332
-409 val_410
-475 val_476
-463 val_464
-367 val_368
-349 val_350
-355 val_356
-19 val_20
-121 val_122
-241 val_242
-49 val_50
-157 val_158
-199 val_200
-313 val_314
-385 val_386
-259 val_260
-241 val_242
-469 val_470
-481 val_482
-277 val_278
-451 val_452
-205 val_206
-295 val_296
+427 val_428
+430 val_431
+430 val_430
+430 val_430
+430 val_430
+436 val_437
+436 val_436
+439 val_439
+439 val_439
439 val_440
-457 val_458
-391 val_392
-151 val_152
-295 val_296
-61 val_62
439 val_440
-349 val_350
-355 val_356
-427 val_428
-97 val_98
-385 val_386
-49 val_50
-259 val_260
-97 val_98
-151 val_152
-415 val_416
-379 val_380
-157 val_158
-337 val_338
-91 val_92
-1 val_2
+442 val_443
+448 val_449
+448 val_448
+451 val_452
+454 val_454
+454 val_455
+454 val_454
+454 val_454
+454 val_455
457 val_458
-409 val_409
-265 val_265
-193 val_193
+457 val_457
+457 val_458
+460 val_460
+463 val_463
+463 val_464
+463 val_463
+466 val_466
+466 val_466
+466 val_466
+469 val_470
+469 val_469
469 val_469
-145 val_145
-37 val_37
-277 val_277
-403 val_403
-193 val_193
-199 val_199
-247 val_247
-397 val_397
-439 val_439
-367 val_367
-325 val_325
-475 val_475
-205 val_205
-157 val_157
-427 val_427
-277 val_277
-169 val_169
469 val_469
-187 val_187
-103 val_103
-289 val_289
-241 val_241
-181 val_181
-67 val_67
-373 val_373
-217 val_217
-463 val_463
-199 val_199
-205 val_205
-43 val_43
469 val_469
+469 val_469
+472 val_472
+475 val_475
+475 val_476
+478 val_479
+478 val_479
+478 val_478
+478 val_478
+481 val_482
481 val_481
-457 val_457
-187 val_187
-409 val_409
-169 val_169
-85 val_85
-307 val_307
-19 val_19
-277 val_277
-331 val_331
-229 val_229
-223 val_223
-103 val_103
-367 val_367
-223 val_223
+484 val_484
+484 val_485
487 val_487
-229 val_229
-469 val_469
-463 val_463
-283 val_283
-331 val_331
-235 val_235
-193 val_193
-175 val_175
-403 val_403
-409 val_409
-217 val_217
-187 val_187
-397 val_397
-163 val_163
-439 val_439
-199 val_199
-169 val_169
-325 val_325
-277 val_277
+487 val_488
+490 val_491
+490 val_490
493 val_493
-265 val_265
-133 val_133
-175 val_175
-421 val_421
-67 val_67
-379 val_379
-97 val_97
-469 val_469
-37 val_37
-307 val_307
-169 val_169
-403 val_403
-97 val_97
+496 val_496
+496 val_497
PREHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket2 (TOK_TABLESAMPLE 1 2 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket2 (TOK_TABLESAMPLE 1 2 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -2314,24 +2390,25 @@
expr: value
type: string
outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/71256001/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
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2/srcbucket20.txt [s]
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2/srcbucket22.txt [s]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket2/srcbucket20.txt [s]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket2/srcbucket22.txt [s]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2/srcbucket20.txt
+ file:/data/users/jsichi/open/hive-trunk/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:
@@ -2345,8 +2422,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1261386904
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket2
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2362,13 +2439,14 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1261386904
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket2
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket2
name: srcbucket2
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2/srcbucket22.txt
+ file:/data/users/jsichi/open/hive-trunk/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:
@@ -2382,8 +2460,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1261386904
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket2
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2399,11 +2477,24 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1261386904
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket2
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket2
name: srcbucket2
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/2057711177/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
Stage: Stage-0
Fetch Operator
@@ -2411,141 +2502,145 @@
PREHOOK: query: SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket2
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/734407945/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1141265451/10000
POSTHOOK: query: SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket2
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/734407945/10000
-484 val_484
-150 val_150
-224 val_224
-66 val_66
-374 val_374
-338 val_338
-466 val_466
-396 val_396
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1141265451/10000
0 val_0
-316 val_316
-378 val_378
+0 val_0
+0 val_0
+2 val_2
4 val_4
-356 val_356
-286 val_286
-176 val_176
-176 val_176
-260 val_260
-404 val_404
+8 val_8
+20 val_20
+24 val_24
+24 val_24
+26 val_26
+26 val_26
+28 val_28
+42 val_42
+42 val_42
+44 val_44
+64 val_64
+66 val_66
+80 val_80
+82 val_82
+84 val_84
84 val_84
-466 val_466
-8 val_8
-172 val_172
-158 val_158
-0 val_0
-26 val_26
-404 val_404
-282 val_282
-316 val_316
-0 val_0
+86 val_86
+114 val_114
+116 val_116
118 val_118
-282 val_282
118 val_118
-224 val_224
-242 val_242
-392 val_392
-242 val_242
-396 val_396
-228 val_228
-480 val_480
-202 val_202
-316 val_316
-80 val_80
-44 val_44
-466 val_466
-190 val_190
-114 val_114
-396 val_396
-480 val_480
-444 val_444
-480 val_480
+134 val_134
+134 val_134
136 val_136
-172 val_172
-462 val_462
-26 val_26
-462 val_462
-84 val_84
-448 val_448
-194 val_194
-400 val_400
-86 val_86
-406 val_406
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+150 val_150
152 val_152
-82 val_82
-446 val_446
-394 val_394
-482 val_482
+152 val_152
+156 val_156
+158 val_158
+170 val_170
+172 val_172
+172 val_172
174 val_174
-208 val_208
174 val_174
+176 val_176
+176 val_176
+178 val_178
+190 val_190
+192 val_192
+194 val_194
+196 val_196
+200 val_200
+200 val_200
+202 val_202
+208 val_208
+208 val_208
+208 val_208
+222 val_222
+224 val_224
+224 val_224
+226 val_226
+228 val_228
+242 val_242
+242 val_242
+244 val_244
+248 val_248
+260 val_260
+262 val_262
266 val_266
-170 val_170
-20 val_20
280 val_280
-208 val_208
-192 val_192
-138 val_138
-318 val_318
-332 val_332
+280 val_280
+282 val_282
+282 val_282
284 val_284
-138 val_138
-208 val_208
-24 val_24
-42 val_42
-468 val_468
-156 val_156
-468 val_468
-196 val_196
+286 val_286
+288 val_288
288 val_288
+310 val_310
+316 val_316
+316 val_316
+316 val_316
318 val_318
318 val_318
-134 val_134
-138 val_138
-226 val_226
-402 val_402
+318 val_318
+332 val_332
336 val_336
-42 val_42
-138 val_138
-64 val_64
-468 val_468
-116 val_116
-288 val_288
-244 val_244
-280 val_280
-2 val_2
+338 val_338
+356 val_356
+374 val_374
+378 val_378
+392 val_392
+394 val_394
+396 val_396
+396 val_396
+396 val_396
+400 val_400
+402 val_402
+404 val_404
+404 val_404
+406 val_406
+406 val_406
406 val_406
406 val_406
-262 val_262
424 val_424
424 val_424
-24 val_24
-200 val_200
-248 val_248
-178 val_178
-468 val_468
-310 val_310
+444 val_444
+446 val_446
+448 val_448
460 val_460
-406 val_406
-134 val_134
-28 val_28
-152 val_152
-222 val_222
-200 val_200
+462 val_462
+462 val_462
+466 val_466
+466 val_466
+466 val_466
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+480 val_480
+480 val_480
+480 val_480
+482 val_482
+484 val_484
PREHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 2 OUT OF 4 on key) s
+ORDER BY key
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 2 OUT OF 4 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket2 (TOK_TABLESAMPLE 2 4 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket2 (TOK_TABLESAMPLE 2 4 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -2575,23 +2670,24 @@
expr: value
type: string
outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1039497046/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
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2/srcbucket21.txt [s]
+ file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket2/srcbucket21.txt [s]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2/srcbucket21.txt
+ file:/data/users/jsichi/open/hive-trunk/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:
@@ -2605,8 +2701,8 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1261386904
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket2
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2622,11 +2718,24 @@
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:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket2
- transient_lastDdlTime 1261386904
+ location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcbucket2
+ transient_lastDdlTime 1262221811
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket2
name: srcbucket2
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/380504830/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
Stage: Stage-0
Fetch Operator
@@ -2634,62 +2743,66 @@
PREHOOK: query: SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 2 OUT OF 4 on key) s
+ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket2
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1129590285/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1524009811/10000
POSTHOOK: query: SELECT s.* FROM srcbucket2 TABLESAMPLE (BUCKET 2 OUT OF 4 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket2
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1129590285/10000
-409 val_409
-265 val_265
-401 val_401
-489 val_489
-397 val_397
-489 val_489
-221 val_221
-221 val_221
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1524009811/10000
+5 val_5
+5 val_5
+5 val_5
+9 val_9
+41 val_41
+85 val_85
+133 val_133
137 val_137
-489 val_489
-353 val_353
-393 val_393
-481 val_481
-409 val_409
137 val_137
-85 val_85
-401 val_401
177 val_177
-5 val_5
-317 val_317
+221 val_221
+221 val_221
229 val_229
-489 val_489
-41 val_41
-449 val_449
-485 val_485
-401 val_401
-5 val_5
229 val_229
-409 val_409
-401 val_401
-5 val_5
-397 val_397
-317 val_317
265 val_265
+265 val_265
+317 val_317
+317 val_317
353 val_353
-133 val_133
+353 val_353
+393 val_393
+397 val_397
+397 val_397
401 val_401
-9 val_9
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+409 val_409
+409 val_409
+409 val_409
+449 val_449
+481 val_481
+485 val_485
+489 val_489
+489 val_489
+489 val_489
+489 val_489
PREHOOK: query: CREATE TABLE empty_bucket (key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE empty_bucket (key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@empty_bucket
PREHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM empty_bucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT s.* FROM empty_bucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF empty_bucket (TOK_TABLESAMPLE 1 2 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF empty_bucket (TOK_TABLESAMPLE 1 2 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -2719,18 +2832,31 @@
expr: value
type: string
outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1722234666/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
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
Needs Tagging: false
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/561218927/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
Stage: Stage-0
Fetch Operator
@@ -2738,13 +2864,15 @@
PREHOOK: query: SELECT s.* FROM empty_bucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@empty_bucket
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1417661978/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/380584002/10000
POSTHOOK: query: SELECT s.* FROM empty_bucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s
+ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@empty_bucket
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1417661978/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/380584002/10000
PREHOOK: query: drop table empty_bucket
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table empty_bucket