PageRenderTime 24ms CodeModel.GetById 17ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 679 lines | 661 code | 18 blank | 0 comment | 0 complexity | c451144f7b23560b37da4a5df8a95daa MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: CREATE TABLE dest2(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE
  7PREHOOK: type: CREATETABLE
  8POSTHOOK: query: CREATE TABLE dest2(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE
  9POSTHOOK: type: CREATETABLE
 10POSTHOOK: Output: default@dest2
 11PREHOOK: query: EXPLAIN EXTENDED
 12FROM srcpart
 13INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
 14INSERT OVERWRITE TABLE dest2 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-09' and srcpart.hr = '12'
 15PREHOOK: type: QUERY
 16POSTHOOK: query: EXPLAIN EXTENDED
 17FROM srcpart
 18INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
 19INSERT OVERWRITE TABLE dest2 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-09' and srcpart.hr = '12'
 20POSTHOOK: type: QUERY
 21ABSTRACT SYNTAX TREE:
 22  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) hr)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) ds))) (TOK_WHERE (and (and (< (. (TOK_TABLE_OR_COL srcpart) key) 100) (= (. (TOK_TABLE_OR_COL srcpart) ds) '2008-04-08')) (= (. (TOK_TABLE_OR_COL srcpart) hr) '12')))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest2))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) hr)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) ds))) (TOK_WHERE (and (and (< (. (TOK_TABLE_OR_COL srcpart) key) 100) (= (. (TOK_TABLE_OR_COL srcpart) ds) '2008-04-09')) (= (. (TOK_TABLE_OR_COL srcpart) hr) '12')))))
 23
 24STAGE DEPENDENCIES:
 25  Stage-2 is a root stage
 26  Stage-6 depends on stages: Stage-2 , consists of Stage-5, Stage-4
 27  Stage-5
 28  Stage-0 depends on stages: Stage-5, Stage-4
 29  Stage-3 depends on stages: Stage-0
 30  Stage-4
 31  Stage-10 depends on stages: Stage-2 , consists of Stage-9, Stage-8
 32  Stage-9
 33  Stage-1 depends on stages: Stage-9, Stage-8
 34  Stage-7 depends on stages: Stage-1
 35  Stage-8
 36
 37STAGE PLANS:
 38  Stage: Stage-2
 39    Map Reduce
 40      Alias -> Map Operator Tree:
 41        srcpart 
 42          TableScan
 43            alias: srcpart
 44            GatherStats: false
 45            Filter Operator
 46              isSamplingPred: false
 47              predicate:
 48                  expr: ((key < 100) and (ds = '2008-04-08'))
 49                  type: boolean
 50              Select Operator
 51                expressions:
 52                      expr: key
 53                      type: string
 54                      expr: value
 55                      type: string
 56                      expr: hr
 57                      type: string
 58                      expr: ds
 59                      type: string
 60                outputColumnNames: _col0, _col1, _col2, _col3
 61                Select Operator
 62                  expressions:
 63                        expr: UDFToInteger(_col0)
 64                        type: int
 65                        expr: _col1
 66                        type: string
 67                        expr: _col2
 68                        type: string
 69                        expr: _col3
 70                        type: string
 71                  outputColumnNames: _col0, _col1, _col2, _col3
 72                  File Output Operator
 73                    compressed: false
 74                    GlobalTableId: 1
 75                    directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10004
 76                    NumFilesPerFileSink: 1
 77                    Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10000/
 78                    table:
 79                        input format: org.apache.hadoop.mapred.TextInputFormat
 80                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 81                        properties:
 82                          bucket_count -1
 83                          columns key,value,hr,ds
 84                          columns.types int:string:string:string
 85                          file.inputformat org.apache.hadoop.mapred.TextInputFormat
 86                          file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 87                          location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
 88                          name default.dest1
 89                          serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
 90                          serialization.format 1
 91                          serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 92                          transient_lastDdlTime 1297382404
 93                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 94                        name: default.dest1
 95                    TotalFiles: 1
 96                    GatherStats: true
 97                    MultiFileSpray: false
 98            Filter Operator
 99              isSamplingPred: false
