PageRenderTime 22ms CodeModel.GetById 20ms app.highlight 0ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 62 lines | 57 code | 5 blank | 0 comment | 0 complexity | 610b3101e3195469678809e8430e96ed MD5 | raw file
 1PREHOOK: query: EXPLAIN
 2FROM src_thrift
 3SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
 4PREHOOK: type: QUERY
 5POSTHOOK: query: EXPLAIN
 6FROM src_thrift
 7SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
 8POSTHOOK: type: QUERY
 9ABSTRACT SYNTAX TREE:
10  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR ([ (. (TOK_TABLE_OR_COL src_thrift) mstringstring) 'key_9')) (TOK_SELEXPR (. (. (TOK_TABLE_OR_COL src_thrift) lintstring) myint)))))
11
12STAGE DEPENDENCIES:
13  Stage-1 is a root stage
14  Stage-0 is a root stage
15
16STAGE PLANS:
17  Stage: Stage-1
18    Map Reduce
19      Alias -> Map Operator Tree:
20        src_thrift 
21          TableScan
22            alias: src_thrift
23            Select Operator
24              expressions:
25                    expr: mstringstring['key_9']
26                    type: string
27                    expr: lintstring.myint
28                    type: array<int>
29              outputColumnNames: _col0, _col1
30              File Output Operator
31                compressed: false
32                GlobalTableId: 0
33                table:
34                    input format: org.apache.hadoop.mapred.TextInputFormat
35                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
36
37  Stage: Stage-0
38    Fetch Operator
39      limit: -1
40
41
42PREHOOK: query: FROM src_thrift
43SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
44PREHOOK: type: QUERY
45PREHOOK: Input: default@src_thrift
46PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-57_326_2264158676212177633/-mr-10000
47POSTHOOK: query: FROM src_thrift
48SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
49POSTHOOK: type: QUERY
50POSTHOOK: Input: default@src_thrift
51POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-57_326_2264158676212177633/-mr-10000
52NULL	[0]
53NULL	[1]
54NULL	[4]
55NULL	[9]
56NULL	[16]
57NULL	[25]
58NULL	[36]
59NULL	[49]
60NULL	[64]
61value_9	[81]
62NULL	null