PageRenderTime 53ms CodeModel.GetById 9ms app.highlight 26ms RepoModel.GetById 2ms app.codeStats 1ms

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

#
text | 1990 lines | 1969 code | 21 blank | 0 comment | 0 complexity | bdeb335b42b3477de77eb663e56b166d MD5 | raw file

Large files files are truncated, but you can click here to view the full file

   1PREHOOK: query: explain extended
   2select * from srcpart a where a.ds='2008-04-08' order by a.key, a.hr
   3PREHOOK: type: QUERY
   4POSTHOOK: query: explain extended
   5select * from srcpart a where a.ds='2008-04-08' order by a.key, a.hr
   6POSTHOOK: type: QUERY
   7ABSTRACT SYNTAX TREE:
   8  (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 (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) hr)))))
   9
  10STAGE DEPENDENCIES:
  11  Stage-1 is a root stage
  12  Stage-0 is a root stage
  13
  14STAGE PLANS:
  15  Stage: Stage-1
  16    Map Reduce
  17      Alias -> Map Operator Tree:
  18        a 
  19          TableScan
  20            alias: a
  21            GatherStats: false
  22            Select Operator
  23              expressions:
  24                    expr: key
  25                    type: string
  26                    expr: value
  27                    type: string
  28                    expr: ds
  29                    type: string
  30                    expr: hr
  31                    type: string
  32              outputColumnNames: _col0, _col1, _col2, _col3
  33              Reduce Output Operator
  34                key expressions:
  35                      expr: _col0
  36                      type: string
  37                      expr: _col3
  38                      type: string
  39                sort order: ++
  40                tag: -1
  41                value expressions:
  42                      expr: _col0
  43                      type: string
  44                      expr: _col1
  45                      type: string
  46                      expr: _col2
  47                      type: string
  48                      expr: _col3
  49                      type: string
  50      Needs Tagging: false
  51      Path -> Alias:
  52        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
  53        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
  54      Path -> Partition:
  55        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
  56          Partition
  57            base file name: hr=11
  58            input format: org.apache.hadoop.mapred.TextInputFormat
  59            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  60            partition values:
  61              ds 2008-04-08
  62              hr 11
  63            properties:
  64              bucket_count -1
  65              columns key,value
  66              columns.types string:string
  67              file.inputformat org.apache.hadoop.mapred.TextInputFormat
  68              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  69              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
  70              name default.srcpart
  71              partition_columns ds/hr
  72              serialization.ddl struct srcpart { string key, string value}
  73              serialization.format 1
  74              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  75              transient_lastDdlTime 1297378962
  76            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  77          
  78              input format: org.apache.hadoop.mapred.TextInputFormat
  79              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  80              properties:
  81                bucket_count -1
  82                columns key,value
  83                columns.types string:string
  84                file.inputformat org.apache.hadoop.mapred.TextInputFormat
  85                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  86                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
  87                name default.srcpart
  88                partition_columns ds/hr
  89                serialization.ddl struct srcpart { string key, string value}
  90                serialization.format 1
  91                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  92                transient_lastDdlTime 1297378962
  93              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  94              name: default.srcpart
  95            name: default.srcpart
  96        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
  97          Partition
  98            base file name: hr=12
  99            input format: org.apache.hadoop.mapred.TextInputFormat
 100            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 101            partition values:
 102              ds 2008-04-08
 103              hr 12
 104            properties:
 105              bucket_count -1
 106              columns key,value
 107              columns.types string:string
 108              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 109              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 110              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
 111              name default.srcpart
 112              partition_columns ds/hr
 113              serialization.ddl struct srcpart { string key, string value}
 114              serialization.format 1
 115              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 116              transient_lastDdlTime 1297378962
 117            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 118          
 119              input format: org.apache.hadoop.mapred.TextInputFormat
 120              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 121              properties:
 122                bucket_count -1
 123                columns key,value
 124                columns.types string:string
 125                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 126                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 127                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
 128                name default.srcpart
 129                partition_columns ds/hr
 130                serialization.ddl struct srcpart { string key, string value}
 131                serialization.format 1
 132                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 133                transient_lastDdlTime 1297378962
 134              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 135              name: default.srcpart
 136            name: default.srcpart
 137      Reduce Operator Tree:
 138        Extract
 139          File Output Operator
 140            compressed: false
 141            GlobalTableId: 0
 142            directory: file:/tmp/sdong/hive_2011-02-10_15-57-07_635_1521570938566507437/-ext-10001
 143            NumFilesPerFileSink: 1
 144            Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_15-57-07_635_1521570938566507437/-ext-10001/
 145            table:
 146                input format: org.apache.hadoop.mapred.TextInputFormat
 147                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 148                properties:
 149                  columns _col0,_col1,_col2,_col3
 150                  columns.types string:string:string:string
 151                  serialization.format 1
 152            TotalFiles: 1
 153            GatherStats: false
 154            MultiFileSpray: false
 155
 156  Stage: Stage-0
 157    Fetch Operator
 158      limit: -1
 159
 160
 161PREHOOK: query: select * from srcpart a where a.ds='2008-04-08' order by a.key, a.hr
 162PREHOOK: type: QUERY
 163PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 164PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 165PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-57-07_771_8008897996969692319/-mr-10000
 166POSTHOOK: query: select * from srcpart a where a.ds='2008-04-08' order by a.key, a.hr
 167POSTHOOK: type: QUERY
 168POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 169POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 170POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-57-07_771_8008897996969692319/-mr-10000
 1710	val_0	2008-04-08	11
 1720	val_0	2008-04-08	11
 1730	val_0	2008-04-08	11
 1740	val_0	2008-04-08	12
 1750	val_0	2008-04-08	12
 1760	val_0	2008-04-08	12
 17710	val_10	2008-04-08	11
 17810	val_10	2008-04-08	12
 179100	val_100	2008-04-08	11
 180100	val_100	2008-04-08	11
 181100	val_100	2008-04-08	12
 182100	val_100	2008-04-08	12
 183103	val_103	2008-04-08	11
 184103	val_103	2008-04-08	11
 185103	val_103	2008-04-08	12
 186103	val_103	2008-04-08	12
 187104	val_104	2008-04-08	11
 188104	val_104	2008-04-08	11
 189104	val_104	2008-04-08	12
 190104	val_104	2008-04-08	12
 191105	val_105	2008-04-08	11
 192105	val_105	2008-04-08	12
 19311	val_11	2008-04-08	11
 19411	val_11	2008-04-08	12
 195111	val_111	2008-04-08	11
 196111	val_111	2008-04-08	12
 197113	val_113	2008-04-08	11
 198113	val_113	2008-04-08	11
 199113	val_113	2008-04-08	12
 200113	val_113	2008-04-08	12
 201114	val_114	2008-04-08	11
 202114	val_114	2008-04-08	12
 203116	val_116	2008-04-08	11
 204116	val_116	2008-04-08	12
 205118	val_118	2008-04-08	11
 206118	val_118	2008-04-08	11
 207118	val_118	2008-04-08	12
 208118	val_118	2008-04-08	12
 209119	val_119	2008-04-08	11
 210119	val_119	2008-04-08	11
 211119	val_119	2008-04-08	11
 212119	val_119	2008-04-08	12
 213119	val_119	2008-04-08	12
 214119	val_119	2008-04-08	12
 21512	val_12	2008-04-08	11
 21612	val_12	2008-04-08	11
 21712	val_12	2008-04-08	12
 21812	val_12	2008-04-08	12
 219120	val_120	2008-04-08	11
 220120	val_120	2008-04-08	11
 221120	val_120	2008-04-08	12
 222120	val_120	2008-04-08	12
 223125	val_125	2008-04-08	11
 224125	val_125	2008-04-08	11
 225125	val_125	2008-04-08	12
 226125	val_125	2008-04-08	12
 227126	val_126	2008-04-08	11
 228126	val_126	2008-04-08	12
 229128	val_128	2008-04-08	11
 230128	val_128	2008-04-08	11
 231128	val_128	2008-04-08	11
 232128	val_128	2008-04-08	12
 233128	val_128	2008-04-08	12
 234128	val_128	2008-04-08	12
 235129	val_129	2008-04-08	11
 236129	val_129	2008-04-08	11
 237129	val_129	2008-04-08	12
 238129	val_129	2008-04-08	12
 239131	val_131	2008-04-08	11
 240131	val_131	2008-04-08	12
 241133	val_133	2008-04-08	11
 242133	val_133	2008-04-08	12
 243134	val_134	2008-04-08	11
 244134	val_134	2008-04-08	11
 245134	val_134	2008-04-08	12
 246134	val_134	2008-04-08	12
 247136	val_136	2008-04-08	11
 248136	val_136	2008-04-08	12
 249137	val_137	2008-04-08	11
 250137	val_137	2008-04-08	11
 251137	val_137	2008-04-08	12
 252137	val_137	2008-04-08	12
 253138	val_138	2008-04-08	11
 254138	val_138	2008-04-08	11
 255138	val_138	2008-04-08	11
 256138	val_138	2008-04-08	11
 257138	val_138	2008-04-08	12
 258138	val_138	2008-04-08	12
 259138	val_138	2008-04-08	12
 260138	val_138	2008-04-08	12
 261143	val_143	2008-04-08	11
 262143	val_143	2008-04-08	12
 263145	val_145	2008-04-08	11
 264145	val_145	2008-04-08	12
 265146	val_146	2008-04-08	11
 266146	val_146	2008-04-08	11
 267146	val_146	2008-04-08	12
 268146	val_146	2008-04-08	12
 269149	val_149	2008-04-08	11
 270149	val_149	2008-04-08	11
 271149	val_149	2008-04-08	12
 272149	val_149	2008-04-08	12
 27315	val_15	2008-04-08	11
 27415	val_15	2008-04-08	11
 27515	val_15	2008-04-08	12
 27615	val_15	2008-04-08	12
 277150	val_150	2008-04-08	11
 278150	val_150	2008-04-08	12
 279152	val_152	2008-04-08	11
 280152	val_152	2008-04-08	11
 281152	val_152	2008-04-08	12
 282152	val_152	2008-04-08	12
 283153	val_153	2008-04-08	11
 284153	val_153	2008-04-08	12
 285155	val_155	2008-04-08	11
 286155	val_155	2008-04-08	12
 287156	val_156	2008-04-08	11
 288156	val_156	2008-04-08	12
 289157	val_157	2008-04-08	11
 290157	val_157	2008-04-08	12
 291158	val_158	2008-04-08	11
 292158	val_158	2008-04-08	12
 293160	val_160	2008-04-08	11
 294160	val_160	2008-04-08	12
 295162	val_162	2008-04-08	11
 296162	val_162	2008-04-08	12
 297163	val_163	2008-04-08	11
 298163	val_163	2008-04-08	12
 299164	val_164	2008-04-08	11
 300164	val_164	2008-04-08	11
 301164	val_164	2008-04-08	12
 302164	val_164	2008-04-08	12
 303165	val_165	2008-04-08	11
 304165	val_165	2008-04-08	11
 305165	val_165	2008-04-08	12
 306165	val_165	2008-04-08	12
 307166	val_166	2008-04-08	11
 308166	val_166	2008-04-08	12
 309167	val_167	2008-04-08	11
 310167	val_167	2008-04-08	11
 311167	val_167	2008-04-08	11
 312167	val_167	2008-04-08	12
 313167	val_167	2008-04-08	12
 314167	val_167	2008-04-08	12
 315168	val_168	2008-04-08	11
 316168	val_168	2008-04-08	12
 317169	val_169	2008-04-08	11
 318169	val_169	2008-04-08	11
 319169	val_169	2008-04-08	11
 320169	val_169	2008-04-08	11
 321169	val_169	2008-04-08	12
 322169	val_169	2008-04-08	12
 323169	val_169	2008-04-08	12
 324169	val_169	2008-04-08	12
 32517	val_17	2008-04-08	11
 32617	val_17	2008-04-08	12
 327170	val_170	2008-04-08	11
 328170	val_170	2008-04-08	12
 329172	val_172	2008-04-08	11
 330172	val_172	2008-04-08	11
 331172	val_172	2008-04-08	12
 332172	val_172	2008-04-08	12
 333174	val_174	2008-04-08	11
 334174	val_174	2008-04-08	11
 335174	val_174	2008-04-08	12
 336174	val_174	2008-04-08	12
 337175	val_175	2008-04-08	11
 338175	val_175	2008-04-08	11
 339175	val_175	2008-04-08	12
 340175	val_175	2008-04-08	12
 341176	val_176	2008-04-08	11
 342176	val_176	2008-04-08	11
 343176	val_176	2008-04-08	12
 344176	val_176	2008-04-08	12
 345177	val_177	2008-04-08	11
 346177	val_177	2008-04-08	12
 347178	val_178	2008-04-08	11
 348178	val_178	2008-04-08	12
 349179	val_179	2008-04-08	11
 350179	val_179	2008-04-08	11
 351179	val_179	2008-04-08	12
 352179	val_179	2008-04-08	12
 35318	val_18	2008-04-08	11
 35418	val_18	2008-04-08	11
 35518	val_18	2008-04-08	12
 35618	val_18	2008-04-08	12
 357180	val_180	2008-04-08	11
 358180	val_180	2008-04-08	12
 359181	val_181	2008-04-08	11
 360181	val_181	2008-04-08	12
 361183	val_183	2008-04-08	11
 362183	val_183	2008-04-08	12
 363186	val_186	2008-04-08	11
 364186	val_186	2008-04-08	12
 365187	val_187	2008-04-08	11
 366187	val_187	2008-04-08	11
 367187	val_187	2008-04-08	11
 368187	val_187	2008-04-08	12
 369187	val_187	2008-04-08	12
 370187	val_187	2008-04-08	12
 371189	val_189	2008-04-08	11
 372189	val_189	2008-04-08	12
 37319	val_19	2008-04-08	11
 37419	val_19	2008-04-08	12
 375190	val_190	2008-04-08	11
 376190	val_190	2008-04-08	12
 377191	val_191	2008-04-08	11
 378191	val_191	2008-04-08	11
 379191	val_191	2008-04-08	12
 380191	val_191	2008-04-08	12
 381192	val_192	2008-04-08	11
 382192	val_192	2008-04-08	12
 383193	val_193	2008-04-08	11
 384193	val_193	2008-04-08	11
 385193	val_193	2008-04-08	11
 386193	val_193	2008-04-08	12
 387193	val_193	2008-04-08	12
 388193	val_193	2008-04-08	12
 389194	val_194	2008-04-08	11
 390194	val_194	2008-04-08	12
 391195	val_195	2008-04-08	11
 392195	val_195	2008-04-08	11
 393195	val_195	2008-04-08	12
 394195	val_195	2008-04-08	12
 395196	val_196	2008-04-08	11
 396196	val_196	2008-04-08	12
 397197	val_197	2008-04-08	11
 398197	val_197	2008-04-08	11
 399197	val_197	2008-04-08	12
 400197	val_197	2008-04-08	12
 401199	val_199	2008-04-08	11
 402199	val_199	2008-04-08	11
 403199	val_199	2008-04-08	11
 404199	val_199	2008-04-08	12
 405199	val_199	2008-04-08	12
 406199	val_199	2008-04-08	12
 4072	val_2	2008-04-08	11
 4082	val_2	2008-04-08	12
 40920	val_20	2008-04-08	11
 41020	val_20	2008-04-08	12
 411200	val_200	2008-04-08	11
 412200	val_200	2008-04-08	11
 413200	val_200	2008-04-08	12
 414200	val_200	2008-04-08	12
 415201	val_201	2008-04-08	11
 416201	val_201	2008-04-08	12
 417202	val_202	2008-04-08	11
 418202	val_202	2008-04-08	12
 419203	val_203	2008-04-08	11
 420203	val_203	2008-04-08	11
 421203	val_203	2008-04-08	12
 422203	val_203	2008-04-08	12
 423205	val_205	2008-04-08	11
 424205	val_205	2008-04-08	11
 425205	val_205	2008-04-08	12
 426205	val_205	2008-04-08	12
 427207	val_207	2008-04-08	11
 428207	val_207	2008-04-08	11
 429207	val_207	2008-04-08	12
 430207	val_207	2008-04-08	12
 431208	val_208	2008-04-08	11
 432208	val_208	2008-04-08	11
 433208	val_208	2008-04-08	11
 434208	val_208	2008-04-08	12
 435208	val_208	2008-04-08	12
 436208	val_208	2008-04-08	12
 437209	val_209	2008-04-08	11
 438209	val_209	2008-04-08	11
 439209	val_209	2008-04-08	12
 440209	val_209	2008-04-08	12
 441213	val_213	2008-04-08	11
 442213	val_213	2008-04-08	11
 443213	val_213	2008-04-08	12
 444213	val_213	2008-04-08	12
 445214	val_214	2008-04-08	11
 446214	val_214	2008-04-08	12
 447216	val_216	2008-04-08	11
 448216	val_216	2008-04-08	11
 449216	val_216	2008-04-08	12
 450216	val_216	2008-04-08	12
 451217	val_217	2008-04-08	11
 452217	val_217	2008-04-08	11
 453217	val_217	2008-04-08	12
 454217	val_217	2008-04-08	12
 455218	val_218	2008-04-08	11
 456218	val_218	2008-04-08	12
 457219	val_219	2008-04-08	11
 458219	val_219	2008-04-08	11
 459219	val_219	2008-04-08	12
 460219	val_219	2008-04-08	12
 461221	val_221	2008-04-08	11
 462221	val_221	2008-04-08	11
 463221	val_221	2008-04-08	12
 464221	val_221	2008-04-08	12
 465222	val_222	2008-04-08	11
 466222	val_222	2008-04-08	12
 467223	val_223	2008-04-08	11
 468223	val_223	2008-04-08	11
 469223	val_223	2008-04-08	12
 470223	val_223	2008-04-08	12
 471224	val_224	2008-04-08	11
 472224	val_224	2008-04-08	11
 473224	val_224	2008-04-08	12
 474224	val_224	2008-04-08	12
 475226	val_226	2008-04-08	11
 476226	val_226	2008-04-08	12
 477228	val_228	2008-04-08	11
 478228	val_228	2008-04-08	12
 479229	val_229	2008-04-08	11
 480229	val_229	2008-04-08	11
 481229	val_229	2008-04-08	12
 482229	val_229	2008-04-08	12
 483230	val_230	2008-04-08	11
 484230	val_230	2008-04-08	11
 485230	val_230	2008-04-08	11
 486230	val_230	2008-04-08	11
 487230	val_230	2008-04-08	11
 488230	val_230	2008-04-08	12
 489230	val_230	2008-04-08	12
 490230	val_230	2008-04-08	12
 491230	val_230	2008-04-08	12
 492230	val_230	2008-04-08	12
 493233	val_233	2008-04-08	11
 494233	val_233	2008-04-08	11
 495233	val_233	2008-04-08	12
 496233	val_233	2008-04-08	12
 497235	val_235	2008-04-08	11
 498235	val_235	2008-04-08	12
 499237	val_237	2008-04-08	11
 500237	val_237	2008-04-08	11
 501237	val_237	2008-04-08	12
 502237	val_237	2008-04-08	12
 503238	val_238	2008-04-08	11
 504238	val_238	2008-04-08	11
 505238	val_238	2008-04-08	12
 506238	val_238	2008-04-08	12
 507239	val_239	2008-04-08	11
 508239	val_239	2008-04-08	11
 509239	val_239	2008-04-08	12
 510239	val_239	2008-04-08	12
 51124	val_24	2008-04-08	11
 51224	val_24	2008-04-08	11
 51324	val_24	2008-04-08	12
 51424	val_24	2008-04-08	12
 515241	val_241	2008-04-08	11
 516241	val_241	2008-04-08	12
 517242	val_242	2008-04-08	11
 518242	val_242	2008-04-08	11
 519242	val_242	2008-04-08	12
 520242	val_242	2008-04-08	12
 521244	val_244	2008-04-08	11
 522244	val_244	2008-04-08	12
 523247	val_247	2008-04-08	11
 524247	val_247	2008-04-08	12
 525248	val_248	2008-04-08	11
 526248	val_248	2008-04-08	12
 527249	val_249	2008-04-08	11
 528249	val_249	2008-04-08	12
 529252	val_252	2008-04-08	11
 530252	val_252	2008-04-08	12
 531255	val_255	2008-04-08	11
 532255	val_255	2008-04-08	11
 533255	val_255	2008-04-08	12
 534255	val_255	2008-04-08	12
 535256	val_256	2008-04-08	11
 536256	val_256	2008-04-08	11
 537256	val_256	2008-04-08	12
 538256	val_256	2008-04-08	12
 539257	val_257	2008-04-08	11
 540257	val_257	2008-04-08	12
 541258	val_258	2008-04-08	11
 542258	val_258	2008-04-08	12
 54326	val_26	2008-04-08	11
 54426	val_26	2008-04-08	11
 54526	val_26	2008-04-08	12
 54626	val_26	2008-04-08	12
 547260	val_260	2008-04-08	11
 548260	val_260	2008-04-08	12
 549262	val_262	2008-04-08	11
 550262	val_262	2008-04-08	12
 551263	val_263	2008-04-08	11
 552263	val_263	2008-04-08	12
 553265	val_265	2008-04-08	11
 554265	val_265	2008-04-08	11
 555265	val_265	2008-04-08	12
 556265	val_265	2008-04-08	12
 557266	val_266	2008-04-08	11
 558266	val_266	2008-04-08	12
 55927	val_27	2008-04-08	11
 56027	val_27	2008-04-08	12
 561272	val_272	2008-04-08	11
 562272	val_272	2008-04-08	11
 563272	val_272	2008-04-08	12
 564272	val_272	2008-04-08	12
 565273	val_273	2008-04-08	11
 566273	val_273	2008-04-08	11
 567273	val_273	2008-04-08	11
 568273	val_273	2008-04-08	12
 569273	val_273	2008-04-08	12
 570273	val_273	2008-04-08	12
 571274	val_274	2008-04-08	11
 572274	val_274	2008-04-08	12
 573275	val_275	2008-04-08	11
 574275	val_275	2008-04-08	12
 575277	val_277	2008-04-08	11
 576277	val_277	2008-04-08	11
 577277	val_277	2008-04-08	11
 578277	val_277	2008-04-08	11
 579277	val_277	2008-04-08	12
 580277	val_277	2008-04-08	12
 581277	val_277	2008-04-08	12
 582277	val_277	2008-04-08	12
 583278	val_278	2008-04-08	11
 584278	val_278	2008-04-08	11
 585278	val_278	2008-04-08	12
 586278	val_278	2008-04-08	12
 58728	val_28	2008-04-08	11
 58828	val_28	2008-04-08	12
 589280	val_280	2008-04-08	11
 590280	val_280	2008-04-08	11
 591280	val_280	2008-04-08	12
 592280	val_280	2008-04-08	12
 593281	val_281	2008-04-08	11
 594281	val_281	2008-04-08	11
 595281	val_281	2008-04-08	12
 596281	val_281	2008-04-08	12
 597282	val_282	2008-04-08	11
 598282	val_282	2008-04-08	11
 599282	val_282	2008-04-08	12
 600282	val_282	2008-04-08	12
 601283	val_283	2008-04-08	11
 602283	val_283	2008-04-08	12
 603284	val_284	2008-04-08	11
 604284	val_284	2008-04-08	12
 605285	val_285	2008-04-08	11
 606285	val_285	2008-04-08	12
 607286	val_286	2008-04-08	11
 608286	val_286	2008-04-08	12
 609287	val_287	2008-04-08	11
 610287	val_287	2008-04-08	12
 611288	val_288	2008-04-08	11
 612288	val_288	2008-04-08	11
 613288	val_288	2008-04-08	12
 614288	val_288	2008-04-08	12
 615289	val_289	2008-04-08	11
 616289	val_289	2008-04-08	12
 617291	val_291	2008-04-08	11
 618291	val_291	2008-04-08	12
 619292	val_292	2008-04-08	11
 620292	val_292	2008-04-08	12
 621296	val_296	2008-04-08	11
 622296	val_296	2008-04-08	12
 623298	val_298	2008-04-08	11
 624298	val_298	2008-04-08	11
 625298	val_298	2008-04-08	11
 626298	val_298	2008-04-08	12
 627298	val_298	2008-04-08	12
 628298	val_298	2008-04-08	12
 62930	val_30	2008-04-08	11
 63030	val_30	2008-04-08	12
 631302	val_302	2008-04-08	11
 632302	val_302	2008-04-08	12
 633305	val_305	2008-04-08	11
 634305	val_305	2008-04-08	12
 635306	val_306	2008-04-08	11
 636306	val_306	2008-04-08	12
 637307	val_307	2008-04-08	11
 638307	val_307	2008-04-08	11
 639307	val_307	2008-04-08	12
 640307	val_307	2008-04-08	12
 641308	val_308	2008-04-08	11
 642308	val_308	2008-04-08	12
 643309	val_309	2008-04-08	11
 644309	val_309	2008-04-08	11
 645309	val_309	2008-04-08	12
 646309	val_309	2008-04-08	12
 647310	val_310	2008-04-08	11
 648310	val_310	2008-04-08	12
 649311	val_311	2008-04-08	11
 650311	val_311	2008-04-08	11
 651311	val_311	2008-04-08	11
 652311	val_311	2008-04-08	12
 653311	val_311	2008-04-08	12
 654311	val_311	2008-04-08	12
 655315	val_315	2008-04-08	11
 656315	val_315	2008-04-08	12
 657316	val_316	2008-04-08	11
 658316	val_316	2008-04-08	11
 659316	val_316	2008-04-08	11
 660316	val_316	2008-04-08	12
 661316	val_316	2008-04-08	12
 662316	val_316	2008-04-08	12
 663317	val_317	2008-04-08	11
 664317	val_317	2008-04-08	11
 665317	val_317	2008-04-08	12
 666317	val_317	2008-04-08	12
 667318	val_318	2008-04-08	11
 668318	val_318	2008-04-08	11
 669318	val_318	2008-04-08	11
 670318	val_318	2008-04-08	12
 671318	val_318	2008-04-08	12
 672318	val_318	2008-04-08	12
 673321	val_321	2008-04-08	11
 674321	val_321	2008-04-08	11
 675321	val_321	2008-04-08	12
 676321	val_321	2008-04-08	12
 677322	val_322	2008-04-08	11
 678322	val_322	2008-04-08	11
 679322	val_322	2008-04-08	12
 680322	val_322	2008-04-08	12
 681323	val_323	2008-04-08	11
 682323	val_323	2008-04-08	12
 683325	val_325	2008-04-08	11
 684325	val_325	2008-04-08	11
 685325	val_325	2008-04-08	12
 686325	val_325	2008-04-08	12
 687327	val_327	2008-04-08	11
 688327	val_327	2008-04-08	11
 689327	val_327	2008-04-08	11
 690327	val_327	2008-04-08	12
 691327	val_327	2008-04-08	12
 692327	val_327	2008-04-08	12
 69333	val_33	2008-04-08	11
 69433	val_33	2008-04-08	12
 695331	val_331	2008-04-08	11
 696331	val_331	2008-04-08	11
 697331	val_331	2008-04-08	12
 698331	val_331	2008-04-08	12
 699332	val_332	2008-04-08	11
 700332	val_332	2008-04-08	12
 701333	val_333	2008-04-08	11
 702333	val_333	2008-04-08	11
 703333	val_333	2008-04-08	12
 704333	val_333	2008-04-08	12
 705335	val_335	2008-04-08	11
 706335	val_335	2008-04-08	12
 707336	val_336	2008-04-08	11
 708336	val_336	2008-04-08	12
 709338	val_338	2008-04-08	11
 710338	val_338	2008-04-08	12
 711339	val_339	2008-04-08	11
 712339	val_339	2008-04-08	12
 71334	val_34	2008-04-08	11
 71434	val_34	2008-04-08	12
 715341	val_341	2008-04-08	11
 716341	val_341	2008-04-08	12
 717342	val_342	2008-04-08	11
 718342	val_342	2008-04-08	11
 719342	val_342	2008-04-08	12
 720342	val_342	2008-04-08	12
 721344	val_344	2008-04-08	11
 722344	val_344	2008-04-08	11
 723344	val_344	2008-04-08	12
 724344	val_344	2008-04-08	12
 725345	val_345	2008-04-08	11
 726345	val_345	2008-04-08	12
 727348	val_348	2008-04-08	11
 728348	val_348	2008-04-08	11
 729348	val_348	2008-04-08	11
 730348	val_348	2008-04-08	11
 731348	val_348	2008-04-08	11
 732348	val_348	2008-04-08	12
 733348	val_348	2008-04-08	12
 734348	val_348	2008-04-08	12
 735348	val_348	2008-04-08	12
 736348	val_348	2008-04-08	12
 73735	val_35	2008-04-08	11
 73835	val_35	2008-04-08	11
 73935	val_35	2008-04-08	11
 74035	val_35	2008-04-08	12
 74135	val_35	2008-04-08	12
 74235	val_35	2008-04-08	12
 743351	val_351	2008-04-08	11
 744351	val_351	2008-04-08	12
 745353	val_353	2008-04-08	11
 746353	val_353	2008-04-08	11
 747353	val_353	2008-04-08	12
 748353	val_353	2008-04-08	12
 749356	val_356	2008-04-08	11
 750356	val_356	2008-04-08	12
 751360	val_360	2008-04-08	11
 752360	val_360	2008-04-08	12
 753362	val_362	2008-04-08	11
 754362	val_362	2008-04-08	12
 755364	val_364	2008-04-08	11
 756364	val_364	2008-04-08	12
 757365	val_365	2008-04-08	11
 758365	val_365	2008-04-08	12
 759366	val_366	2008-04-08	11
 760366	val_366	2008-04-08	12
 761367	val_367	2008-04-08	11
 762367	val_367	2008-04-08	11
 763367	val_367	2008-04-08	12
 764367	val_367	2008-04-08	12
 765368	val_368	2008-04-08	11
 766368	val_368	2008-04-08	12
 767369	val_369	2008-04-08	11
 768369	val_369	2008-04-08	11
 769369	val_369	2008-04-08	11
 770369	val_369	2008-04-08	12
 771369	val_369	2008-04-08	12
 772369	val_369	2008-04-08	12
 77337	val_37	2008-04-08	11
 77437	val_37	2008-04-08	11
 77537	val_37	2008-04-08	12
 77637	val_37	2008-04-08	12
 777373	val_373	2008-04-08	11
 778373	val_373	2008-04-08	12
 779374	val_374	2008-04-08	11
 780374	val_374	2008-04-08	12
 781375	val_375	2008-04-08	11
 782375	val_375	2008-04-08	12
 783377	val_377	2008-04-08	11
 784377	val_377	2008-04-08	12
 785378	val_378	2008-04-08	11
 786378	val_378	2008-04-08	12
 787379	val_379	2008-04-08	11
 788379	val_379	2008-04-08	12
 789382	val_382	2008-04-08	11
 790382	val_382	2008-04-08	11
 791382	val_382	2008-04-08	12
 792382	val_382	2008-04-08	12
 793384	val_384	2008-04-08	11
 794384	val_384	2008-04-08	11
 795384	val_384	2008-04-08	11
 796384	val_384	2008-04-08	12
 797384	val_384	2008-04-08	12
 798384	val_384	2008-04-08	12
 799386	val_386	2008-04-08	11
 800386	val_386	2008-04-08	12
 801389	val_389	2008-04-08	11
 802389	val_389	2008-04-08	12
 803392	val_392	2008-04-08	11
 804392	val_392	2008-04-08	12
 805393	val_393	2008-04-08	11
 806393	val_393	2008-04-08	12
 807394	val_394	2008-04-08	11
 808394	val_394	2008-04-08	12
 809395	val_395	2008-04-08	11
 810395	val_395	2008-04-08	11
 811395	val_395	2008-04-08	12
 812395	val_395	2008-04-08	12
 813396	val_396	2008-04-08	11
 814396	val_396	2008-04-08	11
 815396	val_396	2008-04-08	11
 816396	val_396	2008-04-08	12
 817396	val_396	2008-04-08	12
 818396	val_396	2008-04-08	12
 819397	val_397	2008-04-08	11
 820397	val_397	2008-04-08	11
 821397	val_397	2008-04-08	12
 822397	val_397	2008-04-08	12
 823399	val_399	2008-04-08	11
 824399	val_399	2008-04-08	11
 825399	val_399	2008-04-08	12
 826399	val_399	2008-04-08	12
 8274	val_4	2008-04-08	11
 8284	val_4	2008-04-08	12
 829400	val_400	2008-04-08	11
 830400	val_400	2008-04-08	12
 831401	val_401	2008-04-08	11
 832401	val_401	2008-04-08	11
 833401	val_401	2008-04-08	11
 834401	val_401	2008-04-08	11
 835401	val_401	2008-04-08	11
 836401	val_401	2008-04-08	12
 837401	val_401	2008-04-08	12
 838401	val_401	2008-04-08	12
 839401	val_401	2008-04-08	12
 840401	val_401	2008-04-08	12
 841402	val_402	2008-04-08	11
 842402	val_402	2008-04-08	12
 843403	val_403	2008-04-08	11
 844403	val_403	2008-04-08	11
 845403	val_403	2008-04-08	11
 846403	val_403	2008-04-08	12
 847403	val_403	2008-04-08	12
 848403	val_403	2008-04-08	12
 849404	val_404	2008-04-08	11
 850404	val_404	2008-04-08	11
 851404	val_404	2008-04-08	12
 852404	val_404	2008-04-08	12
 853406	val_406	2008-04-08	11
 854406	val_406	2008-04-08	11
 855406	val_406	2008-04-08	11
 856406	val_406	2008-04-08	11
 857406	val_406	2008-04-08	12
 858406	val_406	2008-04-08	12
 859406	val_406	2008-04-08	12
 860406	val_406	2008-04-08	12
 861407	val_407	2008-04-08	11
 862407	val_407	2008-04-08	12
 863409	val_409	2008-04-08	11
 864409	val_409	2008-04-08	11
 865409	val_409	2008-04-08	11
 866409	val_409	2008-04-08	12
 867409	val_409	2008-04-08	12
 868409	val_409	2008-04-08	12
 86941	val_41	2008-04-08	11
 87041	val_41	2008-04-08	12
 871411	val_411	2008-04-08	11
 872411	val_411	2008-04-08	12
 873413	val_413	2008-04-08	11
 874413	val_413	2008-04-08	11
 875413	val_413	2008-04-08	12
 876413	val_413	2008-04-08	12
 877414	val_414	2008-04-08	11
 878414	val_414	2008-04-08	11
 879414	val_414	2008-04-08	12
 880414	val_414	2008-04-08	12
 881417	val_417	2008-04-08	11
 882417	val_417	2008-04-08	11
 883417	val_417	2008-04-08	11
 884417	val_417	2008-04-08	12
 885417	val_417	2008-04-08	12
 886417	val_417	2008-04-08	12
 887418	val_418	2008-04-08	11
 888418	val_418	2008-04-08	12
 889419	val_419	2008-04-08	11
 890419	val_419	2008-04-08	12
 89142	val_42	2008-04-08	11
 89242	val_42	2008-04-08	11
 89342	val_42	2008-04-08	12
 89442	val_42	2008-04-08	12
 895421	val_421	2008-04-08	11
 896421	val_421	2008-04-08	12
 897424	val_424	2008-04-08	11
 898424	val_424	2008-04-08	11
 899424	val_424	2008-04-08	12
 900424	val_424	2008-04-08	12
 901427	val_427	2008-04-08	11
 902427	val_427	2008-04-08	12
 903429	val_429	2008-04-08	11
 904429	val_429	2008-04-08	11
 905429	val_429	2008-04-08	12
 906429	val_429	2008-04-08	12
 90743	val_43	2008-04-08	11
 90843	val_43	2008-04-08	12
 909430	val_430	2008-04-08	11
 910430	val_430	2008-04-08	11
 911430	val_430	2008-04-08	11
 912430	val_430	2008-04-08	12
 913430	val_430	2008-04-08	12
 914430	val_430	2008-04-08	12
 915431	val_431	2008-04-08	11
 916431	val_431	2008-04-08	11
 917431	val_431	2008-04-08	11
 918431	val_431	2008-04-08	12
 919431	val_431	2008-04-08	12
 920431	val_431	2008-04-08	12
 921432	val_432	2008-04-08	11
 922432	val_432	2008-04-08	12
 923435	val_435	2008-04-08	11
 924435	val_435	2008-04-08	12
 925436	val_436	2008-04-08	11
 926436	val_436	2008-04-08	12
 927437	val_437	2008-04-08	11
 928437	val_437	2008-04-08	12
 929438	val_438	2008-04-08	11
 930438	val_438	2008-04-08	11
 931438	val_438	2008-04-08	11
 932438	val_438	2008-04-08	12
 933438	val_438	2008-04-08	12
 934438	val_438	2008-04-08	12
 935439	val_439	2008-04-08	11
 936439	val_439	2008-04-08	11
 937439	val_439	2008-04-08	12
 938439	val_439	2008-04-08	12
 93944	val_44	2008-04-08	11
 94044	val_44	2008-04-08	12
 941443	val_443	2008-04-08	11
 942443	val_443	2008-04-08	12
 943444	val_444	2008-04-08	11
 944444	val_444	2008-04-08	12
 945446	val_446	2008-04-08	11
 946446	val_446	2008-04-08	12
 947448	val_448	2008-04-08	11
 948448	val_448	2008-04-08	12
 949449	val_449	2008-04-08	11
 950449	val_449	2008-04-08	12
 951452	val_452	2008-04-08	11
 952452	val_452	2008-04-08	12
 953453	val_453	2008-04-08	11
 954453	val_453	2008-04-08	12
 955454	val_454	2008-04-08	11
 956454	val_454	2008-04-08	11
 957454	val_454	2008-04-08	11
 958454	val_454	2008-04-08	12
 959454	val_454	2008-04-08	12
 960454	val_454	2008-04-08	12
 961455	val_455	2008-04-08	11
 962455	val_455	2008-04-08	12
 963457	val_457	2008-04-08	11
 964457	val_457	2008-04-08	12
 965458	val_458	2008-04-08	11
 966458	val_458	2008-04-08	11
 967458	val_458	2008-04-08	12
 968458	val_458	2008-04-08	12
 969459	val_459	2008-04-08	11
 970459	val_459	2008-04-08	11
 971459	val_459	2008-04-08	12
 972459	val_459	2008-04-08	12
 973460	val_460	2008-04-08	11
 974460	val_460	2008-04-08	12
 975462	val_462	2008-04-08	11
 976462	val_462	2008-04-08	11
 977462	val_462	2008-04-08	12
 978462	val_462	2008-04-08	12
 979463	val_463	2008-04-08	11
 980463	val_463	2008-04-08	11
 981463	val_463	2008-04-08	12
 982463	val_463	2008-04-08	12
 983466	val_466	2008-04-08	11
 984466	val_466	2008-04-08	11
 985466	val_466	2008-04-08	11
 986466	val_466	2008-04-08	12
 987466	val_466	2008-04-08	12
 988466	val_466	2008-04-08	12
 989467	val_467	2008-04-08	11
 990467	val_467	2008-04-08	12
 991468	val_468	2008-04-08	11
 992468	val_468	2008-04-08	11
 993468	val_468	2008-04-08	11
 994468	val_468	2008-04-08	11
 995468	val_468	2008-04-08	12
 996468	val_468	2008-04-08	12
 997468	val_468	2008-04-08	12
 998468	val_468	2008-04-08	12
 999469	val_469	2008-04-08	11