100              predicate:
101                  expr: ((key < 100) and (ds = '2008-04-09'))
102                  type: boolean
103              Select Operator
104                expressions:
105                      expr: key
106                      type: string
107                      expr: value
108                      type: string
109                      expr: hr
110                      type: string
111                      expr: ds
112                      type: string
113                outputColumnNames: _col0, _col1, _col2, _col3
114                Select Operator
115                  expressions:
116                        expr: UDFToInteger(_col0)
117                        type: int
118                        expr: _col1
119                        type: string
120                        expr: _col2
121                        type: string
122                        expr: _col3
123                        type: string
124                  outputColumnNames: _col0, _col1, _col2, _col3
125                  File Output Operator
126                    compressed: false
127                    GlobalTableId: 2
128                    directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10005
129                    NumFilesPerFileSink: 1
130                    Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10002/
131                    table:
132                        input format: org.apache.hadoop.mapred.TextInputFormat
133                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
134                        properties:
135                          bucket_count -1
136                          columns key,value,hr,ds
137                          columns.types int:string:string:string
138                          file.inputformat org.apache.hadoop.mapred.TextInputFormat
139                          file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
140                          location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest2
141                          name default.dest2
142                          serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
143                          serialization.format 1
144                          serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
145                          transient_lastDdlTime 1297382405
146                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
147                        name: default.dest2
148                    TotalFiles: 1
149                    GatherStats: true
150                    MultiFileSpray: false
151      Needs Tagging: false
152      Path -> Alias:
153        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [srcpart]
154        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [srcpart]
155      Path -> Partition:
156        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
157          Partition
158            base file name: hr=12
159            input format: org.apache.hadoop.mapred.TextInputFormat
160            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
161            partition values:
162              ds 2008-04-08
163              hr 12
164            properties:
165              bucket_count -1
166              columns key,value
167              columns.types string:string
168              file.inputformat org.apache.hadoop.mapred.TextInputFormat
169              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
170              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
171              name default.srcpart
172              partition_columns ds/hr
173              serialization.ddl struct srcpart { string key, string value}
174              serialization.format 1
175              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
176              transient_lastDdlTime 1297378962
177            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
178          
179              input format: org.apache.hadoop.mapred.TextInputFormat
180              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
181              properties:
182                bucket_count -1
183                columns key,value
184                columns.types string:string
185                file.inputformat org.apache.hadoop.mapred.TextInputFormat
186                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
187                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
188                name default.srcpart
189                partition_columns ds/hr
190                serialization.ddl struct srcpart { string key, string value}
191                serialization.format 1
192                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
193                transient_lastDdlTime 1297378962
194              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
195              name: default.srcpart
196            name: default.srcpart
197        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
198          Partition
199            base file name: hr=12
200            input format: org.apache.hadoop.mapred.TextInputFormat
201            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
202            partition values:
203              ds 2008-04-09
204              hr 12
205            properties:
206              bucket_count -1
207              columns key,value
208              columns.types string:string
209              file.inputformat org.apache.hadoop.mapred.TextInputFormat
210              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
211              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
212              name default.srcpart
213              partition_columns ds/hr
214              serialization.ddl struct srcpart { string key, string value}
215              serialization.format 1
216              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
217              transient_lastDdlTime 1297378962
218            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
219          
220              input format: org.apache.hadoop.mapred.TextInputFormat
221              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
222              properties:
223                bucket_count -1
224                columns key,value
225                columns.types string:string
226                file.inputformat org.apache.hadoop.mapred.TextInputFormat
227                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
228                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
229                name default.srcpart
230                partition_columns ds/hr
231                serialization.ddl struct srcpart { string key, string value}
232                serialization.format 1
233                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
234                transient_lastDdlTime 1297378962
235              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
236              name: default.srcpart
237            name: default.srcpart
238
239  Stage: Stage-6
240    Conditional Operator
241
242  Stage: Stage-5
243    Move Operator
244      files:
245          hdfs directory: true
246          source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10004
247          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10000
248
249  Stage: Stage-0
250    Move Operator
251      tables:
252          replace: true
253          source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10000
254          table:
255              input format: org.apache.hadoop.mapred.TextInputFormat
256              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
257              properties:
258                bucket_count -1
259                columns key,value,hr,ds
260                columns.types int:string:string:string
261                file.inputformat org.apache.hadoop.mapred.TextInputFormat
262                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
263                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
264                name default.dest1
265                serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
266                serialization.format 1
267                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
268                transient_lastDdlTime 1297382404
269              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
270              name: default.dest1
271          tmp directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10001
272
273  Stage: Stage-3
274    Stats-Aggr Operator
275      Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10000/
276
277  Stage: Stage-4
278    Map Reduce
279      Alias -> Map Operator Tree:
280        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10004 
281            File Output Operator
282              compressed: false
283              GlobalTableId: 0
284              directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10000
285              NumFilesPerFileSink: 1
286              table:
287                  input format: org.apache.hadoop.mapred.TextInputFormat
288                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
289                  properties:
290                    bucket_count -1
291                    columns key,value,hr,ds
292                    columns.types int:string:string:string
293                    file.inputformat org.apache.hadoop.mapred.TextInputFormat
294                    file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
295                    location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
296                    name default.dest1
297                    serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
298                    serialization.format 1
299                    serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
300                    transient_lastDdlTime 1297382404
301                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
302                  name: default.dest1
303              TotalFiles: 1
304              GatherStats: false
305              MultiFileSpray: false
306      Needs Tagging: false
307      Path -> Alias:
308        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10004 [pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10004]
309      Path -> Partition:
310        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10004 
311          Partition
312            base file name: -ext-10004
313            input format: org.apache.hadoop.mapred.TextInputFormat
314            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
315            properties:
316              bucket_count -1
317              columns key,value,hr,ds
318              columns.types int:string:string:string
319              file.inputformat org.apache.hadoop.mapred.TextInputFormat
320              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
321              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
322              name default.dest1
323              serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
324              serialization.format 1
325              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
326              transient_lastDdlTime 1297382404
327            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
328          
329              input format: org.apache.hadoop.mapred.TextInputFormat
330              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
331              properties:
332                bucket_count -1
333                columns key,value,hr,ds
334                columns.types int:string:string:string
335                file.inputformat org.apache.hadoop.mapred.TextInputFormat
336                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
337                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
338                name default.dest1
339                serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
340                serialization.format 1
341                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
342                transient_lastDdlTime 1297382404
343              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
344              name: default.dest1
345            name: default.dest1
346
347  Stage: Stage-10
348    Conditional Operator
349
350  Stage: Stage-9
351    Move Operator
352      files:
353          hdfs directory: true
354          source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10005
355          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10002
356
357  Stage: Stage-1
358    Move Operator
359      tables:
360          replace: true
361          source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10002
362          table:
363              input format: org.apache.hadoop.mapred.TextInputFormat
364              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
365              properties:
366                bucket_count -1
367                columns key,value,hr,ds
368                columns.types int:string:string:string
369                file.inputformat org.apache.hadoop.mapred.TextInputFormat
370                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
371                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest2
372                name default.dest2
373                serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
374                serialization.format 1
375                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
376                transient_lastDdlTime 1297382405
377              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
378              name: default.dest2
379          tmp directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10003
380
381  Stage: Stage-7
382    Stats-Aggr Operator
383      Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10002/
384
385  Stage: Stage-8
386    Map Reduce
387      Alias -> Map Operator Tree:
388        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10005 
389            File Output Operator
390              compressed: false
391              GlobalTableId: 0
392              directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10002
393              NumFilesPerFileSink: 1
394              table:
395                  input format: org.apache.hadoop.mapred.TextInputFormat
396                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
397                  properties:
398                    bucket_count -1
399                    columns key,value,hr,ds
400                    columns.types int:string:string:string
401                    file.inputformat org.apache.hadoop.mapred.TextInputFormat
402                    file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
403                    location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest2
404                    name default.dest2
405                    serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
406                    serialization.format 1
407                    serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
408                    transient_lastDdlTime 1297382405
409                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
410                  name: default.dest2
411              TotalFiles: 1
412              GatherStats: false
413              MultiFileSpray: false
414      Needs Tagging: false
415      Path -> Alias:
416        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10005 [pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10005]
417      Path -> Partition:
418        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-05_023_1537140141661907802/-ext-10005 
419          Partition
420            base file name: -ext-10005
421            input format: org.apache.hadoop.mapred.TextInputFormat
422            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
423            properties:
424              bucket_count -1
425              columns key,value,hr,ds
426              columns.types int:string:string:string
427              file.inputformat org.apache.hadoop.mapred.TextInputFormat
428              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
429              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest2
430              name default.dest2
431              serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
432              serialization.format 1
433              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
434              transient_lastDdlTime 1297382405
435            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
436          
437              input format: org.apache.hadoop.mapred.TextInputFormat
438              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
439              properties:
440                bucket_count -1
441                columns key,value,hr,ds
442                columns.types int:string:string:string
443                file.inputformat org.apache.hadoop.mapred.TextInputFormat
444                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
445                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest2
446                name default.dest2
447                serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
448                serialization.format 1
449                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
450                transient_lastDdlTime 1297382405
451              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
452              name: default.dest2
453            name: default.dest2
454
455
456PREHOOK: query: FROM srcpart
457INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
458INSERT OVERWRITE TABLE dest2 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-09' and srcpart.hr = '12'
459PREHOOK: type: QUERY
460PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
461PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
462PREHOOK: Output: default@dest1
463PREHOOK: Output: default@dest2
464POSTHOOK: query: FROM srcpart
465INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
466INSERT OVERWRITE TABLE dest2 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-09' and srcpart.hr = '12'
467POSTHOOK: type: QUERY
468POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
469POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
470POSTHOOK: Output: default@dest1
471POSTHOOK: Output: default@dest2
472POSTHOOK: Lineage: dest1.ds SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
473POSTHOOK: Lineage: dest1.hr SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
474POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
475POSTHOOK: Lineage: dest1.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
476POSTHOOK: Lineage: dest2.ds SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
477POSTHOOK: Lineage: dest2.hr SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
478POSTHOOK: Lineage: dest2.key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
479POSTHOOK: Lineage: dest2.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
480PREHOOK: query: SELECT dest1.* FROM dest1 sort by key,value,ds,hr
481PREHOOK: type: QUERY
482PREHOOK: Input: default@dest1
483PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-10_653_4229789556290312284/-mr-10000
484POSTHOOK: query: SELECT dest1.* FROM dest1 sort by key,value,ds,hr
485POSTHOOK: type: QUERY
486POSTHOOK: Input: default@dest1
487POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-10_653_4229789556290312284/-mr-10000
488POSTHOOK: Lineage: dest1.ds SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
489POSTHOOK: Lineage: dest1.hr SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
490POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
491POSTHOOK: Lineage: dest1.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
492POSTHOOK: Lineage: dest2.ds SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
493POSTHOOK: Lineage: dest2.hr SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
494POSTHOOK: Lineage: dest2.key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
495POSTHOOK: Lineage: dest2.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
4960	val_0	12	2008-04-08
4970	val_0	12	2008-04-08
4980	val_0	12	2008-04-08
4992	val_2	12	2008-04-08
5004	val_4	12	2008-04-08
5015	val_5	12	2008-04-08
5025	val_5	12	2008-04-08
5035	val_5	12	2008-04-08
5048	val_8	12	2008-04-08
5059	val_9	12	2008-04-08
50610	val_10	12	2008-04-08
50711	val_11	12	2008-04-08
50812	val_12	12	2008-04-08
50912	val_12	12	2008-04-08
51015	val_15	12	2008-04-08
51115	val_15	12	2008-04-08
51217	val_17	12	2008-04-08
51318	val_18	12	2008-04-08
51418	val_18	12	2008-04-08
51519	val_19	12	2008-04-08
51620	val_20	12	2008-04-08
51724	val_24	12	2008-04-08
51824	val_24	12	2008-04-08
51926	val_26	12	2008-04-08
52026	val_26	12	2008-04-08
52127	val_27	12	2008-04-08
52228	val_28	12	2008-04-08
52330	val_30	12	2008-04-08
52433	val_33	12	2008-04-08
52534	val_34	12	2008-04-08
52635	val_35	12	2008-04-08
52735	val_35	12	2008-04-08
52835	val_35	12	2008-04-08
52937	val_37	12	2008-04-08
53037	val_37	12	2008-04-08
53141	val_41	12	2008-04-08
53242	val_42	12	2008-04-08
53342	val_42	12	2008-04-08
53443	val_43	12	2008-04-08
53544	val_44	12	2008-04-08
53647	val_47	12	2008-04-08
53751	val_51	12	2008-04-08
53851	val_51	12	2008-04-08
53953	val_53	12	2008-04-08
54054	val_54	12	2008-04-08
54157	val_57	12	2008-04-08
54258	val_58	12	2008-04-08
54358	val_58	12	2008-04-08
54464	val_64	12	2008-04-08
54565	val_65	12	2008-04-08
54666	val_66	12	2008-04-08
54767	val_67	12	2008-04-08
54867	val_67	12	2008-04-08
54969	val_69	12	2008-04-08
55070	val_70	12	2008-04-08
55170	val_70	12	2008-04-08
55270	val_70	12	2008-04-08
55372	val_72	12	2008-04-08
55472	val_72	12	2008-04-08
55574	val_74	12	2008-04-08
55676	val_76	12	2008-04-08
55776	val_76	12	2008-04-08
55877	val_77	12	2008-04-08
55978	val_78	12	2008-04-08
56080	val_80	12	2008-04-08
56182	val_82	12	2008-04-08
56283	val_83	12	2008-04-08
56383	val_83	12	2008-04-08
56484	val_84	12	2008-04-08
56584	val_84	12	2008-04-08
56685	val_85	12	2008-04-08
56786	val_86	12	2008-04-08
56887	val_87	12	2008-04-08
56990	val_90	12	2008-04-08
57090	val_90	12	2008-04-08
57190	val_90	12	2008-04-08
57292	val_92	12	2008-04-08
57395	val_95	12	2008-04-08
57495	val_95	12	2008-04-08
57596	val_96	12	2008-04-08
57697	val_97	12	2008-04-08
57797	val_97	12	2008-04-08
57898	val_98	12	2008-04-08
57998	val_98	12	2008-04-08
580PREHOOK: query: SELECT dest2.* FROM dest2 sort by key,value,ds,hr
581PREHOOK: type: QUERY
582PREHOOK: Input: default@dest2
583PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-14_023_1517441038636828372/-mr-10000
584POSTHOOK: query: SELECT dest2.* FROM dest2 sort by key,value,ds,hr
585POSTHOOK: type: QUERY
586POSTHOOK: Input: default@dest2
587POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-14_023_1517441038636828372/-mr-10000
588POSTHOOK: Lineage: dest1.ds SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
589POSTHOOK: Lineage: dest1.hr SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
590POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
591POSTHOOK: Lineage: dest1.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
592POSTHOOK: Lineage: dest2.ds SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ]
593POSTHOOK: Lineage: dest2.hr SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ]
594POSTHOOK: Lineage: dest2.key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
595POSTHOOK: Lineage: dest2.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
5960	val_0	12	2008-04-09
5970	val_0	12	2008-04-09
5980	val_0	12	2008-04-09
5992	val_2	12	2008-04-09
6004	val_4	12	2008-04-09
6015	val_5	12	2008-04-09
6025	val_5	12	2008-04-09
6035	val_5	12	2008-04-09
6048	val_8	12	2008-04-09
6059	val_9	12	2008-04-09
60610	val_10	12	2008-04-09
60711	val_11	12	2008-04-09
60812	val_12	12	2008-04-09
60912	val_12	12	2008-04-09
61015	val_15	12	2008-04-09
61115	val_15	12	2008-04-09
61217	val_17	12	2008-04-09
61318	val_18	12	2008-04-09
61418	val_18	12	2008-04-09
61519	val_19	12	2008-04-09
61620	val_20	12	2008-04-09
61724	val_24	12	2008-04-09
61824	val_24	12	2008-04-09
61926	val_26	12	2008-04-09
62026	val_26	12	2008-04-09
62127	val_27	12	2008-04-09
62228	val_28	12	2008-04-09
62330	val_30	12	2008-04-09
62433	val_33	12	2008-04-09
62534	val_34	12	2008-04-09
62635	val_35	12	2008-04-09
62735	val_35	12	2008-04-09
62835	val_35	12	2008-04-09
62937	val_37	12	2008-04-09
63037	val_37	12	2008-04-09
63141	val_41	12	2008-04-09
63242	val_42	12	2008-04-09
63342	val_42	12	2008-04-09
63443	val_43	12	2008-04-09
63544	val_44	12	2008-04-09
63647	val_47	12	2008-04-09
63751	val_51	12	2008-04-09
63851	val_51	12	2008-04-09
63953	val_53	12	2008-04-09
64054	val_54	12	2008-04-09
64157	val_57	12	2008-04-09
64258	val_58	12	2008-04-09
64358	val_58	12	2008-04-09
64464	val_64	12	2008-04-09
64565	val_65	12	2008-04-09
64666	val_66	12	2008-04-09
64767	val_67	12	2008-04-09
64867	val_67	12	2008-04-09
64969	val_69	12	2008-04-09
65070	val_70	12	2008-04-09
65170	val_70	12	2008-04-09
65270	val_70	12	2008-04-09
65372	val_72	12	2008-04-09
65472	val_72	12	2008-04-09
65574	val_74	12	2008-04-09
65676	val_76	12	2008-04-09
65776	val_76	12	2008-04-09
65877	val_77	12	2008-04-09
65978	val_78	12	2008-04-09
66080	val_80	12	2008-04-09
66182	val_82	12	2008-04-09
66283	val_83	12	2008-04-09
66383	val_83	12	2008-04-09
66484	val_84	12	2008-04-09
66584	val_84	12	2008-04-09
66685	val_85	12	2008-04-09
66786	val_86	12	2008-04-09
66887	val_87	12	2008-04-09
66990	val_90	12	2008-04-09
67090	val_90	12	2008-04-09
67190	val_90	12	2008-04-09
67292	val_92	12	2008-04-09
67395	val_95	12	2008-04-09
67495	val_95	12	2008-04-09
67596	val_96	12	2008-04-09
67697	val_97	12	2008-04-09
67797	val_97	12	2008-04-09
67898	val_98	12	2008-04-09
67998	val_98	12	2008-04-09