PageRenderTime 27ms CodeModel.GetById 12ms app.highlight 7ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 790 lines | 779 code | 11 blank | 0 comment | 0 complexity | 74841d6850fd640660a63542cfc00e58 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT, value STRING, dt STRING, hr STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING, dt STRING, hr STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: -- no input pruning, no sample filter
  7EXPLAIN EXTENDED
  8INSERT OVERWRITE TABLE dest1 SELECT s.*
  9FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
 10WHERE s.ds='2008-04-08' and s.hr='11'
 11PREHOOK: type: QUERY
 12POSTHOOK: query: -- no input pruning, no sample filter
 13EXPLAIN EXTENDED
 14INSERT OVERWRITE TABLE dest1 SELECT s.*
 15FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
 16WHERE s.ds='2008-04-08' and s.hr='11'
 17POSTHOOK: type: QUERY
 18ABSTRACT SYNTAX TREE:
 19  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart) (TOK_TABLESAMPLE 1 1 (TOK_FUNCTION rand)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME s)))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL s) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL s) hr) '11')))))
 20
 21STAGE DEPENDENCIES:
 22  Stage-1 is a root stage
 23  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
 24  Stage-4
 25  Stage-0 depends on stages: Stage-4, Stage-3
 26  Stage-2 depends on stages: Stage-0
 27  Stage-3
 28
 29STAGE PLANS:
 30  Stage: Stage-1
 31    Map Reduce
 32      Alias -> Map Operator Tree:
 33        s 
 34          TableScan
 35            alias: s
 36            GatherStats: false
 37            Filter Operator
 38              isSamplingPred: true
 39              predicate:
 40                  expr: (((hash(rand()) & 2147483647) % 1) = 0)
 41                  type: boolean
 42              Filter Operator
 43                isSamplingPred: false
 44                predicate:
 45                    expr: ((ds = '2008-04-08') and (hr = '11'))
 46                    type: boolean
 47                Select Operator
 48                  expressions:
 49                        expr: key
 50                        type: string
 51                        expr: value
 52                        type: string
 53                        expr: ds
 54                        type: string
 55                        expr: hr
 56                        type: string
 57                  outputColumnNames: _col0, _col1, _col2, _col3
 58                  Select Operator
 59                    expressions:
 60                          expr: UDFToInteger(_col0)
 61                          type: int
 62                          expr: _col1
 63                          type: string
 64                          expr: _col2
 65                          type: string
 66                          expr: _col3
 67                          type: string
 68                    outputColumnNames: _col0, _col1, _col2, _col3
 69                    File Output Operator
 70                      compressed: false
 71                      GlobalTableId: 1
 72                      directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002
 73                      NumFilesPerFileSink: 1
 74                      Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000/
 75                      table:
 76                          input format: org.apache.hadoop.mapred.TextInputFormat
 77                          output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 78                          properties:
 79                            bucket_count -1
 80                            columns key,value,dt,hr
 81                            columns.types int:string:string:string
 82                            file.inputformat org.apache.hadoop.mapred.TextInputFormat
 83                            file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 84                            location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
 85                            name default.dest1
 86                            serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
 87                            serialization.format 1
 88                            serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 89                            transient_lastDdlTime 1297386131
 90                          serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 91                          name: default.dest1
 92                      TotalFiles: 1
 93                      GatherStats: true
 94                      MultiFileSpray: false
 95      Needs Tagging: false
 96      Path -> Alias:
 97        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [s]
 98      Path -> Partition:
 99        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
