PageRenderTime 31ms CodeModel.GetById 27ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 319 lines | 309 code | 10 blank | 0 comment | 0 complexity | 1fbcffdd268ff1c1b1dea8b68647780f MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest_j1(key STRING, value STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest_j1(key STRING, value STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest_j1
  6PREHOOK: query: EXPLAIN
  7INSERT OVERWRITE TABLE dest_j1 
  8SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
  9FROM
 10(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
 11 FROM src1 x JOIN src y ON (x.key = y.key)) subq
 12 JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
 13PREHOOK: type: QUERY
 14POSTHOOK: query: EXPLAIN
 15INSERT OVERWRITE TABLE dest_j1 
 16SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
 17FROM
 18(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
 19 FROM src1 x JOIN src y ON (x.key = y.key)) subq
 20 JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
 21POSTHOOK: type: QUERY
 22ABSTRACT SYNTAX TREE:
 23  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src1) x) (TOK_TABREF (TOK_TABNAME src) y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key) key1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value) value1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) key) key2) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value) value2)))) subq) (TOK_TABREF (TOK_TABNAME srcpart) z) (and (and (= (. (TOK_TABLE_OR_COL subq) key1) (. (TOK_TABLE_OR_COL z) key)) (= (. (TOK_TABLE_OR_COL z) ds) '2008-04-08')) (= (. (TOK_TABLE_OR_COL z) hr) 11)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest_j1))) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST z))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL subq) key1)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL z) value)))))
 24
 25STAGE DEPENDENCIES:
 26  Stage-8 is a root stage
 27  Stage-1 depends on stages: Stage-8
 28  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
 29  Stage-4
 30  Stage-0 depends on stages: Stage-4, Stage-3
 31  Stage-2 depends on stages: Stage-0
 32  Stage-3
 33
 34STAGE PLANS:
 35  Stage: Stage-8
 36    Map Reduce Local Work
 37      Alias -> Map Local Tables:
 38        subq:x 
 39          Fetch Operator
 40            limit: -1
 41        z 
 42          Fetch Operator
 43            limit: -1
 44      Alias -> Map Local Operator Tree:
 45        subq:x 
 46          TableScan
 47            alias: x
 48            HashTable Sink Operator
 49              condition expressions:
 50                0 {key}
 51                1 
 52              handleSkewJoin: false
 53              keys:
 54                0 [Column[key]]
 55                1 [Column[key]]
 56              Position of Big Table: 1
 57        z 
 58          TableScan
 59            alias: z
 60            Filter Operator
 61              predicate:
 62                  expr: (ds = '2008-04-08')
 63                  type: boolean
 64              Filter Operator
 65                predicate:
 66                    expr: (hr = 11)
 67                    type: boolean
 68                HashTable Sink Operator
 69                  condition expressions:
 70                    0 {_col0}
 71                    1 {value}
 72                  handleSkewJoin: false
 73                  keys:
 74                    0 [Column[_col0]]
 75                    1 [Column[key]]
 76                  Position of Big Table: 0
 77
 78  Stage: Stage-1
 79    Map Reduce
 80      Alias -> Map Operator Tree:
 81        subq:y 
 82          TableScan
 83            alias: y
 84            Map Join Operator
 85              condition map:
 86                   Inner Join 0 to 1
 87              condition expressions:
 88                0 {key}
 89                1 
 90              handleSkewJoin: false
 91              keys:
 92                0 [Column[key]]
 93                1 [Column[key]]
 94              outputColumnNames: _col0
 95              Position of Big Table: 1
 96              Select Operator
 97                expressions:
 98                      expr: _col0
 99                      type: string
