PREHOOK: query: EXPLAIN SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL x) ds) (- (- 2008 04) 08))) (TOK_LIMIT 10))) 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: x TableScan alias: x Filter Operator predicate: expr: (ds = ((2008 - 4) - 8)) type: boolean Filter Operator predicate: expr: (ds = ((2008 - 4) - 8)) type: boolean Select Operator expressions: expr: key type: string expr: value type: string expr: ds type: string expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 Limit 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: 10 PREHOOK: query: SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10 PREHOOK: type: QUERY PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 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/njain/hive5/hive5/build/ql/tmp/1983511857/10000 POSTHOOK: query: SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 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/njain/hive5/hive5/build/ql/tmp/1983511857/10000