PageRenderTime 4ms CodeModel.GetById 1ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 90 lines | 85 code | 5 blank | 0 comment | 0 complexity | 2d259f3cbee32673a7bf6a66650b6e48 MD5 | raw file
 1PREHOOK: query: CREATE TABLE src_null(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
 2PREHOOK: type: CREATETABLE
 3POSTHOOK: query: CREATE TABLE src_null(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
 4POSTHOOK: type: CREATETABLE
 5POSTHOOK: Output: default@src_null
 6PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/null.txt' INTO TABLE src_null
 7PREHOOK: type: LOAD
 8PREHOOK: Output: default@src_null
 9POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/null.txt' INTO TABLE src_null
10POSTHOOK: type: LOAD
11POSTHOOK: Output: default@src_null
12PREHOOK: query: EXPLAIN SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
13PREHOOK: type: QUERY
14POSTHOOK: query: EXPLAIN SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
15POSTHOOK: type: QUERY
16ABSTRACT SYNTAX TREE:
17  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_null))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL c)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL d)))))
18
19STAGE DEPENDENCIES:
20  Stage-1 is a root stage
21  Stage-0 is a root stage
22
23STAGE PLANS:
24  Stage: Stage-1
25    Map Reduce
26      Alias -> Map Operator Tree:
27        src_null 
28          TableScan
29            alias: src_null
30            Select Operator
31              expressions:
32                    expr: a
33                    type: string
34                    expr: b
35                    type: string
36                    expr: c
37                    type: string
38                    expr: d
39                    type: string
40              outputColumnNames: _col0, _col1, _col2, _col3
41              Reduce Output Operator
42                key expressions:
43                      expr: _col3
44                      type: string
45                sort order: +
46                Map-reduce partition columns:
47                      expr: _col2
48                      type: string
49                tag: -1
50                value expressions:
51                      expr: _col0
52                      type: string
53                      expr: _col1
54                      type: string
55                      expr: _col2
56                      type: string
57                      expr: _col3
58                      type: string
59      Reduce Operator Tree:
60        Extract
61          File Output Operator
62            compressed: false
63            GlobalTableId: 0
64            table:
65                input format: org.apache.hadoop.mapred.TextInputFormat
66                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
67
68  Stage: Stage-0
69    Fetch Operator
70      limit: -1
71
72
73PREHOOK: query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
74PREHOOK: type: QUERY
75PREHOOK: Input: default@src_null
76PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-43-04_093_3744625047385355137/-mr-10000
77POSTHOOK: query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
78POSTHOOK: type: QUERY
79POSTHOOK: Input: default@src_null
80POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-43-04_093_3744625047385355137/-mr-10000
811.0	1	same	0
821.0	1	same	1
831.0	1	same	2
841.0	1	same	3
851.0	1	same	4
86NULL	1	same	5
87NULL	NULL	same	6
881.0	NULL	same	7
891.0	1	same	8
901.0	1	same	9