PageRenderTime 18ms CodeModel.GetById 13ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/order.q.out

#
text | 142 lines | 132 code | 10 blank | 0 comment | 0 complexity | d8bd2e3dcea3c72e33e0c2863b6d4c78 MD5 | raw file
  1PREHOOK: query: EXPLAIN
  2SELECT x.* FROM SRC x ORDER BY key limit 10
  3PREHOOK: type: QUERY
  4POSTHOOK: query: EXPLAIN
  5SELECT x.* FROM SRC x ORDER BY key limit 10
  6POSTHOOK: type: QUERY
  7ABSTRACT SYNTAX TREE:
  8  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME SRC) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME x)))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key))) (TOK_LIMIT 10)))
  9
 10STAGE DEPENDENCIES:
 11  Stage-1 is a root stage
 12  Stage-0 is a root stage
 13
 14STAGE PLANS:
 15  Stage: Stage-1
 16    Map Reduce
 17      Alias -> Map Operator Tree:
 18        x 
 19          TableScan
 20            alias: x
 21            Select Operator
 22              expressions:
 23                    expr: key
 24                    type: string
 25                    expr: value
 26                    type: string
 27              outputColumnNames: _col0, _col1
 28              Reduce Output Operator
 29                key expressions:
 30                      expr: _col0
 31                      type: string
 32                sort order: +
 33                tag: -1
 34                value expressions:
 35                      expr: _col0
 36                      type: string
 37                      expr: _col1
 38                      type: string
 39      Reduce Operator Tree:
 40        Extract
 41          Limit
 42            File Output Operator
 43              compressed: false
 44              GlobalTableId: 0
 45              table:
 46                  input format: org.apache.hadoop.mapred.TextInputFormat
 47                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 48
 49  Stage: Stage-0
 50    Fetch Operator
 51      limit: 10
 52
 53
 54PREHOOK: query: SELECT x.* FROM SRC x ORDER BY key limit 10
 55PREHOOK: type: QUERY
 56PREHOOK: Input: default@src
 57PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-49-58_470_1953591839692924192/-mr-10000
 58POSTHOOK: query: SELECT x.* FROM SRC x ORDER BY key limit 10
 59POSTHOOK: type: QUERY
 60POSTHOOK: Input: default@src
 61POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-49-58_470_1953591839692924192/-mr-10000
 620	val_0
 630	val_0
 640	val_0
 6510	val_10
 66100	val_100
 67100	val_100
 68103	val_103
 69103	val_103
 70104	val_104
 71104	val_104
 72PREHOOK: query: EXPLAIN
 73SELECT x.* FROM SRC x ORDER BY key desc limit 10
 74PREHOOK: type: QUERY
 75POSTHOOK: query: EXPLAIN
 76SELECT x.* FROM SRC x ORDER BY key desc limit 10
 77POSTHOOK: type: QUERY
 78ABSTRACT SYNTAX TREE:
 79  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME SRC) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME x)))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL key))) (TOK_LIMIT 10)))
 80
 81STAGE DEPENDENCIES:
 82  Stage-1 is a root stage
 83  Stage-0 is a root stage
 84
 85STAGE PLANS:
 86  Stage: Stage-1
 87    Map Reduce
 88      Alias -> Map Operator Tree:
 89        x 
 90          TableScan
 91            alias: x
 92            Select Operator
 93              expressions:
 94                    expr: key
 95                    type: string
 96                    expr: value
 97                    type: string
 98              outputColumnNames: _col0, _col1
 99              Reduce Output Operator
100                key expressions:
101                      expr: _col0
102                      type: string
103                sort order: -
104                tag: -1
105                value expressions:
106                      expr: _col0
107                      type: string
108                      expr: _col1
109                      type: string
110      Reduce Operator Tree:
111        Extract
112          Limit
113            File Output Operator
114              compressed: false
115              GlobalTableId: 0
116              table:
117                  input format: org.apache.hadoop.mapred.TextInputFormat
118                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
119
120  Stage: Stage-0
121    Fetch Operator
122      limit: 10
123
124
125PREHOOK: query: SELECT x.* FROM SRC x ORDER BY key desc limit 10
126PREHOOK: type: QUERY
127PREHOOK: Input: default@src
128PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-50-01_948_5416711380647864500/-mr-10000
129POSTHOOK: query: SELECT x.* FROM SRC x ORDER BY key desc limit 10
130POSTHOOK: type: QUERY
131POSTHOOK: Input: default@src
132POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-50-01_948_5416711380647864500/-mr-10000
13398	val_98
13498	val_98
13597	val_97
13697	val_97
13796	val_96
13895	val_95
13995	val_95
14092	val_92
14190	val_90
14290	val_90