1000469	val_469	2008-04-08	11
1001469	val_469	2008-04-08	11
1002469	val_469	2008-04-08	11
1003469	val_469	2008-04-08	11
1004469	val_469	2008-04-08	12
1005469	val_469	2008-04-08	12
1006469	val_469	2008-04-08	12
1007469	val_469	2008-04-08	12
1008469	val_469	2008-04-08	12
100947	val_47	2008-04-08	11
101047	val_47	2008-04-08	12
1011470	val_470	2008-04-08	11
1012470	val_470	2008-04-08	12
1013472	val_472	2008-04-08	11
1014472	val_472	2008-04-08	12
1015475	val_475	2008-04-08	11
1016475	val_475	2008-04-08	12
1017477	val_477	2008-04-08	11
1018477	val_477	2008-04-08	12
1019478	val_478	2008-04-08	11
1020478	val_478	2008-04-08	11
1021478	val_478	2008-04-08	12
1022478	val_478	2008-04-08	12
1023479	val_479	2008-04-08	11
1024479	val_479	2008-04-08	12
1025480	val_480	2008-04-08	11
1026480	val_480	2008-04-08	11
1027480	val_480	2008-04-08	11
1028480	val_480	2008-04-08	12
1029480	val_480	2008-04-08	12
1030480	val_480	2008-04-08	12
1031481	val_481	2008-04-08	11
1032481	val_481	2008-04-08	12
1033482	val_482	2008-04-08	11
1034482	val_482	2008-04-08	12
1035483	val_483	2008-04-08	11
1036483	val_483	2008-04-08	12
1037484	val_484	2008-04-08	11
1038484	val_484	2008-04-08	12
1039485	val_485	2008-04-08	11
1040485	val_485	2008-04-08	12
1041487	val_487	2008-04-08	11
1042487	val_487	2008-04-08	12
1043489	val_489	2008-04-08	11
1044489	val_489	2008-04-08	11
1045489	val_489	2008-04-08	11
1046489	val_489	2008-04-08	11
1047489	val_489	2008-04-08	12
1048489	val_489	2008-04-08	12
1049489	val_489	2008-04-08	12
1050489	val_489	2008-04-08	12
1051490	val_490	2008-04-08	11
1052490	val_490	2008-04-08	12
1053491	val_491	2008-04-08	11
1054491	val_491	2008-04-08	12
1055492	val_492	2008-04-08	11
1056492	val_492	2008-04-08	11
1057492	val_492	2008-04-08	12
1058492	val_492	2008-04-08	12
1059493	val_493	2008-04-08	11
1060493	val_493	2008-04-08	12
1061494	val_494	2008-04-08	11
1062494	val_494	2008-04-08	12
1063495	val_495	2008-04-08	11
1064495	val_495	2008-04-08	12
1065496	val_496	2008-04-08	11
1066496	val_496	2008-04-08	12
1067497	val_497	2008-04-08	11
1068497	val_497	2008-04-08	12
1069498	val_498	2008-04-08	11
1070498	val_498	2008-04-08	11
1071498	val_498	2008-04-08	11
1072498	val_498	2008-04-08	12
1073498	val_498	2008-04-08	12
1074498	val_498	2008-04-08	12
10755	val_5	2008-04-08	11
10765	val_5	2008-04-08	11
10775	val_5	2008-04-08	11
10785	val_5	2008-04-08	12
10795	val_5	2008-04-08	12
10805	val_5	2008-04-08	12
108151	val_51	2008-04-08	11
108251	val_51	2008-04-08	11
108351	val_51	2008-04-08	12
108451	val_51	2008-04-08	12
108553	val_53	2008-04-08	11
108653	val_53	2008-04-08	12
108754	val_54	2008-04-08	11
108854	val_54	2008-04-08	12
108957	val_57	2008-04-08	11
109057	val_57	2008-04-08	12
109158	val_58	2008-04-08	11
109258	val_58	2008-04-08	11
109358	val_58	2008-04-08	12
109458	val_58	2008-04-08	12
109564	val_64	2008-04-08	11
109664	val_64	2008-04-08	12
109765	val_65	2008-04-08	11
109865	val_65	2008-04-08	12
109966	val_66	2008-04-08	11
110066	val_66	2008-04-08	12
110167	val_67	2008-04-08	11
110267	val_67	2008-04-08	11
110367	val_67	2008-04-08	12
110467	val_67	2008-04-08	12
110569	val_69	2008-04-08	11
110669	val_69	2008-04-08	12
110770	val_70	2008-04-08	11
110870	val_70	2008-04-08	11
110970	val_70	2008-04-08	11
111070	val_70	2008-04-08	12
111170	val_70	2008-04-08	12
111270	val_70	2008-04-08	12
111372	val_72	2008-04-08	11
111472	val_72	2008-04-08	11
111572	val_72	2008-04-08	12
111672	val_72	2008-04-08	12
111774	val_74	2008-04-08	11
111874	val_74	2008-04-08	12
111976	val_76	2008-04-08	11
112076	val_76	2008-04-08	11
112176	val_76	2008-04-08	12
112276	val_76	2008-04-08	12
112377	val_77	2008-04-08	11
112477	val_77	2008-04-08	12
112578	val_78	2008-04-08	11
112678	val_78	2008-04-08	12
11278	val_8	2008-04-08	11
11288	val_8	2008-04-08	12
112980	val_80	2008-04-08	11
113080	val_80	2008-04-08	12
113182	val_82	2008-04-08	11
113282	val_82	2008-04-08	12
113383	val_83	2008-04-08	11
113483	val_83	2008-04-08	11
113583	val_83	2008-04-08	12
113683	val_83	2008-04-08	12
113784	val_84	2008-04-08	11
113884	val_84	2008-04-08	11
113984	val_84	2008-04-08	12
114084	val_84	2008-04-08	12
114185	val_85	2008-04-08	11
114285	val_85	2008-04-08	12
114386	val_86	2008-04-08	11
114486	val_86	2008-04-08	12
114587	val_87	2008-04-08	11
114687	val_87	2008-04-08	12
11479	val_9	2008-04-08	11
11489	val_9	2008-04-08	12
114990	val_90	2008-04-08	11
115090	val_90	2008-04-08	11
115190	val_90	2008-04-08	11
115290	val_90	2008-04-08	12
115390	val_90	2008-04-08	12
115490	val_90	2008-04-08	12
115592	val_92	2008-04-08	11
115692	val_92	2008-04-08	12
115795	val_95	2008-04-08	11
115895	val_95	2008-04-08	11
115995	val_95	2008-04-08	12
116095	val_95	2008-04-08	12
116196	val_96	2008-04-08	11
116296	val_96	2008-04-08	12
116397	val_97	2008-04-08	11
116497	val_97	2008-04-08	11
116597	val_97	2008-04-08	12
116697	val_97	2008-04-08	12
116798	val_98	2008-04-08	11
116898	val_98	2008-04-08	11
116998	val_98	2008-04-08	12
117098	val_98	2008-04-08	12
1171PREHOOK: query: explain extended
1172select * from srcpart a where a.ds='2008-04-08' and key < 200 order by a.key, a.hr
1173PREHOOK: type: QUERY
1174POSTHOOK: query: explain extended
1175select * from srcpart a where a.ds='2008-04-08' and key < 200 order by a.key, a.hr
1176POSTHOOK: type: QUERY
1177ABSTRACT SYNTAX TREE:
1178  (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 key) 200))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) hr)))))
1179
1180STAGE DEPENDENCIES:
1181  Stage-1 is a root stage
1182  Stage-0 is a root stage
1183
1184STAGE PLANS:
1185  Stage: Stage-1
1186    Map Reduce
1187      Alias -> Map Operator Tree:
1188        a 
1189          TableScan
1190            alias: a
1191            GatherStats: false
1192            Filter Operator
1193              isSamplingPred: false
1194              predicate:
1195                  expr: (key < 200)
1196                  type: boolean
1197              Select Operator
1198                expressions:
1199                      expr: key
1200                      type: string
1201                      expr: value
1202                      type: string
1203                      expr: ds
1204                      type: string
1205                      expr: hr
1206                      type: string
1207                outputColumnNames: _col0, _col1, _col2, _col3
1208                Reduce Output Operator
1209                  key expressions:
1210                        expr: _col0
1211                        type: string
1212                        expr: _col3
1213                        type: string
1214                  sort order: ++
1215                  tag: -1
1216                  value expressions:
1217                        expr: _col0
1218                        type: string
1219                        expr: _col1
1220                        type: string
1221                        expr: _col2
1222                        type: string
1223                        expr: _col3
1224                        type: string
1225      Needs Tagging: false
1226      Path -> Alias:
1227        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
1228        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
1229      Path -> Partition:
1230        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
1231          Partition
1232            base file name: hr=11
1233            input format: org.apache.hadoop.mapred.TextInputFormat
1234            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1235            partition values:
1236              ds 2008-04-08
1237              hr 11
1238            properties:
1239              bucket_count -1
1240              columns key,value
1241              columns.types string:string
1242              file.inputformat org.apache.hadoop.mapred.TextInputFormat
1243              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1244              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
1245              name default.srcpart
1246              partition_columns ds/hr
1247              serialization.ddl struct srcpart { string key, string value}
1248              serialization.format 1
1249              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1250              transient_lastDdlTime 1297378962
1251            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1252          
1253              input format: org.apache.hadoop.mapred.TextInputFormat
1254              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1255              properties:
1256                bucket_count -1
1257                columns key,value
1258                columns.types string:string
1259                file.inputformat org.apache.hadoop.mapred.TextInputFormat
1260                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1261                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
1262                name default.srcpart
1263                partition_columns ds/hr
1264                serialization.ddl struct srcpart { string key, string value}
1265                serialization.format 1
1266                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1267                transient_lastDdlTime 1297378962
1268              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1269              name: default.srcpart
1270            name: default.srcpart
1271        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
1272          Partition
1273            base file name: hr=12
1274            input format: org.apache.hadoop.mapred.TextInputFormat
1275            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1276            partition values:
1277              ds 2008-04-08
1278              hr 12
1279            properties:
1280              bucket_count -1
1281              columns key,value
1282              columns.types string:string
1283              file.inputformat org.apache.hadoop.mapred.TextInputFormat
1284              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1285              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
1286              name default.srcpart
1287              partition_columns ds/hr
1288              serialization.ddl struct srcpart { string key, string value}
1289              serialization.format 1
1290              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1291              transient_lastDdlTime 1297378962
1292            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1293          
1294              input format: org.apache.hadoop.mapred.TextInputFormat
1295              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1296              properties:
1297                bucket_count -1
1298                columns key,value
1299                columns.types string:string
1300                file.inputformat org.apache.hadoop.mapred.TextInputFormat
1301                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1302                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
1303                name default.srcpart
1304                partition_columns ds/hr
1305                serialization.ddl struct srcpart { string key, string value}
1306                serialization.format 1
1307                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1308                transient_lastDdlTime 1297378962
1309              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1310              name: default.srcpart
1311            name: default.srcpart
1312      Reduce Operator Tree:
1313        Extract
1314          File Output Operator
1315            compressed: false
1316            GlobalTableId: 0
1317            directory: file:/tmp/sdong/hive_2011-02-10_15-57-11_395_7120694435411643442/-ext-10001
1318            NumFilesPerFileSink: 1
1319            Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_15-57-11_395_7120694435411643442/-ext-10001/
1320            table:
1321                input format: org.apache.hadoop.mapred.TextInputFormat
1322                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1323                properties:
1324                  columns _col0,_col1,_col2,_col3
1325                  columns.types string:string:string:string
1326                  serialization.format 1
1327            TotalFiles: 1
1328            GatherStats: false
1329            MultiFileSpray: false
1330
1331  Stage: Stage-0
1332    Fetch Operator
1333      limit: -1
1334
1335
1336PREHOOK: query: select * from srcpart a where a.ds='2008-04-08' and key < 200 order by a.key, a.hr
1337PREHOOK: type: QUERY
1338PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
1339PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
1340PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-57-11_528_2337093511070491628/-mr-10000
1341POSTHOOK: query: select * from srcpart a where a.ds='2008-04-08' and key < 200 order by a.key, a.hr
1342POSTHOOK: type: QUERY
1343POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
1344POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
1345POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-57-11_528_2337093511070491628/-mr-10000
13460	val_0	2008-04-08	11
13470	val_0	2008-04-08	11
13480	val_0	2008-04-08	11
13490	val_0	2008-04-08	12
13500	val_0	2008-04-08	12
13510	val_0	2008-04-08	12
135210	val_10	2008-04-08	11
135310	val_10	2008-04-08	12
1354100	val_100	2008-04-08	11
1355100	val_100	2008-04-08	11
1356100	val_100	2008-04-08	12
1357100	val_100	2008-04-08	12
1358103	val_103	2008-04-08	11
1359103	val_103	2008-04-08	11
1360103	val_103	2008-04-08	12
1361103	val_103	2008-04-08	12
1362104	val_104	2008-04-08	11
1363104	val_104	2008-04-08	11
1364104	val_104	2008-04-08	12
1365104	val_104	2008-04-08	12
1366105	val_105	2008-04-08	11
1367105	val_105	2008-04-08	12
136811	val_11	2008-04-08	11
136911	val_11	2008-04-08	12
1370111	val_111	2008-04-08	11
1371111	val_111	2008-04-08	12
1372113	val_113	2008-04-08	11
1373113	val_113	2008-04-08	11
1374113	val_113	2008-04-08	12
1375113	val_113	2008-04-08	12
1376114	val_114	2008-04-08	11
1377114	val_114	2008-04-08	12
1378116	val_116	2008-04-08	11
1379116	val_116	2008-04-08	12
1380118	val_118	2008-04-08	11
1381118	val_118	2008-04-08	11
1382118	val_118	2008-04-08	12
1383118	val_118	2008-04-08	12
1384119	val_119	2008-04-08	11
1385119	val_119	2008-04-08	11
1386119	val_119	2008-04-08	11
1387119	val_119	2008-04-08	12
1388119	val_119	2008-04-08	12
1389119	val_119	2008-04-08	12
139012	val_12	2008-04-08	11
139112	val_12	2008-04-08	11
139212	val_12	2008-04-08	12
139312	val_12	2008-04-08	12
1394120	val_120	2008-04-08	11
1395120	val_120	2008-04-08	11
1396120	val_120	2008-04-08	12
1397120	val_120	2008-04-08	12
1398125	val_125	2008-04-08	11
1399125	val_125	2008-04-08	11
1400125	val_125	2008-04-08	12
1401125	val_125	2008-04-08	12
1402126	val_126	2008-04-08	11
1403126	val_126	2008-04-08	12
1404128	val_128	2008-04-08	11
1405128	val_128	2008-04-08	11
1406128	val_128	2008-04-08	11
1407128	val_128	2008-04-08	12
1408128	val_128	2008-04-08	12
1409128	val_128	2008-04-08	12
1410129	val_129	2008-04-08	11
1411129	val_129	2008-04-08	11
1412129	val_129	2008-04-08	12
1413129	val_129	2008-04-08	12
1414131	val_131	2008-04-08	11
1415131	val_131	2008-04-08	12
1416133	val_133	2008-04-08	11
1417133	val_133	2008-04-08	12
1418134	val_134	2008-04-08	11
1419134	val_134	2008-04-08	11
1420134	val_134	2008-04-08	12
1421134	val_134	2008-04-08	12
1422136	val_136	2008-04-08	11
1423136	val_136	2008-04-08	12
1424137	val_137	2008-04-08	11
1425137	val_137	2008-04-08	11
1426137	val_137	2008-04-08	12
1427137	val_137	2008-04-08	12
1428138	val_138	2008-04-08	11
1429138	val_138	2008-04-08	11
1430138	val_138	2008-04-08	11
1431138	val_138	2008-04-08	11
1432138	val_138	2008-04-08	12
1433138	val_138	2008-04-08	12
1434138	val_138	2008-04-08	12
1435138	val_138	2008-04-08	12
1436143	val_143	2008-04-08	11
1437143	val_143	2008-04-08	12
1438145	val_145	2008-04-08	11
1439145	val_145	2008-04-08	12
1440146	val_146	2008-04-08	11
1441146	val_146	2008-04-08	11
1442146	val_146	2008-04-08	12
1443146	val_146	2008-04-08	12
1444149	val_149	2008-04-08	11
1445149	val_149	2008-04-08	11
1446149	val_149	2008-04-08	12
1447149	val_149	2008-04-08	12
144815	val_15	2008-04-08	11
144915	val_15	2008-04-08	11
145015	val_15	2008-04-08	12
145115	val_15	2008-04-08	12
1452150	val_150	2008-04-08	11
1453150	val_150	2008-04-08	12
1454152	val_152	2008-04-08	11
1455152	val_152	2008-04-08	11
1456152	val_152	2008-04-08	12
1457152	val_152	2008-04-08	12
1458153	val_153	2008-04-08	11
1459153	val_153	2008-04-08	12
1460155	val_155	2008-04-08	11
1461155	val_155	2008-04-08	12
1462156	val_156	2008-04-08	11
1463156	val_156	2008-04-08	12
1464157	val_157	2008-04-08	11
1465157	val_157	2008-04-08	12
1466158	val_158	2008-04-08	11
1467158	val_158	2008-04-08	12
1468160	val_160	2008-04-08	11
1469160	val_160	2008-04-08	12
1470162	val_162	2008-04-08	11
1471162	val_162	2008-04-08	12
1472163	val_163	2008-04-08	11
1473163	val_163	2008-04-08	12
1474164	val_164	2008-04-08	11
1475164	val_164	2008-04-08	11
1476164	val_164	2008-04-08	12
1477164	val_164	2008-04-08	12
1478165	val_165	2008-04-08	11
1479165	val_165	2008-04-08	11
1480165	val_165	2008-04-08	12
1481165	val_165	2008-04-08	12
1482166	val_166	2008-04-08	11
1483166	val_166	2008-04-08	12
1484167	val_167	2008-04-08	11
1485167	val_167	2008-04-08	11
1486167	val_167	2008-04-08	11
1487167	val_167	2008-04-08	12
1488167	val_167	2008-04-08	12
1489167	val_167	2008-04-08	12
1490168	val_168	2008-04-08	11
1491168	val_168	2008-04-08	12
1492169	val_169	2008-04-08	11
1493169	val_169	2008-04-08	11
1494169	val_169	2008-04-08	11
1495169	val_169	2008-04-08	11
1496169	val_169	2008-04-08	12
1497169	val_169	2008-04-08	12
1498169	val_169	2008-04-08	12
1499169	val_169	2008-04-08	12
150017	val_17	2008-04-08	11
150117	val_17	2008-04-08	12
1502170	val_170	2008-04-08	11
1503170	val_170	2008-04-08	12
1504172	val_172	2008-04-08	11
1505172	val_172	2008-04-08	11
1506172	val_172	2008-04-08	12
1507172	val_172	2008-04-08	12
1508174	val_174	2008-04-08	11
1509174	val_174	2008-04-08	11
1510174	val_174	2008-04-08	12
1511174	val_174	2008-04-08	12
1512175	val_175	2008-04-08	11
1513175	val_175	2008-04-08	11
1514175	val_175	2008-04-08	12
1515175	val_175	2008-04-08	12
1516176	val_176	2008-04-08	11
1517176	val_176	2008-04-08	11
1518176	val_176	2008-04-08	12
1519176	val_176	2008-04-08	12
1520177	val_177	2008-04-08	11
1521177	val_177	2008-04-08	12
1522178	val_178	2008-04-08	11
1523178	val_178	2008-04-08	12
1524179	val_179	2008-04-08	11
1525179	val_179	2008-04-08	11
1526179	val_179	2008-04-08	12
1527179	val_179	2008-04-08	12
152818	val_18	2008-04-08	11
152918	val_18	2008-04-08	11
153018	val_18	2008-04-08	12
153118	val_18	2008-04-08	12
1532180	val_180	2008-04-08	11
1533180	val_180	2008-04-08	12
1534181	val_181	2008-04-08	11
1535181	val_181	2008-04-08	12
1536183	val_183	2008-04-08	11
1537183	val_183	2008-04-08	12
1538186	val_186	2008-04-08	11
1539186	val_186	2008-04-08	12
1540187	val_187	2008-04-08	11
1541187	val_187	2008-04-08	11
1542187	val_187	2008-04-08	11
1543187	val_187	2008-04-08	12
1544187	val_187	2008-04-08	12
1545187	val_187	2008-04-08	12
1546189	val_189	2008-04-08	11
1547189	val_189	2008-04-08	12
154819	val_19	2008-04-08	11
154919	val_19	2008-04-08	12
1550190	val_190	2008-04-08	11
1551190	val_190	2008-04-08	12
1552191	val_191	2008-04-08	11
1553191	val_191	2008-04-08	11
1554191	val_191	2008-04-08	12
1555191	val_191	2008-04-08	12
1556192	val_192	2008-04-08	11
1557192	val_192	2008-04-08	12
1558193	val_193	2008-04-08	11
1559193	val_193	2008-04-08	11
1560193	val_193	2008-04-08	11
1561193	val_193	2008-04-08	12
1562193	val_193	2008-04-08	12
1563193	val_193	2008-04-08	12
1564194	val_194	2008-04-08	11
1565194	val_194	2008-04-08	12
1566195	val_195	2008-04-08	11
1567195	val_195	2008-04-08	11
1568195	val_195	2008-04-08	12
1569195	val_195	2008-04-08	12
1570196	val_196	2008-04-08	11
1571196	val_196	2008-04-08	12
1572197	val_197	2008-04-08	11
1573197	val_197	2008-04-08	11
1574197	val_197	2008-04-08	12
1575197	val_197	2008-04-08	12
1576199	val_199	2008-04-08	11
1577199	val_199	2008-04-08	11
1578199	val_199	2008-04-08	11
1579199	val_199	2008-04-08	12
1580199	val_199	2008-04-08	12
1581199	val_199	2008-04-08	12
15822	val_2	2008-04-08	11
15832	val_2	2008-04-08	12
158420	val_20	2008-04-08	11
158520	val_20	2008-04-08	12
158624	val_24	2008-04-08	11
158724	val_24	2008-04-08	11
158824	val_24	2008-04-08	12
158924	val_24	2008-04-08	12
159026	val_26	2008-04-08	11
159126	val_26	2008-04-08	11
159226	val_26	2008-04-08	12
159326	val_26	2008-04-08	12
159427	val_27	2008-04-08	11
159527	val_27	2008-04-08	12
159628	val_28	2008-04-08	11
159728	val_28	2008-04-08	12
159830	val_30	2008-04-08	11
159930	val_30	2008-04-08	12
160033	val_33	2008-04-08	11
160133	val_33	2008-04-08	12
160234	val_34	2008-04-08	11
160334	val_34	2008-04-08	12
160435	val_35	2008-04-08	11
160535	val_35	2008-04-08	11
160635	val_35	2008-04-08	11
160735	val_35	2008-04-08	12
160835	val_35	2008-04-08	12
160935	val_35	2008-04-08	12
161037	val_37	2008-04-08	11
161137	val_37	2008-04-08	11
161237	val_37	2008-04-08	12
161337	val_37	2008-04-08	12
16144	val_4	2008-04-08	11
16154	val_4	2008-04-08	12
161641	val_41	2008-04-08	11
161741	val_41	2008-04-08	12
161842	val_42	2008-04-08	11
161942	val_42	2008-04-08	11
162042	val_42	2008-04-08	12
162142	val_42	2008-04-08	12
162243	val_43	2008-04-08	11
162343	val_43	2008-04-08	12
162444	val_44	2008-04-08	11
162544	val_44	2008-04-08	12
162647	val_47	2008-04-08	11
162747	val_47	2008-04-08	12
16285	val_5	2008-04-08	11
16295	val_5	2008-04-08	11
16305	val_5	2008-04-08	11
16315	val_5	2008-04-08	12
16325	val_5	2008-04-08	12
16335	val_5	2008-04-08	12
163451	val_51	2008-04-08	11
163551	val_51	2008-04-08	11
163651	val_51	2008-04-08	12
163751	val_51	2008-04-08	12
163853	val_53	2008-04-08	11
163953	val_53	2008-04-08	12
164054	val_54	2008-04-08	11
164154	val_54	2008-04-08	12
164257	val_57	2008-04-08	11
164357	val_57	2008-04-08	12
164458	val_58	2008-04-08	11
164558	val_58	2008-04-08	11
164658	val_58	2008-04-08	12
164758	val_58	2008-04-08	12
164864	val_64	2008-04-08	11
164964	val_64	2008-04-08	12
165065	val_65	2008-04-08	11
165165	val_65	2008-04-08	12
165266	val_66	2008-04-08	11
165366	val_66	2008-04-08	12
165467	val_67	2008-04-08	11
165567	val_67	2008-04-08	11
165667	val_67	2008-04-08	12
165767	val_67	2008-04-08	12
165869	val_69	2008-04-08	11
165969	val_69	2008-0…

Large files files are truncated, but you can click here to view the full file