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 #### A masked pattern was here #### 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 #### A masked pattern was here #### 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