PageRenderTime 28ms CodeModel.GetById 24ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 186 lines | 179 code | 7 blank | 0 comment | 0 complexity | 5c9175917d151f629ad4fc6258a086d2 MD5 | raw file
  1PREHOOK: query: explain
  2select * from (
  3  select * from srcpart a where a.ds = '2008-04-08' and a.hr = '11' order by a.key limit 5
  4    union all
  5  select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
  6)subq
  7PREHOOK: type: QUERY
  8POSTHOOK: query: explain
  9select * from (
 10  select * from srcpart a where a.ds = '2008-04-08' and a.hr = '11' order by a.key limit 5
 11    union all
 12  select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
 13)subq
 14POSTHOOK: type: QUERY
 15ABSTRACT SYNTAX TREE:
 16  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL a) hr) '11'))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key))) (TOK_LIMIT 5))) (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart) b)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL b) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL b) hr) '14'))) (TOK_LIMIT 5)))) subq)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
 17
 18STAGE DEPENDENCIES:
 19  Stage-1 is a root stage
 20  Stage-2 depends on stages: Stage-1, Stage-3
 21  Stage-3 is a root stage
 22  Stage-0 is a root stage
 23
 24STAGE PLANS:
 25  Stage: Stage-1
 26    Map Reduce
 27      Alias -> Map Operator Tree:
 28        null-subquery1:subq-subquery1:a 
 29          TableScan
 30            alias: a
 31            Filter Operator
 32              predicate:
 33                  expr: ((ds = '2008-04-08') and (hr = '11'))
 34                  type: boolean
 35              Select Operator
 36                expressions:
 37                      expr: key
 38                      type: string
 39                      expr: value
 40                      type: string
 41                      expr: ds
 42                      type: string
 43                      expr: hr
 44                      type: string
 45                outputColumnNames: _col0, _col1, _col2, _col3
 46                Reduce Output Operator
 47                  key expressions:
 48                        expr: _col0
 49                        type: string
 50                  sort order: +
 51                  tag: -1
 52                  value expressions:
 53                        expr: _col0
 54                        type: string
 55                        expr: _col1
 56                        type: string
 57                        expr: _col2
 58                        type: string
 59                        expr: _col3
 60                        type: string
 61      Reduce Operator Tree:
 62        Extract
 63          Limit
 64            File Output Operator
 65              compressed: false
 66              GlobalTableId: 0
 67              table:
 68                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
 69                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
 70
 71  Stage: Stage-2
 72    Map Reduce
 73      Alias -> Map Operator Tree:
 74        file:/tmp/sdong/hive_2011-02-10_15-54-47_775_6322428928723831214/-mr-10002 
 75          Union
 76            Select Operator
 77              expressions:
 78                    expr: _col0
 79                    type: string
 80                    expr: _col1
 81                    type: string
 82                    expr: _col2
 83                    type: string
 84                    expr: _col3
 85                    type: string
 86              outputColumnNames: _col0, _col1, _col2, _col3
 87              File Output Operator
 88                compressed: false
 89                GlobalTableId: 0
 90                table:
 91                    input format: org.apache.hadoop.mapred.TextInputFormat
 92                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 93        file:/tmp/sdong/hive_2011-02-10_15-54-47_775_6322428928723831214/-mr-10003 
 94          Union
 95            Select Operator
 96              expressions:
 97                    expr: _col0
 98                    type: string
 99                    expr: _col1
100                    type: string
101                    expr: _col2
102                    type: string
103                    expr: _col3
104                    type: string
105              outputColumnNames: _col0, _col1, _col2, _col3
106              File Output Operator
107                compressed: false
108                GlobalTableId: 0
109                table:
110                    input format: org.apache.hadoop.mapred.TextInputFormat
111                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
112
113  Stage: Stage-3
114    Map Reduce
115      Alias -> Map Operator Tree:
116        null-subquery2:subq-subquery2:b 
117          TableScan
118            alias: b
119            Filter Operator
120              predicate:
121                  expr: ((ds = '2008-04-08') and (hr = '14'))
122                  type: boolean
123              Filter Operator
124                predicate:
125                    expr: ((ds = '2008-04-08') and (hr = '14'))
126                    type: boolean
127                Select Operator
128                  expressions:
129                        expr: key
130                        type: string
131                        expr: value
132                        type: string
133                        expr: ds
134                        type: string
135                        expr: hr
136                        type: string
137                  outputColumnNames: _col0, _col1, _col2, _col3
138                  Limit
139                    Reduce Output Operator
140                      sort order: 
141                      tag: -1
142                      value expressions:
143                            expr: _col0
144                            type: string
145                            expr: _col1
146                            type: string
147                            expr: _col2
148                            type: string
149                            expr: _col3
150                            type: string
151      Reduce Operator Tree:
152        Extract
153          Limit
154            File Output Operator
155              compressed: false
156              GlobalTableId: 0
157              table:
158                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
159                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
160
161  Stage: Stage-0
162    Fetch Operator
163      limit: -1
164
165
166PREHOOK: query: select * from (
167  select * from srcpart a where a.ds = '2008-04-08' and a.hr = '11' order by a.key limit 5
168    union all
169  select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
170)subq
171PREHOOK: type: QUERY
172PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
173PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-47_937_1412967694655761034/-mr-10000
174POSTHOOK: query: select * from (
175  select * from srcpart a where a.ds = '2008-04-08' and a.hr = '11' order by a.key limit 5
176    union all
177  select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
178)subq
179POSTHOOK: type: QUERY
180POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
181POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-47_937_1412967694655761034/-mr-10000
1820	val_0	2008-04-08	11
1830	val_0	2008-04-08	11
1840	val_0	2008-04-08	11
18510	val_10	2008-04-08	11
186100	val_100	2008-04-08	11