100                outputColumnNames: _col0
101                Select Operator
102                  expressions:
103                        expr: _col0
104                        type: string
105                  outputColumnNames: _col0
106                  Map Join Operator
107                    condition map:
108                         Inner Join 0 to 1
109                    condition expressions:
110                      0 {_col0}
111                      1 {value}
112                    handleSkewJoin: false
113                    keys:
114                      0 [Column[_col0]]
115                      1 [Column[key]]
116                    outputColumnNames: _col0, _col5
117                    Position of Big Table: 0
118                    Select Operator
119                      expressions:
120                            expr: _col0
121                            type: string
122                            expr: _col5
123                            type: string
124                      outputColumnNames: _col0, _col5
125                      Select Operator
126                        expressions:
127                              expr: _col0
128                              type: string
129                              expr: _col5
130                              type: string
131                        outputColumnNames: _col0, _col1
132                        File Output Operator
133                          compressed: false
134                          GlobalTableId: 1
135                          table:
136                              input format: org.apache.hadoop.mapred.TextInputFormat
137                              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
138                              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
139                              name: default.dest_j1
140      Local Work:
141        Map Reduce Local Work
142
143  Stage: Stage-5
144    Conditional Operator
145
146  Stage: Stage-4
147    Move Operator
148      files:
149          hdfs directory: true
150          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-04-18_666_8729563590191203713/-ext-10000
151
152  Stage: Stage-0
153    Move Operator
154      tables:
155          replace: true
156          table:
157              input format: org.apache.hadoop.mapred.TextInputFormat
158              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
159              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
160              name: default.dest_j1
161
162  Stage: Stage-2
163    Stats-Aggr Operator
164
165  Stage: Stage-3
166    Map Reduce
167      Alias -> Map Operator Tree:
168        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-04-18_666_8729563590191203713/-ext-10002 
169            File Output Operator
170              compressed: false
171              GlobalTableId: 0
172              table:
173                  input format: org.apache.hadoop.mapred.TextInputFormat
174                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
175                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
176                  name: default.dest_j1
177
178
179PREHOOK: query: INSERT OVERWRITE TABLE dest_j1 
180SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
181FROM
182(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
183 FROM src1 x JOIN src y ON (x.key = y.key)) subq
184 JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
185PREHOOK: type: QUERY
186PREHOOK: Input: default@src
187PREHOOK: Input: default@src1
188PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
189PREHOOK: Output: default@dest_j1
190POSTHOOK: query: INSERT OVERWRITE TABLE dest_j1 
191SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
192FROM
193(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
194 FROM src1 x JOIN src y ON (x.key = y.key)) subq
195 JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
196POSTHOOK: type: QUERY
197POSTHOOK: Input: default@src
198POSTHOOK: Input: default@src1
199POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
200POSTHOOK: Output: default@dest_j1
201POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
202POSTHOOK: Lineage: dest_j1.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
203PREHOOK: query: select * from dest_j1 x order by x.key
204PREHOOK: type: QUERY
205PREHOOK: Input: default@dest_j1
206PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-04-25_901_2052252208804412968/-mr-10000
207POSTHOOK: query: select * from dest_j1 x order by x.key
208POSTHOOK: type: QUERY
209POSTHOOK: Input: default@dest_j1
210POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-04-25_901_2052252208804412968/-mr-10000
211POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
212POSTHOOK: Lineage: dest_j1.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
213128	val_128
214128	val_128
215128	val_128
216128	val_128
217128	val_128
218128	val_128
219128	val_128
220128	val_128
221128	val_128
222146	val_146
223146	val_146
224146	val_146
225146	val_146
226150	val_150
227213	val_213
228213	val_213
229213	val_213
230213	val_213
231224	val_224
232224	val_224
233224	val_224
234224	val_224
235238	val_238
236238	val_238
237238	val_238
238238	val_238
239255	val_255
240255	val_255
241255	val_255
242255	val_255
243273	val_273
244273	val_273
245273	val_273
246273	val_273
247273	val_273
248273	val_273
249273	val_273
250273	val_273
251273	val_273
252278	val_278
253278	val_278
254278	val_278
255278	val_278
256311	val_311
257311	val_311
258311	val_311
259311	val_311
260311	val_311
261311	val_311
262311	val_311
263311	val_311
264311	val_311
265369	val_369
266369	val_369
267369	val_369
268369	val_369
269369	val_369
270369	val_369
271369	val_369
272369	val_369
273369	val_369
274401	val_401
275401	val_401
276401	val_401
277401	val_401
278401	val_401
279401	val_401
280401	val_401
281401	val_401
282401	val_401
283401	val_401
284401	val_401
285401	val_401
286401	val_401
287401	val_401
288401	val_401
289401	val_401
290401	val_401
291401	val_401
292401	val_401
293401	val_401
294401	val_401
295401	val_401
296401	val_401
297401	val_401
298401	val_401
299406	val_406
300406	val_406
301406	val_406
302406	val_406
303406	val_406
304406	val_406
305406	val_406
306406	val_406
307406	val_406
308406	val_406
309406	val_406
310406	val_406
311406	val_406
312406	val_406
313406	val_406
314406	val_406
31566	val_66
31698	val_98
31798	val_98
31898	val_98
31998	val_98