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

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/input22.q.out

#
text | 94 lines | 89 code | 5 blank | 0 comment | 0 complexity | e0c30c90674f426a244eb31407d9a34f MD5 | raw file
 1PREHOOK: query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE
 2PREHOOK: type: CREATETABLE
 3POSTHOOK: query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE
 4POSTHOOK: type: CREATETABLE
 5POSTHOOK: Output: default@INPUT4
 6PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
 7PREHOOK: type: LOAD
 8POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
 9POSTHOOK: type: LOAD
10POSTHOOK: Output: default@input4
11PREHOOK: query: EXPLAIN
12SELECT a.KEY2
13FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
14      FROM INPUT4) a
15ORDER BY KEY2 LIMIT 10
16PREHOOK: type: QUERY
17POSTHOOK: query: EXPLAIN
18SELECT a.KEY2
19FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
20      FROM INPUT4) a
21ORDER BY KEY2 LIMIT 10
22POSTHOOK: type: QUERY
23ABSTRACT SYNTAX TREE:
24  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME INPUT4))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME INPUT4))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL INPUT4) KEY) KEY2)))) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) KEY2))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL KEY2))) (TOK_LIMIT 10)))
25
26STAGE DEPENDENCIES:
27  Stage-1 is a root stage
28  Stage-0 is a root stage
29
30STAGE PLANS:
31  Stage: Stage-1
32    Map Reduce
33      Alias -> Map Operator Tree:
34        a:input4 
35          TableScan
36            alias: input4
37            Select Operator
38              expressions:
39                    expr: key
40                    type: string
41              outputColumnNames: _col2
42              Select Operator
43                expressions:
44                      expr: _col2
45                      type: string
46                outputColumnNames: _col0
47                Reduce Output Operator
48                  key expressions:
49                        expr: _col0
50                        type: string
51                  sort order: +
52                  tag: -1
53                  value expressions:
54                        expr: _col0
55                        type: string
56      Reduce Operator Tree:
57        Extract
58          Limit
59            File Output Operator
60              compressed: false
61              GlobalTableId: 0
62              table:
63                  input format: org.apache.hadoop.mapred.TextInputFormat
64                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
65
66  Stage: Stage-0
67    Fetch Operator
68      limit: 10
69
70
71PREHOOK: query: SELECT a.KEY2
72FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
73      FROM INPUT4) a
74ORDER BY KEY2 LIMIT 10
75PREHOOK: type: QUERY
76PREHOOK: Input: default@input4
77PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-24_674_3065567534327682962/-mr-10000
78POSTHOOK: query: SELECT a.KEY2
79FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
80      FROM INPUT4) a
81ORDER BY KEY2 LIMIT 10
82POSTHOOK: type: QUERY
83POSTHOOK: Input: default@input4
84POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-24_674_3065567534327682962/-mr-10000
850
860
870
8810
89100
90100
91103
92103
93104
94104