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