/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/sample3.q.out
# · text · 244 lines · 239 code · 5 blank · 0 comment · 0 complexity · 9cf586cf132abf3476f14993e04f32e7 MD5 · raw file
- PREHOOK: query: -- no input pruning, sample filter
- EXPLAIN
- SELECT s.key
- FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
- PREHOOK: type: QUERY
- POSTHOOK: query: -- no input pruning, sample filter
- EXPLAIN
- SELECT s.key
- FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
- POSTHOOK: type: QUERY
- ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcbucket) (TOK_TABLEBUCKETSAMPLE 1 5 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s) key)))))
- STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 is a root stage
- STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- s
- TableScan
- alias: s
- Filter Operator
- predicate:
- expr: (((hash(key) & 2147483647) % 5) = 0)
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: int
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Stage: Stage-0
- Fetch Operator
- limit: -1
- PREHOOK: query: SELECT s.key
- FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s SORT BY key
- PREHOOK: type: QUERY
- PREHOOK: Input: default@srcbucket
- PREHOOK: Output: file:/tmp/sdong/hive_2011-04-19_19-54-10_335_2811911774445865646/-mr-10000
- POSTHOOK: query: SELECT s.key
- FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s SORT BY key
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@srcbucket
- POSTHOOK: Output: file:/tmp/sdong/hive_2011-04-19_19-54-10_335_2811911774445865646/-mr-10000
- 0
- 0
- 0
- 0
- 0
- 5
- 5
- 5
- 5
- 10
- 10
- 15
- 15
- 15
- 15
- 20
- 20
- 20
- 30
- 30
- 35
- 35
- 35
- 35
- 35
- 35
- 40
- 40
- 50
- 60
- 65
- 65
- 65
- 70
- 70
- 70
- 70
- 75
- 80
- 80
- 85
- 85
- 90
- 90
- 90
- 95
- 95
- 100
- 100
- 100
- 100
- 105
- 105
- 105
- 110
- 120
- 120
- 120
- 125
- 125
- 125
- 135
- 135
- 135
- 140
- 145
- 150
- 155
- 160
- 160
- 165
- 165
- 165
- 170
- 170
- 175
- 175
- 175
- 175
- 180
- 185
- 190
- 195
- 195
- 200
- 200
- 205
- 205
- 205
- 215
- 230
- 230
- 230
- 230
- 230
- 235
- 235
- 240
- 245
- 245
- 255
- 255
- 260
- 260
- 260
- 265
- 265
- 265
- 275
- 275
- 275
- 280
- 280
- 285
- 285
- 295
- 295
- 300
- 300
- 305
- 305
- 310
- 310
- 310
- 310
- 315
- 325
- 325
- 330
- 335
- 335
- 335
- 340
- 345
- 355
- 355
- 360
- 360
- 365
- 375
- 375
- 375
- 375
- 375
- 375
- 385
- 385
- 390
- 390
- 390
- 395
- 395
- 395
- 395
- 400
- 405
- 410
- 415
- 425
- 430
- 430
- 430
- 430
- 435
- 435
- 440
- 440
- 450
- 450
- 455
- 455
- 455
- 460
- 470
- 470
- 475
- 475
- 480
- 480
- 480
- 480
- 480
- 485
- 485
- 485
- 490
- 490
- 495
- 495