100          Partition
101            base file name: hr=11
102            input format: org.apache.hadoop.mapred.TextInputFormat
103            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
104            partition values:
105              ds 2008-04-08
106              hr 11
107            properties:
108              bucket_count -1
109              columns key,value
110              columns.types string:string
111              file.inputformat org.apache.hadoop.mapred.TextInputFormat
112              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
113              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
114              name default.srcpart
115              partition_columns ds/hr
116              serialization.ddl struct srcpart { string key, string value}
117              serialization.format 1
118              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
119              transient_lastDdlTime 1297378962
120            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
121          
122              input format: org.apache.hadoop.mapred.TextInputFormat
123              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
124              properties:
125                bucket_count -1
126                columns key,value
127                columns.types string:string
128                file.inputformat org.apache.hadoop.mapred.TextInputFormat
129                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
130                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
131                name default.srcpart
132                partition_columns ds/hr
133                serialization.ddl struct srcpart { string key, string value}
134                serialization.format 1
135                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
136                transient_lastDdlTime 1297378962
137              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
138              name: default.srcpart
139            name: default.srcpart
140
141  Stage: Stage-5
142    Conditional Operator
143
144  Stage: Stage-4
145    Move Operator
146      files:
147          hdfs directory: true
148          source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002
149          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000
150
151  Stage: Stage-0
152    Move Operator
153      tables:
154          replace: true
155          source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000
156          table:
157              input format: org.apache.hadoop.mapred.TextInputFormat
158              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
159              properties:
160                bucket_count -1
161                columns key,value,dt,hr
162                columns.types int:string:string:string
163                file.inputformat org.apache.hadoop.mapred.TextInputFormat
164                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
165                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
166                name default.dest1
167                serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
168                serialization.format 1
169                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
170                transient_lastDdlTime 1297386131
171              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
172              name: default.dest1
173          tmp directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10001
174
175  Stage: Stage-2
176    Stats-Aggr Operator
177      Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000/
178
179  Stage: Stage-3
180    Map Reduce
181      Alias -> Map Operator Tree:
182        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002 
183            File Output Operator
184              compressed: false
185              GlobalTableId: 0
186              directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10000
187              NumFilesPerFileSink: 1
188              table:
189                  input format: org.apache.hadoop.mapred.TextInputFormat
190                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
191                  properties:
192                    bucket_count -1
193                    columns key,value,dt,hr
194                    columns.types int:string:string:string
195                    file.inputformat org.apache.hadoop.mapred.TextInputFormat
196                    file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
197                    location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
198                    name default.dest1
199                    serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
200                    serialization.format 1
201                    serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
202                    transient_lastDdlTime 1297386131
203                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
204                  name: default.dest1
205              TotalFiles: 1
206              GatherStats: false
207              MultiFileSpray: false
208      Needs Tagging: false
209      Path -> Alias:
210        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002 [pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002]
211      Path -> Partition:
212        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_17-02-11_295_7558736421237835141/-ext-10002 
213          Partition
214            base file name: -ext-10002
215            input format: org.apache.hadoop.mapred.TextInputFormat
216            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
217            properties:
218              bucket_count -1
219              columns key,value,dt,hr
220              columns.types int:string:string:string
221              file.inputformat org.apache.hadoop.mapred.TextInputFormat
222              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
223              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
224              name default.dest1
225              serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
226              serialization.format 1
227              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
228              transient_lastDdlTime 1297386131
229            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
230          
231              input format: org.apache.hadoop.mapred.TextInputFormat
232              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
233              properties:
234                bucket_count -1
235                columns key,value,dt,hr
236                columns.types int:string:string:string
237                file.inputformat org.apache.hadoop.mapred.TextInputFormat
238                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
239                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1
240                name default.dest1
241                serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
242                serialization.format 1
243                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
244                transient_lastDdlTime 1297386131
245              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
246              name: default.dest1
247            name: default.dest1
248
249
250PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
251FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
252WHERE s.ds='2008-04-08' and s.hr='11'
253PREHOOK: type: QUERY
254PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
255PREHOOK: Output: default@dest1
256POSTHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
257FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON rand()) s
258WHERE s.ds='2008-04-08' and s.hr='11'
259POSTHOOK: type: QUERY
260POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
261POSTHOOK: Output: default@dest1
262POSTHOOK: Lineage: dest1.dt SIMPLE [(srcpart)s.FieldSchema(name:ds, type:string, comment:null), ]
263POSTHOOK: Lineage: dest1.hr SIMPLE [(srcpart)s.FieldSchema(name:hr, type:string, comment:null), ]
264POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)s.FieldSchema(name:key, type:string, comment:default), ]
265POSTHOOK: Lineage: dest1.value SIMPLE [(srcpart)s.FieldSchema(name:value, type:string, comment:default), ]
266PREHOOK: query: SELECT dest1.* FROM dest1
267PREHOOK: type: QUERY
268PREHOOK: Input: default@dest1
269PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-16_189_533486943106456838/-mr-10000
270POSTHOOK: query: SELECT dest1.* FROM dest1
271POSTHOOK: type: QUERY
272POSTHOOK: Input: default@dest1
273POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-16_189_533486943106456838/-mr-10000
274POSTHOOK: Lineage: dest1.dt SIMPLE [(srcpart)s.FieldSchema(name:ds, type:string, comment:null), ]
275POSTHOOK: Lineage: dest1.hr SIMPLE [(srcpart)s.FieldSchema(name:hr, type:string, comment:null), ]
276POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)s.FieldSchema(name:key, type:string, comment:default), ]
277POSTHOOK: Lineage: dest1.value SIMPLE [(srcpart)s.FieldSchema(name:value, type:string, comment:default), ]
278238	val_238	2008-04-08	11
27986	val_86	2008-04-08	11
280311	val_311	2008-04-08	11
28127	val_27	2008-04-08	11
282165	val_165	2008-04-08	11
283409	val_409	2008-04-08	11
284255	val_255	2008-04-08	11
285278	val_278	2008-04-08	11
28698	val_98	2008-04-08	11
287484	val_484	2008-04-08	11
288265	val_265	2008-04-08	11
289193	val_193	2008-04-08	11
290401	val_401	2008-04-08	11
291150	val_150	2008-04-08	11
292273	val_273	2008-04-08	11
293224	val_224	2008-04-08	11
294369	val_369	2008-04-08	11
29566	val_66	2008-04-08	11
296128	val_128	2008-04-08	11
297213	val_213	2008-04-08	11
298146	val_146	2008-04-08	11
299406	val_406	2008-04-08	11
300429	val_429	2008-04-08	11
301374	val_374	2008-04-08	11
302152	val_152	2008-04-08	11
303469	val_469	2008-04-08	11
304145	val_145	2008-04-08	11
305495	val_495	2008-04-08	11
30637	val_37	2008-04-08	11
307327	val_327	2008-04-08	11
308281	val_281	2008-04-08	11
309277	val_277	2008-04-08	11
310209	val_209	2008-04-08	11
31115	val_15	2008-04-08	11
31282	val_82	2008-04-08	11
313403	val_403	2008-04-08	11
314166	val_166	2008-04-08	11
315417	val_417	2008-04-08	11
316430	val_430	2008-04-08	11
317252	val_252	2008-04-08	11
318292	val_292	2008-04-08	11
319219	val_219	2008-04-08	11
320287	val_287	2008-04-08	11
321153	val_153	2008-04-08	11
322193	val_193	2008-04-08	11
323338	val_338	2008-04-08	11
324446	val_446	2008-04-08	11
325459	val_459	2008-04-08	11
326394	val_394	2008-04-08	11
327237	val_237	2008-04-08	11
328482	val_482	2008-04-08	11
329174	val_174	2008-04-08	11
330413	val_413	2008-04-08	11
331494	val_494	2008-04-08	11
332207	val_207	2008-04-08	11
333199	val_199	2008-04-08	11
334466	val_466	2008-04-08	11
335208	val_208	2008-04-08	11
336174	val_174	2008-04-08	11
337399	val_399	2008-04-08	11
338396	val_396	2008-04-08	11
339247	val_247	2008-04-08	11
340417	val_417	2008-04-08	11
341489	val_489	2008-04-08	11
342162	val_162	2008-04-08	11
343377	val_377	2008-04-08	11
344397	val_397	2008-04-08	11
345309	val_309	2008-04-08	11
346365	val_365	2008-04-08	11
347266	val_266	2008-04-08	11
348439	val_439	2008-04-08	11
349342	val_342	2008-04-08	11
350367	val_367	2008-04-08	11
351325	val_325	2008-04-08	11
352167	val_167	2008-04-08	11
353195	val_195	2008-04-08	11
354475	val_475	2008-04-08	11
35517	val_17	2008-04-08	11
356113	val_113	2008-04-08	11
357155	val_155	2008-04-08	11
358203	val_203	2008-04-08	11
359339	val_339	2008-04-08	11
3600	val_0	2008-04-08	11
361455	val_455	2008-04-08	11
362128	val_128	2008-04-08	11
363311	val_311	2008-04-08	11
364316	val_316	2008-04-08	11
36557	val_57	2008-04-08	11
366302	val_302	2008-04-08	11
367205	val_205	2008-04-08	11
368149	val_149	2008-04-08	11
369438	val_438	2008-04-08	11
370345	val_345	2008-04-08	11
371129	val_129	2008-04-08	11
372170	val_170	2008-04-08	11
37320	val_20	2008-04-08	11
374489	val_489	2008-04-08	11
375157	val_157	2008-04-08	11
376378	val_378	2008-04-08	11
377221	val_221	2008-04-08	11
37892	val_92	2008-04-08	11
379111	val_111	2008-04-08	11
38047	val_47	2008-04-08	11
38172	val_72	2008-04-08	11
3824	val_4	2008-04-08	11
383280	val_280	2008-04-08	11
38435	val_35	2008-04-08	11
385427	val_427	2008-04-08	11
386277	val_277	2008-04-08	11
387208	val_208	2008-04-08	11
388356	val_356	2008-04-08	11
389399	val_399	2008-04-08	11
390169	val_169	2008-04-08	11
391382	val_382	2008-04-08	11
392498	val_498	2008-04-08	11
393125	val_125	2008-04-08	11
394386	val_386	2008-04-08	11
395437	val_437	2008-04-08	11
396469	val_469	2008-04-08	11
397192	val_192	2008-04-08	11
398286	val_286	2008-04-08	11
399187	val_187	2008-04-08	11
400176	val_176	2008-04-08	11
40154	val_54	2008-04-08	11
402459	val_459	2008-04-08	11
40351	val_51	2008-04-08	11
404138	val_138	2008-04-08	11
405103	val_103	2008-04-08	11
406239	val_239	2008-04-08	11
407213	val_213	2008-04-08	11
408216	val_216	2008-04-08	11
409430	val_430	2008-04-08	11
410278	val_278	2008-04-08	11
411176	val_176	2008-04-08	11
412289	val_289	2008-04-08	11
413221	val_221	2008-04-08	11
41465	val_65	2008-04-08	11
415318	val_318	2008-04-08	11
416332	val_332	2008-04-08	11
417311	val_311	2008-04-08	11
418275	val_275	2008-04-08	11
419137	val_137	2008-04-08	11
420241	val_241	2008-04-08	11
42183	val_83	2008-04-08	11
422333	val_333	2008-04-08	11
423180	val_180	2008-04-08	11
424284	val_284	2008-04-08	11
42512	val_12	2008-04-08	11
426230	val_230	2008-04-08	11
427181	val_181	2008-04-08	11
42867	val_67	2008-04-08	11
429260	val_260	2008-04-08	11
430404	val_404	2008-04-08	11
431384	val_384	2008-04-08	11
432489	val_489	2008-04-08	11
433353	val_353	2008-04-08	11
434373	val_373	2008-04-08	11
435272	val_272	2008-04-08	11
436138	val_138	2008-04-08	11
437217	val_217	2008-04-08	11
43884	val_84	2008-04-08	11
439348	val_348	2008-04-08	11
440466	val_466	2008-04-08	11
44158	val_58	2008-04-08	11
4428	val_8	2008-04-08	11
443411	val_411	2008-04-08	11
444230	val_230	2008-04-08	11
445208	val_208	2008-04-08	11
446348	val_348	2008-04-08	11
44724	val_24	2008-04-08	11
448463	val_463	2008-04-08	11
449431	val_431	2008-04-08	11
450179	val_179	2008-04-08	11
451172	val_172	2008-04-08	11
45242	val_42	2008-04-08	11
453129	val_129	2008-04-08	11
454158	val_158	2008-04-08	11
455119	val_119	2008-04-08	11
456496	val_496	2008-04-08	11
4570	val_0	2008-04-08	11
458322	val_322	2008-04-08	11
459197	val_197	2008-04-08	11
460468	val_468	2008-04-08	11
461393	val_393	2008-04-08	11
462454	val_454	2008-04-08	11
463100	val_100	2008-04-08	11
464298	val_298	2008-04-08	11
465199	val_199	2008-04-08	11
466191	val_191	2008-04-08	11
467418	val_418	2008-04-08	11
46896	val_96	2008-04-08	11
46926	val_26	2008-04-08	11
470165	val_165	2008-04-08	11
471327	val_327	2008-04-08	11
472230	val_230	2008-04-08	11
473205	val_205	2008-04-08	11
474120	val_120	2008-04-08	11
475131	val_131	2008-04-08	11
47651	val_51	2008-04-08	11
477404	val_404	2008-04-08	11
47843	val_43	2008-04-08	11
479436	val_436	2008-04-08	11
480156	val_156	2008-04-08	11
481469	val_469	2008-04-08	11
482468	val_468	2008-04-08	11
483308	val_308	2008-04-08	11
48495	val_95	2008-04-08	11
485196	val_196	2008-04-08	11
486288	val_288	2008-04-08	11
487481	val_481	2008-04-08	11
488457	val_457	2008-04-08	11
48998	val_98	2008-04-08	11
490282	val_282	2008-04-08	11
491197	val_197	2008-04-08	11
492187	val_187	2008-04-08	11
493318	val_318	2008-04-08	11
494318	val_318	2008-04-08	11
495409	val_409	2008-04-08	11
496470	val_470	2008-04-08	11
497137	val_137	2008-04-08	11
498369	val_369	2008-04-08	11
499316	val_316	2008-04-08	11
500169	val_169	2008-04-08	11
501413	val_413	2008-04-08	11
50285	val_85	2008-04-08	11
50377	val_77	2008-04-08	11
5040	val_0	2008-04-08	11
505490	val_490	2008-04-08	11
50687	val_87	2008-04-08	11
507364	val_364	2008-04-08	11
508179	val_179	2008-04-08	11
509118	val_118	2008-04-08	11
510134	val_134	2008-04-08	11
511395	val_395	2008-04-08	11
512282	val_282	2008-04-08	11
513138	val_138	2008-04-08	11
514238	val_238	2008-04-08	11
515419	val_419	2008-04-08	11
51615	val_15	2008-04-08	11
517118	val_118	2008-04-08	11
51872	val_72	2008-04-08	11
51990	val_90	2008-04-08	11
520307	val_307	2008-04-08	11
52119	val_19	2008-04-08	11
522435	val_435	2008-04-08	11
52310	val_10	2008-04-08	11
524277	val_277	2008-04-08	11
525273	val_273	2008-04-08	11
526306	val_306	2008-04-08	11
527224	val_224	2008-04-08	11
528309	val_309	2008-04-08	11
529389	val_389	2008-04-08	11
530327	val_327	2008-04-08	11
531242	val_242	2008-04-08	11
532369	val_369	2008-04-08	11
533392	val_392	2008-04-08	11
534272	val_272	2008-04-08	11
535331	val_331	2008-04-08	11
536401	val_401	2008-04-08	11
537242	val_242	2008-04-08	11
538452	val_452	2008-04-08	11
539177	val_177	2008-04-08	11
540226	val_226	2008-04-08	11
5415	val_5	2008-04-08	11
542497	val_497	2008-04-08	11
543402	val_402	2008-04-08	11
544396	val_396	2008-04-08	11
545317	val_317	2008-04-08	11
546395	val_395	2008-04-08	11
54758	val_58	2008-04-08	11
54835	val_35	2008-04-08	11
549336	val_336	2008-04-08	11
55095	val_95	2008-04-08	11
55111	val_11	2008-04-08	11
552168	val_168	2008-04-08	11
55334	val_34	2008-04-08	11
554229	val_229	2008-04-08	11
555233	val_233	2008-04-08	11
556143	val_143	2008-04-08	11
557472	val_472	2008-04-08	11
558322	val_322	2008-04-08	11
559498	val_498	2008-04-08	11
560160	val_160	2008-04-08	11
561195	val_195	2008-04-08	11
56242	val_42	2008-04-08	11
563321	val_321	2008-04-08	11
564430	val_430	2008-04-08	11
565119	val_119	2008-04-08	11
566489	val_489	2008-04-08	11
567458	val_458	2008-04-08	11
56878	val_78	2008-04-08	11
56976	val_76	2008-04-08	11
57041	val_41	2008-04-08	11
571223	val_223	2008-04-08	11
572492	val_492	2008-04-08	11
573149	val_149	2008-04-08	11
574449	val_449	2008-04-08	11
575218	val_218	2008-04-08	11
576228	val_228	2008-04-08	11
577138	val_138	2008-04-08	11
578453	val_453	2008-04-08	11
57930	val_30	2008-04-08	11
580209	val_209	2008-04-08	11
58164	val_64	2008-04-08	11
582468	val_468	2008-04-08	11
58376	val_76	2008-04-08	11
58474	val_74	2008-04-08	11
585342	val_342	2008-04-08	11
58669	val_69	2008-04-08	11
587230	val_230	2008-04-08	11
58833	val_33	2008-04-08	11
589368	val_368	2008-04-08	11
590103	val_103	2008-04-08	11
591296	val_296	2008-04-08	11
592113	val_113	2008-04-08	11
593216	val_216	2008-04-08	11
594367	val_367	2008-04-08	11
595344	val_344	2008-04-08	11
596167	val_167	2008-04-08	11
597274	val_274	2008-04-08	11
598219	val_219	2008-04-08	11
599239	val_239	2008-04-08	11
600485	val_485	2008-04-08	11
601116	val_116	2008-04-08	11
602223	val_223	2008-04-08	11
603256	val_256	2008-04-08	11
604263	val_263	2008-04-08	11
60570	val_70	2008-04-08	11
606487	val_487	2008-04-08	11
607480	val_480	2008-04-08	11
608401	val_401	2008-04-08	11
609288	val_288	2008-04-08	11
610191	val_191	2008-04-08	11
6115	val_5	2008-04-08	11
612244	val_244	2008-04-08	11
613438	val_438	2008-04-08	11
614128	val_128	2008-04-08	11
615467	val_467	2008-04-08	11
616432	val_432	2008-04-08	11
617202	val_202	2008-04-08	11
618316	val_316	2008-04-08	11
619229	val_229	2008-04-08	11
620469	val_469	2008-04-08	11
621463	val_463	2008-04-08	11
622280	val_280	2008-04-08	11
6232	val_2	2008-04-08	11
62435	val_35	2008-04-08	11
625283	val_283	2008-04-08	11
626331	val_331	2008-04-08	11
627235	val_235	2008-04-08	11
62880	val_80	2008-04-08	11
62944	val_44	2008-04-08	11
630193	val_193	2008-04-08	11
631321	val_321	2008-04-08	11
632335	val_335	2008-04-08	11
633104	val_104	2008-04-08	11
634466	val_466	2008-04-08	11
635366	val_366	2008-04-08	11
636175	val_175	2008-04-08	11
637403	val_403	2008-04-08	11
638483	val_483	2008-04-08	11
63953	val_53	2008-04-08	11
640105	val_105	2008-04-08	11
641257	val_257	2008-04-08	11
642406	val_406	2008-04-08	11
643409	val_409	2008-04-08	11
644190	val_190	2008-04-08	11
645406	val_406	2008-04-08	11
646401	val_401	2008-04-08	11
647114	val_114	2008-04-08	11
648258	val_258	2008-04-08	11
64990	val_90	2008-04-08	11
650203	val_203	2008-04-08	11
651262	val_262	2008-04-08	11
652348	val_348	2008-04-08	11
653424	val_424	2008-04-08	11
65412	val_12	2008-04-08	11
655396	val_396	2008-04-08	11
656201	val_201	2008-04-08	11
657217	val_217	2008-04-08	11
658164	val_164	2008-04-08	11
659431	val_431	2008-04-08	11
660454	val_454	2008-04-08	11
661478	val_478	2008-04-08	11
662298	val_298	2008-04-08	11
663125	val_125	2008-04-08	11
664431	val_431	2008-04-08	11
665164	val_164	2008-04-08	11
666424	val_424	2008-04-08	11
667187	val_187	2008-04-08	11
668382	val_382	2008-04-08	11
6695	val_5	2008-04-08	11
67070	val_70	2008-04-08	11
671397	val_397	2008-04-08	11
672480	val_480	2008-04-08	11
673291	val_291	2008-04-08	11
67424	val_24	2008-04-08	11
675351	val_351	2008-04-08	11
676255	val_255	2008-04-08	11
677104	val_104	2008-04-08	11
67870	val_70	2008-04-08	11
679163	val_163	2008-04-08	11
680438	val_438	2008-04-08	11
681119	val_119	2008-04-08	11
682414	val_414	2008-04-08	11
683200	val_200	2008-04-08	11
684491	val_491	2008-04-08	11
685237	val_237	2008-04-08	11
686439	val_439	2008-04-08	11
687360	val_360	2008-04-08	11
688248	val_248	2008-04-08	11
689479	val_479	2008-04-08	11
690305	val_305	2008-04-08	11
691417	val_417	2008-04-08	11
692199	val_199	2008-04-08	11
693444	val_444	2008-04-08	11
694120	val_120	2008-04-08	11
695429	val_429	2008-04-08	11
696169	val_169	2008-04-08	11
697443	val_443	2008-04-08	11
698323	val_323	2008-04-08	11
699325	val_325	2008-04-08	11
700277	val_277	2008-04-08	11
701230	val_230	2008-04-08	11
702478	val_478	2008-04-08	11
703178	val_178	2008-04-08	11
704468	val_468	2008-04-08	11
705310	val_310	2008-04-08	11
706317	val_317	2008-04-08	11
707333	val_333	2008-04-08	11
708493	val_493	2008-04-08	11
709460	val_460	2008-04-08	11
710207	val_207	2008-04-08	11
711249	val_249	2008-04-08	11
712265	val_265	2008-04-08	11
713480	val_480	2008-04-08	11
71483	val_83	2008-04-08	11
715136	val_136	2008-04-08	11
716353	val_353	2008-04-08	11
717172	val_172	2008-04-08	11
718214	val_214	2008-04-08	11
719462	val_462	2008-04-08	11
720233	val_233	2008-04-08	11
721406	val_406	2008-04-08	11
722133	val_133	2008-04-08	11
723175	val_175	2008-04-08	11
724189	val_189	2008-04-08	11
725454	val_454	2008-04-08	11
726375	val_375	2008-04-08	11
727401	val_401	2008-04-08	11
728421	val_421	2008-04-08	11
729407	val_407	2008-04-08	11
730384	val_384	2008-04-08	11
731256	val_256	2008-04-08	11
73226	val_26	2008-04-08	11
733134	val_134	2008-04-08	11
73467	val_67	2008-04-08	11
735384	val_384	2008-04-08	11
736379	val_379	2008-04-08	11
73718	val_18	2008-04-08	11
738462	val_462	2008-04-08	11
739492	val_492	2008-04-08	11
740100	val_100	2008-04-08	11
741298	val_298	2008-04-08	11
7429	val_9	2008-04-08	11
743341	val_341	2008-04-08	11
744498	val_498	2008-04-08	11
745146	val_146	2008-04-08	11
746458	val_458	2008-04-08	11
747362	val_362	2008-04-08	11
748186	val_186	2008-04-08	11
749285	val_285	2008-04-08	11
750348	val_348	2008-04-08	11
751167	val_167	2008-04-08	11
75218	val_18	2008-04-08	11
753273	val_273	2008-04-08	11
754183	val_183	2008-04-08	11
755281	val_281	2008-04-08	11
756344	val_344	2008-04-08	11
75797	val_97	2008-04-08	11
758469	val_469	2008-04-08	11
759315	val_315	2008-04-08	11
76084	val_84	2008-04-08	11
76128	val_28	2008-04-08	11
76237	val_37	2008-04-08	11
763448	val_448	2008-04-08	11
764152	val_152	2008-04-08	11
765348	val_348	2008-04-08	11
766307	val_307	2008-04-08	11
767194	val_194	2008-04-08	11
768414	val_414	2008-04-08	11
769477	val_477	2008-04-08	11
770222	val_222	2008-04-08	11
771126	val_126	2008-04-08	11
77290	val_90	2008-04-08	11
773169	val_169	2008-04-08	11
774403	val_403	2008-04-08	11
775400	val_400	2008-04-08	11
776200	val_200	2008-04-08	11
77797	val_97	2008-04-08	11
778PREHOOK: query: select count(1) from srcbucket
779PREHOOK: type: QUERY
780PREHOOK: Input: default@srcbucket
781PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-16_473_5957122419697785928/-mr-10000
782POSTHOOK: query: select count(1) from srcbucket
783POSTHOOK: type: QUERY
784POSTHOOK: Input: default@srcbucket
785POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-16_473_5957122419697785928/-mr-10000
786POSTHOOK: Lineage: dest1.dt SIMPLE [(srcpart)s.FieldSchema(name:ds, type:string, comment:null), ]
787POSTHOOK: Lineage: dest1.hr SIMPLE [(srcpart)s.FieldSchema(name:hr, type:string, comment:null), ]
788POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)s.FieldSchema(name:key, type:string, comment:default), ]
789POSTHOOK: Lineage: dest1.value SIMPLE [(srcpart)s.FieldSchema(name:value, type:string, comment:default), ]
7901000