Saving all output to "!!{outputDirectory}!!/merge3.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/merge3.q >>> set hive.merge.mapfiles=false; No rows affected >>> set hive.merge.mapredfiles=false; No rows affected >>> set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; No rows affected >>> set hive.exec.dynamic.partition=true; No rows affected >>> set hive.exec.dynamic.partition.mode=nonstrict; No rows affected >>> >>> create table merge_src as select key, value from srcpart where ds is not null; 'key','value' No rows selected >>> >>> create table merge_src_part (key string, value string) partitioned by (ds string); No rows affected >>> insert overwrite table merge_src_part partition(ds) select key, value, ds from srcpart where ds is not null; 'key','value','ds' No rows selected >>> >>> set hive.merge.mapfiles=true; No rows affected >>> set hive.merge.mapredfiles=true; No rows affected >>> >>> explain extended create table merge_src2 as select key, value from merge_src; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_CREATETABLE (TOK_TABNAME merge_src2) TOK_LIKETABLE (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME merge_src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value))))))' '' 'STAGE DEPENDENCIES:' ' Stage-1 is a root stage' ' Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5' ' Stage-4' ' Stage-0 depends on stages: Stage-4, Stage-3, Stage-6' ' Stage-8 depends on stages: Stage-0' ' Stage-2 depends on stages: Stage-8' ' Stage-3' ' Stage-5' ' Stage-6 depends on stages: Stage-5' '' 'STAGE PLANS:' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' merge_src ' ' TableScan' ' alias: merge_src' ' GatherStats: false' ' Select Operator' ' expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' outputColumnNames: _col0, _col1' ' File Output Operator' ' compressed: false' ' GlobalTableId: 1' ' directory: pfile:!!{hive.exec.scratchdir}!!' ' NumFilesPerFileSink: 1' ' Stats Publishing Key Prefix: pfile:!!{hive.exec.scratchdir}!!' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' columns _col0,_col1' ' columns.types string:string' ' name merge3.merge_src2' ' serialization.format 1' ' name: merge3.merge_src2' ' TotalFiles: 1' ' GatherStats: true' ' MultiFileSpray: false' ' Needs Tagging: false' ' Path -> Alias:' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src [merge_src]' ' Path -> Partition:' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src ' ' Partition' ' base file name: merge_src' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src' ' name merge3.merge_src' ' numFiles 4' ' numPartitions 0' ' numRows 2000' ' rawDataSize 21248' ' serialization.ddl struct merge_src { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 23248' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src' ' name merge3.merge_src' ' numFiles 4' ' numPartitions 0' ' numRows 2000' ' rawDataSize 21248' ' serialization.ddl struct merge_src { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 23248' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src' ' name: merge3.merge_src' '' ' Stage: Stage-7' ' Conditional Operator' '' ' Stage: Stage-4' ' Move Operator' ' files:' ' hdfs directory: true' ' source: pfile:!!{hive.exec.scratchdir}!!' ' destination: pfile:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-0' ' Move Operator' ' files:' ' hdfs directory: true' ' source: pfile:!!{hive.exec.scratchdir}!!' ' destination: !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src2' '' ' Stage: Stage-8' ' Create Table Operator:' ' Create Table' ' columns: key string, value string' ' if not exists: false' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' # buckets: -1' ' output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' ' name: merge_src2' ' isExternal: false' '' ' Stage: Stage-2' ' Stats-Aggr Operator' ' Stats Aggregation Key Prefix: pfile:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-3' ' Map Reduce' ' Alias -> Map Operator Tree:' ' pfile:!!{hive.exec.scratchdir}!! ' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' directory: pfile:!!{hive.exec.scratchdir}!!' ' NumFilesPerFileSink: 1' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' columns _col0,_col1' ' columns.types string:string' ' name merge3.merge_src2' ' serialization.format 1' ' name: merge3.merge_src2' ' TotalFiles: 1' ' GatherStats: false' ' MultiFileSpray: false' ' Needs Tagging: false' ' Path -> Alias:' ' pfile:!!{hive.exec.scratchdir}!! [pfile:!!{hive.exec.scratchdir}!!]' ' Path -> Partition:' ' pfile:!!{hive.exec.scratchdir}!! ' ' Partition' ' base file name: -ext-10002' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' columns _col0,_col1' ' columns.types string:string' ' name merge3.merge_src2' ' serialization.format 1' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' columns _col0,_col1' ' columns.types string:string' ' name merge3.merge_src2' ' serialization.format 1' ' name: merge3.merge_src2' ' name: merge3.merge_src2' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' pfile:!!{hive.exec.scratchdir}!! ' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' directory: pfile:!!{hive.exec.scratchdir}!!' ' NumFilesPerFileSink: 1' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' columns _col0,_col1' ' columns.types string:string' ' name merge3.merge_src2' ' serialization.format 1' ' name: merge3.merge_src2' ' TotalFiles: 1' ' GatherStats: false' ' MultiFileSpray: false' ' Needs Tagging: false' ' Path -> Alias:' ' pfile:!!{hive.exec.scratchdir}!! [pfile:!!{hive.exec.scratchdir}!!]' ' Path -> Partition:' ' pfile:!!{hive.exec.scratchdir}!! ' ' Partition' ' base file name: -ext-10002' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' columns _col0,_col1' ' columns.types string:string' ' name merge3.merge_src2' ' serialization.format 1' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' columns _col0,_col1' ' columns.types string:string' ' name merge3.merge_src2' ' serialization.format 1' ' name: merge3.merge_src2' ' name: merge3.merge_src2' '' ' Stage: Stage-6' ' Move Operator' ' files:' ' hdfs directory: true' ' source: pfile:!!{hive.exec.scratchdir}!!' ' destination: pfile:!!{hive.exec.scratchdir}!!' '' '' 230 rows selected >>> >>> create table merge_src2 as select key, value from merge_src; 'key','value' No rows selected >>> >>> select * from merge_src2 ORDER BY key ASC, value ASC; 'key','value' '0','val_0' '0','val_0' '0','val_0' '0','val_0' '0','val_0' '0','val_0' '0','val_0' '0','val_0' '0','val_0' '0','val_0' '0','val_0' '0','val_0' '10','val_10' '10','val_10' '10','val_10' '10','val_10' '100','val_100' '100','val_100' '100','val_100' '100','val_100' '100','val_100' '100','val_100' '100','val_100' '100','val_100' '103','val_103' '103','val_103' '103','val_103' '103','val_103' '103','val_103' '103','val_103' '103','val_103' '103','val_103' '104','val_104' '104','val_104' '104','val_104' '104','val_104' '104','val_104' '104','val_104' '104','val_104' '104','val_104' '105','val_105' '105','val_105' '105','val_105' '105','val_105' '11','val_11' '11','val_11' '11','val_11' '11','val_11' '111','val_111' '111','val_111' '111','val_111' '111','val_111' '113','val_113' '113','val_113' '113','val_113' '113','val_113' '113','val_113' '113','val_113' '113','val_113' '113','val_113' '114','val_114' '114','val_114' '114','val_114' '114','val_114' '116','val_116' '116','val_116' '116','val_116' '116','val_116' '118','val_118' '118','val_118' '118','val_118' '118','val_118' '118','val_118' '118','val_118' '118','val_118' '118','val_118' '119','val_119' '119','val_119' '119','val_119' '119','val_119' '119','val_119' '119','val_119' '119','val_119' '119','val_119' '119','val_119' '119','val_119' '119','val_119' '119','val_119' '12','val_12' '12','val_12' '12','val_12' '12','val_12' '12','val_12' '12','val_12' '12','val_12' '12','val_12' '120','val_120' '120','val_120' '120','val_120' '120','val_120' '120','val_120' '120','val_120' '120','val_120' '120','val_120' '125','val_125' '125','val_125' '125','val_125' '125','val_125' '125','val_125' '125','val_125' '125','val_125' '125','val_125' '126','val_126' '126','val_126' '126','val_126' '126','val_126' '128','val_128' '128','val_128' '128','val_128' '128','val_128' '128','val_128' '128','val_128' '128','val_128' '128','val_128' '128','val_128' '128','val_128' '128','val_128' '128','val_128' '129','val_129' '129','val_129' '129','val_129' '129','val_129' '129','val_129' '129','val_129' '129','val_129' '129','val_129' '131','val_131' '131','val_131' '131','val_131' '131','val_131' '133','val_133' '133','val_133' '133','val_133' '133','val_133' '134','val_134' '134','val_134' '134','val_134' '134','val_134' '134','val_134' '134','val_134' '134','val_134' '134','val_134' '136','val_136' '136','val_136' '136','val_136' '136','val_136' '137','val_137' '137','val_137' '137','val_137' '137','val_137' '137','val_137' '137','val_137' '137','val_137' '137','val_137' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '138','val_138' '143','val_143' '143','val_143' '143','val_143' '143','val_143' '145','val_145' '145','val_145' '145','val_145' '145','val_145' '146','val_146' '146','val_146' '146','val_146' '146','val_146' '146','val_146' '146','val_146' '146','val_146' '146','val_146' '149','val_149' '149','val_149' '149','val_149' '149','val_149' '149','val_149' '149','val_149' '149','val_149' '149','val_149' '15','val_15' '15','val_15' '15','val_15' '15','val_15' '15','val_15' '15','val_15' '15','val_15' '15','val_15' '150','val_150' '150','val_150' '150','val_150' '150','val_150' '152','val_152' '152','val_152' '152','val_152' '152','val_152' '152','val_152' '152','val_152' '152','val_152' '152','val_152' '153','val_153' '153','val_153' '153','val_153' '153','val_153' '155','val_155' '155','val_155' '155','val_155' '155','val_155' '156','val_156' '156','val_156' '156','val_156' '156','val_156' '157','val_157' '157','val_157' '157','val_157' '157','val_157' '158','val_158' '158','val_158' '158','val_158' '158','val_158' '160','val_160' '160','val_160' '160','val_160' '160','val_160' '162','val_162' '162','val_162' '162','val_162' '162','val_162' '163','val_163' '163','val_163' '163','val_163' '163','val_163' '164','val_164' '164','val_164' '164','val_164' '164','val_164' '164','val_164' '164','val_164' '164','val_164' '164','val_164' '165','val_165' '165','val_165' '165','val_165' '165','val_165' '165','val_165' '165','val_165' '165','val_165' '165','val_165' '166','val_166' '166','val_166' '166','val_166' '166','val_166' '167','val_167' '167','val_167' '167','val_167' '167','val_167' '167','val_167' '167','val_167' '167','val_167' '167','val_167' '167','val_167' '167','val_167' '167','val_167' '167','val_167' '168','val_168' '168','val_168' '168','val_168' '168','val_168' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '169','val_169' '17','val_17' '17','val_17' '17','val_17' '17','val_17' '170','val_170' '170','val_170' '170','val_170' '170','val_170' '172','val_172' '172','val_172' '172','val_172' '172','val_172' '172','val_172' '172','val_172' '172','val_172' '172','val_172' '174','val_174' '174','val_174' '174','val_174' '174','val_174' '174','val_174' '174','val_174' '174','val_174' '174','val_174' '175','val_175' '175','val_175' '175','val_175' '175','val_175' '175','val_175' '175','val_175' '175','val_175' '175','val_175' '176','val_176' '176','val_176' '176','val_176' '176','val_176' '176','val_176' '176','val_176' '176','val_176' '176','val_176' '177','val_177' '177','val_177' '177','val_177' '177','val_177' '178','val_178' '178','val_178' '178','val_178' '178','val_178' '179','val_179' '179','val_179' '179','val_179' '179','val_179' '179','val_179' '179','val_179' '179','val_179' '179','val_179' '18','val_18' '18','val_18' '18','val_18' '18','val_18' '18','val_18' '18','val_18' '18','val_18' '18','val_18' '180','val_180' '180','val_180' '180','val_180' '180','val_180' '181','val_181' '181','val_181' '181','val_181' '181','val_181' '183','val_183' '183','val_183' '183','val_183' '183','val_183' '186','val_186' '186','val_186' '186','val_186' '186','val_186' '187','val_187' '187','val_187' '187','val_187' '187','val_187' '187','val_187' '187','val_187' '187','val_187' '187','val_187' '187','val_187' '187','val_187' '187','val_187' '187','val_187' '189','val_189' '189','val_189' '189','val_189' '189','val_189' '19','val_19' '19','val_19' '19','val_19' '19','val_19' '190','val_190' '190','val_190' '190','val_190' '190','val_190' '191','val_191' '191','val_191' '191','val_191' '191','val_191' '191','val_191' '191','val_191' '191','val_191' '191','val_191' '192','val_192' '192','val_192' '192','val_192' '192','val_192' '193','val_193' '193','val_193' '193','val_193' '193','val_193' '193','val_193' '193','val_193' '193','val_193' '193','val_193' '193','val_193' '193','val_193' '193','val_193' '193','val_193' '194','val_194' '194','val_194' '194','val_194' '194','val_194' '195','val_195' '195','val_195' '195','val_195' '195','val_195' '195','val_195' '195','val_195' '195','val_195' '195','val_195' '196','val_196' '196','val_196' '196','val_196' '196','val_196' '197','val_197' '197','val_197' '197','val_197' '197','val_197' '197','val_197' '197','val_197' '197','val_197' '197','val_197' '199','val_199' '199','val_199' '199','val_199' '199','val_199' '199','val_199' '199','val_199' '199','val_199' '199','val_199' '199','val_199' '199','val_199' '199','val_199' '199','val_199' '2','val_2' '2','val_2' '2','val_2' '2','val_2' '20','val_20' '20','val_20' '20','val_20' '20','val_20' '200','val_200' '200','val_200' '200','val_200' '200','val_200' '200','val_200' '200','val_200' '200','val_200' '200','val_200' '201','val_201' '201','val_201' '201','val_201' '201','val_201' '202','val_202' '202','val_202' '202','val_202' '202','val_202' '203','val_203' '203','val_203' '203','val_203' '203','val_203' '203','val_203' '203','val_203' '203','val_203' '203','val_203' '205','val_205' '205','val_205' '205','val_205' '205','val_205' '205','val_205' '205','val_205' '205','val_205' '205','val_205' '207','val_207' '207','val_207' '207','val_207' '207','val_207' '207','val_207' '207','val_207' '207','val_207' '207','val_207' '208','val_208' '208','val_208' '208','val_208' '208','val_208' '208','val_208' '208','val_208' '208','val_208' '208','val_208' '208','val_208' '208','val_208' '208','val_208' '208','val_208' '209','val_209' '209','val_209' '209','val_209' '209','val_209' '209','val_209' '209','val_209' '209','val_209' '209','val_209' '213','val_213' '213','val_213' '213','val_213' '213','val_213' '213','val_213' '213','val_213' '213','val_213' '213','val_213' '214','val_214' '214','val_214' '214','val_214' '214','val_214' '216','val_216' '216','val_216' '216','val_216' '216','val_216' '216','val_216' '216','val_216' '216','val_216' '216','val_216' '217','val_217' '217','val_217' '217','val_217' '217','val_217' '217','val_217' '217','val_217' '217','val_217' '217','val_217' '218','val_218' '218','val_218' '218','val_218' '218','val_218' '219','val_219' '219','val_219' '219','val_219' '219','val_219' '219','val_219' '219','val_219' '219','val_219' '219','val_219' '221','val_221' '221','val_221' '221','val_221' '221','val_221' '221','val_221' '221','val_221' '221','val_221' '221','val_221' '222','val_222' '222','val_222' '222','val_222' '222','val_222' '223','val_223' '223','val_223' '223','val_223' '223','val_223' '223','val_223' '223','val_223' '223','val_223' '223','val_223' '224','val_224' '224','val_224' '224','val_224' '224','val_224' '224','val_224' '224','val_224' '224','val_224' '224','val_224' '226','val_226' '226','val_226' '226','val_226' '226','val_226' '228','val_228' '228','val_228' '228','val_228' '228','val_228' '229','val_229' '229','val_229' '229','val_229' '229','val_229' '229','val_229' '229','val_229' '229','val_229' '229','val_229' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '230','val_230' '233','val_233' '233','val_233' '233','val_233' '233','val_233' '233','val_233' '233','val_233' '233','val_233' '233','val_233' '235','val_235' '235','val_235' '235','val_235' '235','val_235' '237','val_237' '237','val_237' '237','val_237' '237','val_237' '237','val_237' '237','val_237' '237','val_237' '237','val_237' '238','val_238' '238','val_238' '238','val_238' '238','val_238' '238','val_238' '238','val_238' '238','val_238' '238','val_238' '239','val_239' '239','val_239' '239','val_239' '239','val_239' '239','val_239' '239','val_239' '239','val_239' '239','val_239' '24','val_24' '24','val_24' '24','val_24' '24','val_24' '24','val_24' '24','val_24' '24','val_24' '24','val_24' '241','val_241' '241','val_241' '241','val_241' '241','val_241' '242','val_242' '242','val_242' '242','val_242' '242','val_242' '242','val_242' '242','val_242' '242','val_242' '242','val_242' '244','val_244' '244','val_244' '244','val_244' '244','val_244' '247','val_247' '247','val_247' '247','val_247' '247','val_247' '248','val_248' '248','val_248' '248','val_248' '248','val_248' '249','val_249' '249','val_249' '249','val_249' '249','val_249' '252','val_252' '252','val_252' '252','val_252' '252','val_252' '255','val_255' '255','val_255' '255','val_255' '255','val_255' '255','val_255' '255','val_255' '255','val_255' '255','val_255' '256','val_256' '256','val_256' '256','val_256' '256','val_256' '256','val_256' '256','val_256' '256','val_256' '256','val_256' '257','val_257' '257','val_257' '257','val_257' '257','val_257' '258','val_258' '258','val_258' '258','val_258' '258','val_258' '26','val_26' '26','val_26' '26','val_26' '26','val_26' '26','val_26' '26','val_26' '26','val_26' '26','val_26' '260','val_260' '260','val_260' '260','val_260' '260','val_260' '262','val_262' '262','val_262' '262','val_262' '262','val_262' '263','val_263' '263','val_263' '263','val_263' '263','val_263' '265','val_265' '265','val_265' '265','val_265' '265','val_265' '265','val_265' '265','val_265' '265','val_265' '265','val_265' '266','val_266' '266','val_266' '266','val_266' '266','val_266' '27','val_27' '27','val_27' '27','val_27' '27','val_27' '272','val_272' '272','val_272' '272','val_272' '272','val_272' '272','val_272' '272','val_272' '272','val_272' '272','val_272' '273','val_273' '273','val_273' '273','val_273' '273','val_273' '273','val_273' '273','val_273' '273','val_273' '273','val_273' '273','val_273' '273','val_273' '273','val_273' '273','val_273' '274','val_274' '274','val_274' '274','val_274' '274','val_274' '275','val_275' '275','val_275' '275','val_275' '275','val_275' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '277','val_277' '278','val_278' '278','val_278' '278','val_278' '278','val_278' '278','val_278' '278','val_278' '278','val_278' '278','val_278' '28','val_28' '28','val_28' '28','val_28' '28','val_28' '280','val_280' '280','val_280' '280','val_280' '280','val_280' '280','val_280' '280','val_280' '280','val_280' '280','val_280' '281','val_281' '281','val_281' '281','val_281' '281','val_281' '281','val_281' '281','val_281' '281','val_281' '281','val_281' '282','val_282' '282','val_282' '282','val_282' '282','val_282' '282','val_282' '282','val_282' '282','val_282' '282','val_282' '283','val_283' '283','val_283' '283','val_283' '283','val_283' '284','val_284' '284','val_284' '284','val_284' '284','val_284' '285','val_285' '285','val_285' '285','val_285' '285','val_285' '286','val_286' '286','val_286' '286','val_286' '286','val_286' '287','val_287' '287','val_287' '287','val_287' '287','val_287' '288','val_288' '288','val_288' '288','val_288' '288','val_288' '288','val_288' '288','val_288' '288','val_288' '288','val_288' '289','val_289' '289','val_289' '289','val_289' '289','val_289' '291','val_291' '291','val_291' '291','val_291' '291','val_291' '292','val_292' '292','val_292' '292','val_292' '292','val_292' '296','val_296' '296','val_296' '296','val_296' '296','val_296' '298','val_298' '298','val_298' '298','val_298' '298','val_298' '298','val_298' '298','val_298' '298','val_298' '298','val_298' '298','val_298' '298','val_298' '298','val_298' '298','val_298' '30','val_30' '30','val_30' '30','val_30' '30','val_30' '302','val_302' '302','val_302' '302','val_302' '302','val_302' '305','val_305' '305','val_305' '305','val_305' '305','val_305' '306','val_306' '306','val_306' '306','val_306' '306','val_306' '307','val_307' '307','val_307' '307','val_307' '307','val_307' '307','val_307' '307','val_307' '307','val_307' '307','val_307' '308','val_308' '308','val_308' '308','val_308' '308','val_308' '309','val_309' '309','val_309' '309','val_309' '309','val_309' '309','val_309' '309','val_309' '309','val_309' '309','val_309' '310','val_310' '310','val_310' '310','val_310' '310','val_310' '311','val_311' '311','val_311' '311','val_311' '311','val_311' '311','val_311' '311','val_311' '311','val_311' '311','val_311' '311','val_311' '311','val_311' '311','val_311' '311','val_311' '315','val_315' '315','val_315' '315','val_315' '315','val_315' '316','val_316' '316','val_316' '316','val_316' '316','val_316' '316','val_316' '316','val_316' '316','val_316' '316','val_316' '316','val_316' '316','val_316' '316','val_316' '316','val_316' '317','val_317' '317','val_317' '317','val_317' '317','val_317' '317','val_317' '317','val_317' '317','val_317' '317','val_317' '318','val_318' '318','val_318' '318','val_318' '318','val_318' '318','val_318' '318','val_318' '318','val_318' '318','val_318' '318','val_318' '318','val_318' '318','val_318' '318','val_318' '321','val_321' '321','val_321' '321','val_321' '321','val_321' '321','val_321' '321','val_321' '321','val_321' '321','val_321' '322','val_322' '322','val_322' '322','val_322' '322','val_322' '322','val_322' '322','val_322' '322','val_322' '322','val_322' '323','val_323' '323','val_323' '323','val_323' '323','val_323' '325','val_325' '325','val_325' '325','val_325' '325','val_325' '325','val_325' '325','val_325' '325','val_325' '325','val_325' '327','val_327' '327','val_327' '327','val_327' '327','val_327' '327','val_327' '327','val_327' '327','val_327' '327','val_327' '327','val_327' '327','val_327' '327','val_327' '327','val_327' '33','val_33' '33','val_33' '33','val_33' '33','val_33' '331','val_331' '331','val_331' '331','val_331' '331','val_331' '331','val_331' '331','val_331' '331','val_331' '331','val_331' '332','val_332' '332','val_332' '332','val_332' '332','val_332' '333','val_333' '333','val_333' '333','val_333' '333','val_333' '333','val_333' '333','val_333' '333','val_333' '333','val_333' '335','val_335' '335','val_335' '335','val_335' '335','val_335' '336','val_336' '336','val_336' '336','val_336' '336','val_336' '338','val_338' '338','val_338' '338','val_338' '338','val_338' '339','val_339' '339','val_339' '339','val_339' '339','val_339' '34','val_34' '34','val_34' '34','val_34' '34','val_34' '341','val_341' '341','val_341' '341','val_341' '341','val_341' '342','val_342' '342','val_342' '342','val_342' '342','val_342' '342','val_342' '342','val_342' '342','val_342' '342','val_342' '344','val_344' '344','val_344' '344','val_344' '344','val_344' '344','val_344' '344','val_344' '344','val_344' '344','val_344' '345','val_345' '345','val_345' '345','val_345' '345','val_345' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '348','val_348' '35','val_35' '35','val_35' '35','val_35' '35','val_35' '35','val_35' '35','val_35' '35','val_35' '35','val_35' '35','val_35' '35','val_35' '35','val_35' '35','val_35' '351','val_351' '351','val_351' '351','val_351' '351','val_351' '353','val_353' '353','val_353' '353','val_353' '353','val_353' '353','val_353' '353','val_353' '353','val_353' '353','val_353' '356','val_356' '356','val_356' '356','val_356' '356','val_356' '360','val_360' '360','val_360' '360','val_360' '360','val_360' '362','val_362' '362','val_362' '362','val_362' '362','val_362' '364','val_364' '364','val_364' '364','val_364' '364','val_364' '365','val_365' '365','val_365' '365','val_365' '365','val_365' '366','val_366' '366','val_366' '366','val_366' '366','val_366' '367','val_367' '367','val_367' '367','val_367' '367','val_367' '367','val_367' '367','val_367' '367','val_367' '367','val_367' '368','val_368' '368','val_368' '368','val_368' '368','val_368' '369','val_369' '369','val_369' '369','val_369' '369','val_369' '369','val_369' '369','val_369' '369','val_369' '369','val_369' '369','val_369' '369','val_369' '369','val_369' '369','val_369' '37','val_37' '37','val_37' '37','val_37' '37','val_37' '37','val_37' '37','val_37' '37','val_37' '37','val_37' '373','val_373' '373','val_373' '373','val_373' '373','val_373' '374','val_374' '374','val_374' '374','val_374' '374','val_374' '375','val_375' '375','val_375' '375','val_375' '375','val_375' '377','val_377' '377','val_377' '377','val_377' '377','val_377' '378','val_378' '378','val_378' '378','val_378' '378','val_378' '379','val_379' '379','val_379' '379','val_379' '379','val_379' '382','val_382' '382','val_382' '382','val_382' '382','val_382' '382','val_382' '382','val_382' '382','val_382' '382','val_382' '384','val_384' '384','val_384' '384','val_384' '384','val_384' '384','val_384' '384','val_384' '384','val_384' '384','val_384' '384','val_384' '384','val_384' '384','val_384' '384','val_384' '386','val_386' '386','val_386' '386','val_386' '386','val_386' '389','val_389' '389','val_389' '389','val_389' '389','val_389' '392','val_392' '392','val_392' '392','val_392' '392','val_392' '393','val_393' '393','val_393' '393','val_393' '393','val_393' '394','val_394' '394','val_394' '394','val_394' '394','val_394' '395','val_395' '395','val_395' '395','val_395' '395','val_395' '395','val_395' '395','val_395' '395','val_395' '395','val_395' '396','val_396' '396','val_396' '396','val_396' '396','val_396' '396','val_396' '396','val_396' '396','val_396' '396','val_396' '396','val_396' '396','val_396' '396','val_396' '396','val_396' '397','val_397' '397','val_397' '397','val_397' '397','val_397' '397','val_397' '397','val_397' '397','val_397' '397','val_397' '399','val_399' '399','val_399' '399','val_399' '399','val_399' '399','val_399' '399','val_399' '399','val_399' '399','val_399' '4','val_4' '4','val_4' '4','val_4' '4','val_4' '400','val_400' '400','val_400' '400','val_400' '400','val_400' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '401','val_401' '402','val_402' '402','val_402' '402','val_402' '402','val_402' '403','val_403' '403','val_403' '403','val_403' '403','val_403' '403','val_403' '403','val_403' '403','val_403' '403','val_403' '403','val_403' '403','val_403' '403','val_403' '403','val_403' '404','val_404' '404','val_404' '404','val_404' '404','val_404' '404','val_404' '404','val_404' '404','val_404' '404','val_404' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '406','val_406' '407','val_407' '407','val_407' '407','val_407' '407','val_407' '409','val_409' '409','val_409' '409','val_409' '409','val_409' '409','val_409' '409','val_409' '409','val_409' '409','val_409' '409','val_409' '409','val_409' '409','val_409' '409','val_409' '41','val_41' '41','val_41' '41','val_41' '41','val_41' '411','val_411' '411','val_411' '411','val_411' '411','val_411' '413','val_413' '413','val_413' '413','val_413' '413','val_413' '413','val_413' '413','val_413' '413','val_413' '413','val_413' '414','val_414' '414','val_414' '414','val_414' '414','val_414' '414','val_414' '414','val_414' '414','val_414' '414','val_414' '417','val_417' '417','val_417' '417','val_417' '417','val_417' '417','val_417' '417','val_417' '417','val_417' '417','val_417' '417','val_417' '417','val_417' '417','val_417' '417','val_417' '418','val_418' '418','val_418' '418','val_418' '418','val_418' '419','val_419' '419','val_419' '419','val_419' '419','val_419' '42','val_42' '42','val_42' '42','val_42' '42','val_42' '42','val_42' '42','val_42' '42','val_42' '42','val_42' '421','val_421' '421','val_421' '421','val_421' '421','val_421' '424','val_424' '424','val_424' '424','val_424' '424','val_424' '424','val_424' '424','val_424' '424','val_424' '424','val_424' '427','val_427' '427','val_427' '427','val_427' '427','val_427' '429','val_429' '429','val_429' '429','val_429' '429','val_429' '429','val_429' '429','val_429' '429','val_429' '429','val_429' '43','val_43' '43','val_43' '43','val_43' '43','val_43' '430','val_430' '430','val_430' '430','val_430' '430','val_430' '430','val_430' '430','val_430' '430','val_430' '430','val_430' '430','val_430' '430','val_430' '430','val_430' '430','val_430' '431','val_431' '431','val_431' '431','val_431' '431','val_431' '431','val_431' '431','val_431' '431','val_431' '431','val_431' '431','val_431' '431','val_431' '431','val_431' '431','val_431' '432','val_432' '432','val_432' '432','val_432' '432','val_432' '435','val_435' '435','val_435' '435','val_435' '435','val_435' '436','val_436' '436','val_436' '436','val_436' '436','val_436' '437','val_437' '437','val_437' '437','val_437' '437','val_437' '438','val_438' '438','val_438' '438','val_438' '438','val_438' '438','val_438' '438','val_438' '438','val_438' '438','val_438' '438','val_438' '438','val_438' '438','val_438' '438','val_438' '439','val_439' '439','val_439' '439','val_439' '439','val_439' '439','val_439' '439','val_439' '439','val_439' '439','val_439' '44','val_44' '44','val_44' '44','val_44' '44','val_44' '443','val_443' '443','val_443' '443','val_443' '443','val_443' '444','val_444' '444','val_444' '444','val_444' '444','val_444' '446','val_446' '446','val_446' '446','val_446' '446','val_446' '448','val_448' '448','val_448' '448','val_448' '448','val_448' '449','val_449' '449','val_449' '449','val_449' '449','val_449' '452','val_452' '452','val_452' '452','val_452' '452','val_452' '453','val_453' '453','val_453' '453','val_453' '453','val_453' '454','val_454' '454','val_454' '454','val_454' '454','val_454' '454','val_454' '454','val_454' '454','val_454' '454','val_454' '454','val_454' '454','val_454' '454','val_454' '454','val_454' '455','val_455' '455','val_455' '455','val_455' '455','val_455' '457','val_457' '457','val_457' '457','val_457' '457','val_457' '458','val_458' '458','val_458' '458','val_458' '458','val_458' '458','val_458' '458','val_458' '458','val_458' '458','val_458' '459','val_459' '459','val_459' '459','val_459' '459','val_459' '459','val_459' '459','val_459' '459','val_459' '459','val_459' '460','val_460' '460','val_460' '460','val_460' '460','val_460' '462','val_462' '462','val_462' '462','val_462' '462','val_462' '462','val_462' '462','val_462' '462','val_462' '462','val_462' '463','val_463' '463','val_463' '463','val_463' '463','val_463' '463','val_463' '463','val_463' '463','val_463' '463','val_463' '466','val_466' '466','val_466' '466','val_466' '466','val_466' '466','val_466' '466','val_466' '466','val_466' '466','val_466' '466','val_466' '466','val_466' '466','val_466' '466','val_466' '467','val_467' '467','val_467' '467','val_467' '467','val_467' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '468','val_468' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '469','val_469' '47','val_47' '47','val_47' '47','val_47' '47','val_47' '470','val_470' '470','val_470' '470','val_470' '470','val_470' '472','val_472' '472','val_472' '472','val_472' '472','val_472' '475','val_475' '475','val_475' '475','val_475' '475','val_475' '477','val_477' '477','val_477' '477','val_477' '477','val_477' '478','val_478' '478','val_478' '478','val_478' '478','val_478' '478','val_478' '478','val_478' '478','val_478' '478','val_478' '479','val_479' '479','val_479' '479','val_479' '479','val_479' '480','val_480' '480','val_480' '480','val_480' '480','val_480' '480','val_480' '480','val_480' '480','val_480' '480','val_480' '480','val_480' '480','val_480' '480','val_480' '480','val_480' '481','val_481' '481','val_481' '481','val_481' '481','val_481' '482','val_482' '482','val_482' '482','val_482' '482','val_482' '483','val_483' '483','val_483' '483','val_483' '483','val_483' '484','val_484' '484','val_484' '484','val_484' '484','val_484' '485','val_485' '485','val_485' '485','val_485' '485','val_485' '487','val_487' '487','val_487' '487','val_487' '487','val_487' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '489','val_489' '490','val_490' '490','val_490' '490','val_490' '490','val_490' '491','val_491' '491','val_491' '491','val_491' '491','val_491' '492','val_492' '492','val_492' '492','val_492' '492','val_492' '492','val_492' '492','val_492' '492','val_492' '492','val_492' '493','val_493' '493','val_493' '493','val_493' '493','val_493' '494','val_494' '494','val_494' '494','val_494' '494','val_494' '495','val_495' '495','val_495' '495','val_495' '495','val_495' '496','val_496' '496','val_496' '496','val_496' '496','val_496' '497','val_497' '497','val_497' '497','val_497' '497','val_497' '498','val_498' '498','val_498' '498','val_498' '498','val_498' '498','val_498' '498','val_498' '498','val_498' '498','val_498' '498','val_498' '498','val_498' '498','val_498' '498','val_498' '5','val_5' '5','val_5' '5','val_5' '5','val_5' '5','val_5' '5','val_5' '5','val_5' '5','val_5' '5','val_5' '5','val_5' '5','val_5' '5','val_5' '51','val_51' '51','val_51' '51','val_51' '51','val_51' '51','val_51' '51','val_51' '51','val_51' '51','val_51' '53','val_53' '53','val_53' '53','val_53' '53','val_53' '54','val_54' '54','val_54' '54','val_54' '54','val_54' '57','val_57' '57','val_57' '57','val_57' '57','val_57' '58','val_58' '58','val_58' '58','val_58' '58','val_58' '58','val_58' '58','val_58' '58','val_58' '58','val_58' '64','val_64' '64','val_64' '64','val_64' '64','val_64' '65','val_65' '65','val_65' '65','val_65' '65','val_65' '66','val_66' '66','val_66' '66','val_66' '66','val_66' '67','val_67' '67','val_67' '67','val_67' '67','val_67' '67','val_67' '67','val_67' '67','val_67' '67','val_67' '69','val_69' '69','val_69' '69','val_69' '69','val_69' '70','val_70' '70','val_70' '70','val_70' '70','val_70' '70','val_70' '70','val_70' '70','val_70' '70','val_70' '70','val_70' '70','val_70' '70','val_70' '70','val_70' '72','val_72' '72','val_72' '72','val_72' '72','val_72' '72','val_72' '72','val_72' '72','val_72' '72','val_72' '74','val_74' '74','val_74' '74','val_74' '74','val_74' '76','val_76' '76','val_76' '76','val_76' '76','val_76' '76','val_76' '76','val_76' '76','val_76' '76','val_76' '77','val_77' '77','val_77' '77','val_77' '77','val_77' '78','val_78' '78','val_78' '78','val_78' '78','val_78' '8','val_8' '8','val_8' '8','val_8' '8','val_8' '80','val_80' '80','val_80' '80','val_80' '80','val_80' '82','val_82' '82','val_82' '82','val_82' '82','val_82' '83','val_83' '83','val_83' '83','val_83' '83','val_83' '83','val_83' '83','val_83' '83','val_83' '83','val_83' '84','val_84' '84','val_84' '84','val_84' '84','val_84' '84','val_84' '84','val_84' '84','val_84' '84','val_84' '85','val_85' '85','val_85' '85','val_85' '85','val_85' '86','val_86' '86','val_86' '86','val_86' '86','val_86' '87','val_87' '87','val_87' '87','val_87' '87','val_87' '9','val_9' '9','val_9' '9','val_9' '9','val_9' '90','val_90' '90','val_90' '90','val_90' '90','val_90' '90','val_90' '90','val_90' '90','val_90' '90','val_90' '90','val_90' '90','val_90' '90','val_90' '90','val_90' '92','val_92' '92','val_92' '92','val_92' '92','val_92' '95','val_95' '95','val_95' '95','val_95' '95','val_95' '95','val_95' '95','val_95' '95','val_95' '95','val_95' '96','val_96' '96','val_96' '96','val_96' '96','val_96' '97','val_97' '97','val_97' '97','val_97' '97','val_97' '97','val_97' '97','val_97' '97','val_97' '97','val_97' '98','val_98' '98','val_98' '98','val_98' '98','val_98' '98','val_98' '98','val_98' '98','val_98' '98','val_98' 2,000 rows selected >>> describe formatted merge_src2; 'col_name','data_type','comment' '# col_name ','data_type ','comment ' '','','' 'key ','string ','None ' 'value ','string ','None ' '','','' '# Detailed Table Information','','' 'Database: ','merge3 ','' 'Owner: ','!!{user.name}!! ','' 'CreateTime: ','!!TIMESTAMP!!','' 'LastAccessTime: ','UNKNOWN ','' 'Protect Mode: ','None ','' 'Retention: ','0 ','' 'Location: ','!!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src2','' 'Table Type: ','MANAGED_TABLE ','' 'Table Parameters:','','' '','numFiles ','1 ' '','numPartitions ','0 ' '','numRows ','2000 ' '','rawDataSize ','21248 ' '','totalSize ','23248 ' '','transient_lastDdlTime','!!UNIXTIME!! ' '','','' '# Storage Information','','' 'SerDe Library: ','org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe','' 'InputFormat: ','org.apache.hadoop.mapred.TextInputFormat','' 'OutputFormat: ','org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat','' 'Compressed: ','No ','' 'Num Buckets: ','-1 ','' 'Bucket Columns: ','[] ','' 'Sort Columns: ','[] ','' 'Storage Desc Params:','','' '','serialization.format','1 ' 32 rows selected >>> >>> create table merge_src_part2 like merge_src_part; No rows affected >>> >>> >>> explain extended insert overwrite table merge_src_part2 partition(ds) select key, value, ds from merge_src_part where ds is not null; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME merge_src_part))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME merge_src_part2) (TOK_PARTSPEC (TOK_PARTVAL ds)))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds))) (TOK_WHERE (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL ds)))))' '' 'STAGE DEPENDENCIES:' ' Stage-1 is a root stage' ' Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5' ' Stage-4' ' Stage-0 depends on stages: Stage-4, Stage-3, Stage-6' ' Stage-2 depends on stages: Stage-0' ' Stage-3' ' Stage-5' ' Stage-6 depends on stages: Stage-5' '' 'STAGE PLANS:' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' merge_src_part ' ' TableScan' ' alias: merge_src_part' ' GatherStats: false' ' Select Operator' ' expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' expr: ds' ' type: string' ' outputColumnNames: _col0, _col1, _col2' ' File Output Operator' ' compressed: false' ' GlobalTableId: 1' ' directory: pfile:!!{hive.exec.scratchdir}!!' ' NumFilesPerFileSink: 1' ' Stats Publishing Key Prefix: pfile:!!{hive.exec.scratchdir}!!' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' TotalFiles: 1' ' GatherStats: true' ' MultiFileSpray: false' ' Needs Tagging: false' ' Path -> Alias:' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-08 [merge_src_part]' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-09 [merge_src_part]' ' Path -> Partition:' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-08 ' ' Partition' ' base file name: ds=2008-04-08' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' partition values:' ' ds 2008-04-08' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-08' ' name merge3.merge_src_part' ' numFiles 2' ' numPartitions 2' ' numRows 1000' ' partition_columns ds' ' rawDataSize 10624' ' serialization.ddl struct merge_src_part { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 11624' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part' ' name merge3.merge_src_part' ' numFiles 4' ' numPartitions 2' ' numRows 2000' ' partition_columns ds' ' rawDataSize 21248' ' serialization.ddl struct merge_src_part { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 23248' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part' ' name: merge3.merge_src_part' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-09 ' ' Partition' ' base file name: ds=2008-04-09' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' partition values:' ' ds 2008-04-09' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-09' ' name merge3.merge_src_part' ' numFiles 2' ' numPartitions 2' ' numRows 1000' ' partition_columns ds' ' rawDataSize 10624' ' serialization.ddl struct merge_src_part { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 11624' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part' ' name merge3.merge_src_part' ' numFiles 4' ' numPartitions 2' ' numRows 2000' ' partition_columns ds' ' rawDataSize 21248' ' serialization.ddl struct merge_src_part { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 23248' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part' ' name: merge3.merge_src_part' '' ' Stage: Stage-7' ' Conditional Operator' '' ' Stage: Stage-4' ' Move Operator' ' files:' ' hdfs directory: true' ' source: pfile:!!{hive.exec.scratchdir}!!' ' destination: pfile:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-0' ' Move Operator' ' tables:' ' partition:' ' ds ' ' replace: true' ' source: pfile:!!{hive.exec.scratchdir}!!' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' tmp directory: pfile:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-2' ' Stats-Aggr Operator' ' Stats Aggregation Key Prefix: pfile:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-3' ' Map Reduce' ' Alias -> Map Operator Tree:' ' pfile:!!{hive.exec.scratchdir}!! ' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' directory: pfile:!!{hive.exec.scratchdir}!!' ' NumFilesPerFileSink: 1' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' TotalFiles: 1' ' GatherStats: false' ' MultiFileSpray: false' ' Needs Tagging: false' ' Path -> Alias:' ' pfile:!!{hive.exec.scratchdir}!! [pfile:!!{hive.exec.scratchdir}!!]' ' Path -> Partition:' ' pfile:!!{hive.exec.scratchdir}!! ' ' Partition' ' base file name: -ext-10002' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' name: merge3.merge_src_part2' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' pfile:!!{hive.exec.scratchdir}!! ' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' directory: pfile:!!{hive.exec.scratchdir}!!' ' NumFilesPerFileSink: 1' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' TotalFiles: 1' ' GatherStats: false' ' MultiFileSpray: false' ' Needs Tagging: false' ' Path -> Alias:' ' pfile:!!{hive.exec.scratchdir}!! [pfile:!!{hive.exec.scratchdir}!!]' ' Path -> Partition:' ' pfile:!!{hive.exec.scratchdir}!! ' ' Partition' ' base file name: -ext-10002' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' name: merge3.merge_src_part2' '' ' Stage: Stage-6' ' Move Operator' ' files:' ' hdfs directory: true' ' source: pfile:!!{hive.exec.scratchdir}!!' ' destination: pfile:!!{hive.exec.scratchdir}!!' '' '' 358 rows selected >>> >>> insert overwrite table merge_src_part2 partition(ds) select key, value, ds from merge_src_part where ds is not null; 'key','value','ds' No rows selected >>> >>> show partitions merge_src_part2; 'partition' 'ds=2008-04-08' 'ds=2008-04-09' 2 rows selected >>> >>> select * from merge_src_part2 where ds is not null ORDER BY key ASC, value ASC; 'key','value','ds' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '10','val_10','2008-04-09' '10','val_10','2008-04-09' '10','val_10','2008-04-08' '10','val_10','2008-04-08' '100','val_100','2008-04-08' '100','val_100','2008-04-08' '100','val_100','2008-04-08' '100','val_100','2008-04-08' '100','val_100','2008-04-09' '100','val_100','2008-04-09' '100','val_100','2008-04-09' '100','val_100','2008-04-09' '103','val_103','2008-04-09' '103','val_103','2008-04-09' '103','val_103','2008-04-09' '103','val_103','2008-04-09' '103','val_103','2008-04-08' '103','val_103','2008-04-08' '103','val_103','2008-04-08' '103','val_103','2008-04-08' '104','val_104','2008-04-08' '104','val_104','2008-04-08' '104','val_104','2008-04-08' '104','val_104','2008-04-08' '104','val_104','2008-04-09' '104','val_104','2008-04-09' '104','val_104','2008-04-09' '104','val_104','2008-04-09' '105','val_105','2008-04-09' '105','val_105','2008-04-09' '105','val_105','2008-04-08' '105','val_105','2008-04-08' '11','val_11','2008-04-08' '11','val_11','2008-04-08' '11','val_11','2008-04-09' '11','val_11','2008-04-09' '111','val_111','2008-04-09' '111','val_111','2008-04-09' '111','val_111','2008-04-08' '111','val_111','2008-04-08' '113','val_113','2008-04-08' '113','val_113','2008-04-08' '113','val_113','2008-04-08' '113','val_113','2008-04-08' '113','val_113','2008-04-09' '113','val_113','2008-04-09' '113','val_113','2008-04-09' '113','val_113','2008-04-09' '114','val_114','2008-04-09' '114','val_114','2008-04-09' '114','val_114','2008-04-08' '114','val_114','2008-04-08' '116','val_116','2008-04-08' '116','val_116','2008-04-08' '116','val_116','2008-04-09' '116','val_116','2008-04-09' '118','val_118','2008-04-09' '118','val_118','2008-04-09' '118','val_118','2008-04-09' '118','val_118','2008-04-09' '118','val_118','2008-04-08' '118','val_118','2008-04-08' '118','val_118','2008-04-08' '118','val_118','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '12','val_12','2008-04-09' '12','val_12','2008-04-09' '12','val_12','2008-04-09' '12','val_12','2008-04-09' '12','val_12','2008-04-08' '12','val_12','2008-04-08' '12','val_12','2008-04-08' '12','val_12','2008-04-08' '120','val_120','2008-04-08' '120','val_120','2008-04-08' '120','val_120','2008-04-08' '120','val_120','2008-04-08' '120','val_120','2008-04-09' '120','val_120','2008-04-09' '120','val_120','2008-04-09' '120','val_120','2008-04-09' '125','val_125','2008-04-09' '125','val_125','2008-04-09' '125','val_125','2008-04-09' '125','val_125','2008-04-09' '125','val_125','2008-04-08' '125','val_125','2008-04-08' '125','val_125','2008-04-08' '125','val_125','2008-04-08' '126','val_126','2008-04-08' '126','val_126','2008-04-08' '126','val_126','2008-04-09' '126','val_126','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '129','val_129','2008-04-08' '129','val_129','2008-04-08' '129','val_129','2008-04-08' '129','val_129','2008-04-08' '129','val_129','2008-04-09' '129','val_129','2008-04-09' '129','val_129','2008-04-09' '129','val_129','2008-04-09' '131','val_131','2008-04-09' '131','val_131','2008-04-09' '131','val_131','2008-04-08' '131','val_131','2008-04-08' '133','val_133','2008-04-08' '133','val_133','2008-04-08' '133','val_133','2008-04-09' '133','val_133','2008-04-09' '134','val_134','2008-04-09' '134','val_134','2008-04-09' '134','val_134','2008-04-09' '134','val_134','2008-04-09' '134','val_134','2008-04-08' '134','val_134','2008-04-08' '134','val_134','2008-04-08' '134','val_134','2008-04-08' '136','val_136','2008-04-08' '136','val_136','2008-04-08' '136','val_136','2008-04-09' '136','val_136','2008-04-09' '137','val_137','2008-04-09' '137','val_137','2008-04-09' '137','val_137','2008-04-09' '137','val_137','2008-04-09' '137','val_137','2008-04-08' '137','val_137','2008-04-08' '137','val_137','2008-04-08' '137','val_137','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '143','val_143','2008-04-09' '143','val_143','2008-04-09' '143','val_143','2008-04-08' '143','val_143','2008-04-08' '145','val_145','2008-04-08' '145','val_145','2008-04-08' '145','val_145','2008-04-09' '145','val_145','2008-04-09' '146','val_146','2008-04-09' '146','val_146','2008-04-09' '146','val_146','2008-04-09' '146','val_146','2008-04-09' '146','val_146','2008-04-08' '146','val_146','2008-04-08' '146','val_146','2008-04-08' '146','val_146','2008-04-08' '149','val_149','2008-04-08' '149','val_149','2008-04-08' '149','val_149','2008-04-08' '149','val_149','2008-04-08' '149','val_149','2008-04-09' '149','val_149','2008-04-09' '149','val_149','2008-04-09' '149','val_149','2008-04-09' '15','val_15','2008-04-09' '15','val_15','2008-04-09' '15','val_15','2008-04-09' '15','val_15','2008-04-09' '15','val_15','2008-04-08' '15','val_15','2008-04-08' '15','val_15','2008-04-08' '15','val_15','2008-04-08' '150','val_150','2008-04-08' '150','val_150','2008-04-08' '150','val_150','2008-04-09' '150','val_150','2008-04-09' '152','val_152','2008-04-09' '152','val_152','2008-04-09' '152','val_152','2008-04-09' '152','val_152','2008-04-09' '152','val_152','2008-04-08' '152','val_152','2008-04-08' '152','val_152','2008-04-08' '152','val_152','2008-04-08' '153','val_153','2008-04-08' '153','val_153','2008-04-08' '153','val_153','2008-04-09' '153','val_153','2008-04-09' '155','val_155','2008-04-09' '155','val_155','2008-04-09' '155','val_155','2008-04-08' '155','val_155','2008-04-08' '156','val_156','2008-04-08' '156','val_156','2008-04-08' '156','val_156','2008-04-09' '156','val_156','2008-04-09' '157','val_157','2008-04-09' '157','val_157','2008-04-09' '157','val_157','2008-04-08' '157','val_157','2008-04-08' '158','val_158','2008-04-08' '158','val_158','2008-04-08' '158','val_158','2008-04-09' '158','val_158','2008-04-09' '160','val_160','2008-04-09' '160','val_160','2008-04-09' '160','val_160','2008-04-08' '160','val_160','2008-04-08' '162','val_162','2008-04-08' '162','val_162','2008-04-08' '162','val_162','2008-04-09' '162','val_162','2008-04-09' '163','val_163','2008-04-09' '163','val_163','2008-04-09' '163','val_163','2008-04-08' '163','val_163','2008-04-08' '164','val_164','2008-04-08' '164','val_164','2008-04-08' '164','val_164','2008-04-08' '164','val_164','2008-04-08' '164','val_164','2008-04-09' '164','val_164','2008-04-09' '164','val_164','2008-04-09' '164','val_164','2008-04-09' '165','val_165','2008-04-09' '165','val_165','2008-04-09' '165','val_165','2008-04-09' '165','val_165','2008-04-09' '165','val_165','2008-04-08' '165','val_165','2008-04-08' '165','val_165','2008-04-08' '165','val_165','2008-04-08' '166','val_166','2008-04-08' '166','val_166','2008-04-08' '166','val_166','2008-04-09' '166','val_166','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '168','val_168','2008-04-08' '168','val_168','2008-04-08' '168','val_168','2008-04-09' '168','val_168','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '17','val_17','2008-04-08' '17','val_17','2008-04-08' '17','val_17','2008-04-09' '17','val_17','2008-04-09' '170','val_170','2008-04-09' '170','val_170','2008-04-09' '170','val_170','2008-04-08' '170','val_170','2008-04-08' '172','val_172','2008-04-08' '172','val_172','2008-04-08' '172','val_172','2008-04-08' '172','val_172','2008-04-08' '172','val_172','2008-04-09' '172','val_172','2008-04-09' '172','val_172','2008-04-09' '172','val_172','2008-04-09' '174','val_174','2008-04-09' '174','val_174','2008-04-09' '174','val_174','2008-04-09' '174','val_174','2008-04-09' '174','val_174','2008-04-08' '174','val_174','2008-04-08' '174','val_174','2008-04-08' '174','val_174','2008-04-08' '175','val_175','2008-04-08' '175','val_175','2008-04-08' '175','val_175','2008-04-08' '175','val_175','2008-04-08' '175','val_175','2008-04-09' '175','val_175','2008-04-09' '175','val_175','2008-04-09' '175','val_175','2008-04-09' '176','val_176','2008-04-09' '176','val_176','2008-04-09' '176','val_176','2008-04-09' '176','val_176','2008-04-09' '176','val_176','2008-04-08' '176','val_176','2008-04-08' '176','val_176','2008-04-08' '176','val_176','2008-04-08' '177','val_177','2008-04-08' '177','val_177','2008-04-08' '177','val_177','2008-04-09' '177','val_177','2008-04-09' '178','val_178','2008-04-09' '178','val_178','2008-04-09' '178','val_178','2008-04-08' '178','val_178','2008-04-08' '179','val_179','2008-04-08' '179','val_179','2008-04-08' '179','val_179','2008-04-08' '179','val_179','2008-04-08' '179','val_179','2008-04-09' '179','val_179','2008-04-09' '179','val_179','2008-04-09' '179','val_179','2008-04-09' '18','val_18','2008-04-09' '18','val_18','2008-04-09' '18','val_18','2008-04-09' '18','val_18','2008-04-09' '18','val_18','2008-04-08' '18','val_18','2008-04-08' '18','val_18','2008-04-08' '18','val_18','2008-04-08' '180','val_180','2008-04-08' '180','val_180','2008-04-08' '180','val_180','2008-04-09' '180','val_180','2008-04-09' '181','val_181','2008-04-09' '181','val_181','2008-04-09' '181','val_181','2008-04-08' '181','val_181','2008-04-08' '183','val_183','2008-04-08' '183','val_183','2008-04-08' '183','val_183','2008-04-09' '183','val_183','2008-04-09' '186','val_186','2008-04-09' '186','val_186','2008-04-09' '186','val_186','2008-04-08' '186','val_186','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '189','val_189','2008-04-09' '189','val_189','2008-04-09' '189','val_189','2008-04-08' '189','val_189','2008-04-08' '19','val_19','2008-04-08' '19','val_19','2008-04-08' '19','val_19','2008-04-09' '19','val_19','2008-04-09' '190','val_190','2008-04-09' '190','val_190','2008-04-09' '190','val_190','2008-04-08' '190','val_190','2008-04-08' '191','val_191','2008-04-08' '191','val_191','2008-04-08' '191','val_191','2008-04-08' '191','val_191','2008-04-08' '191','val_191','2008-04-09' '191','val_191','2008-04-09' '191','val_191','2008-04-09' '191','val_191','2008-04-09' '192','val_192','2008-04-09' '192','val_192','2008-04-09' '192','val_192','2008-04-08' '192','val_192','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '194','val_194','2008-04-09' '194','val_194','2008-04-09' '194','val_194','2008-04-08' '194','val_194','2008-04-08' '195','val_195','2008-04-08' '195','val_195','2008-04-08' '195','val_195','2008-04-08' '195','val_195','2008-04-08' '195','val_195','2008-04-09' '195','val_195','2008-04-09' '195','val_195','2008-04-09' '195','val_195','2008-04-09' '196','val_196','2008-04-09' '196','val_196','2008-04-09' '196','val_196','2008-04-08' '196','val_196','2008-04-08' '197','val_197','2008-04-08' '197','val_197','2008-04-08' '197','val_197','2008-04-08' '197','val_197','2008-04-08' '197','val_197','2008-04-09' '197','val_197','2008-04-09' '197','val_197','2008-04-09' '197','val_197','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '2','val_2','2008-04-08' '2','val_2','2008-04-08' '2','val_2','2008-04-09' '2','val_2','2008-04-09' '20','val_20','2008-04-09' '20','val_20','2008-04-09' '20','val_20','2008-04-08' '20','val_20','2008-04-08' '200','val_200','2008-04-08' '200','val_200','2008-04-08' '200','val_200','2008-04-08' '200','val_200','2008-04-08' '200','val_200','2008-04-09' '200','val_200','2008-04-09' '200','val_200','2008-04-09' '200','val_200','2008-04-09' '201','val_201','2008-04-09' '201','val_201','2008-04-09' '201','val_201','2008-04-08' '201','val_201','2008-04-08' '202','val_202','2008-04-08' '202','val_202','2008-04-08' '202','val_202','2008-04-09' '202','val_202','2008-04-09' '203','val_203','2008-04-09' '203','val_203','2008-04-09' '203','val_203','2008-04-09' '203','val_203','2008-04-09' '203','val_203','2008-04-08' '203','val_203','2008-04-08' '203','val_203','2008-04-08' '203','val_203','2008-04-08' '205','val_205','2008-04-08' '205','val_205','2008-04-08' '205','val_205','2008-04-08' '205','val_205','2008-04-08' '205','val_205','2008-04-09' '205','val_205','2008-04-09' '205','val_205','2008-04-09' '205','val_205','2008-04-09' '207','val_207','2008-04-09' '207','val_207','2008-04-09' '207','val_207','2008-04-09' '207','val_207','2008-04-09' '207','val_207','2008-04-08' '207','val_207','2008-04-08' '207','val_207','2008-04-08' '207','val_207','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '209','val_209','2008-04-09' '209','val_209','2008-04-09' '209','val_209','2008-04-09' '209','val_209','2008-04-09' '209','val_209','2008-04-08' '209','val_209','2008-04-08' '209','val_209','2008-04-08' '209','val_209','2008-04-08' '213','val_213','2008-04-08' '213','val_213','2008-04-08' '213','val_213','2008-04-08' '213','val_213','2008-04-08' '213','val_213','2008-04-09' '213','val_213','2008-04-09' '213','val_213','2008-04-09' '213','val_213','2008-04-09' '214','val_214','2008-04-09' '214','val_214','2008-04-09' '214','val_214','2008-04-08' '214','val_214','2008-04-08' '216','val_216','2008-04-08' '216','val_216','2008-04-08' '216','val_216','2008-04-08' '216','val_216','2008-04-08' '216','val_216','2008-04-09' '216','val_216','2008-04-09' '216','val_216','2008-04-09' '216','val_216','2008-04-09' '217','val_217','2008-04-09' '217','val_217','2008-04-09' '217','val_217','2008-04-09' '217','val_217','2008-04-09' '217','val_217','2008-04-08' '217','val_217','2008-04-08' '217','val_217','2008-04-08' '217','val_217','2008-04-08' '218','val_218','2008-04-08' '218','val_218','2008-04-08' '218','val_218','2008-04-09' '218','val_218','2008-04-09' '219','val_219','2008-04-09' '219','val_219','2008-04-09' '219','val_219','2008-04-09' '219','val_219','2008-04-09' '219','val_219','2008-04-08' '219','val_219','2008-04-08' '219','val_219','2008-04-08' '219','val_219','2008-04-08' '221','val_221','2008-04-08' '221','val_221','2008-04-08' '221','val_221','2008-04-08' '221','val_221','2008-04-08' '221','val_221','2008-04-09' '221','val_221','2008-04-09' '221','val_221','2008-04-09' '221','val_221','2008-04-09' '222','val_222','2008-04-09' '222','val_222','2008-04-09' '222','val_222','2008-04-08' '222','val_222','2008-04-08' '223','val_223','2008-04-08' '223','val_223','2008-04-08' '223','val_223','2008-04-08' '223','val_223','2008-04-08' '223','val_223','2008-04-09' '223','val_223','2008-04-09' '223','val_223','2008-04-09' '223','val_223','2008-04-09' '224','val_224','2008-04-09' '224','val_224','2008-04-09' '224','val_224','2008-04-09' '224','val_224','2008-04-09' '224','val_224','2008-04-08' '224','val_224','2008-04-08' '224','val_224','2008-04-08' '224','val_224','2008-04-08' '226','val_226','2008-04-08' '226','val_226','2008-04-08' '226','val_226','2008-04-09' '226','val_226','2008-04-09' '228','val_228','2008-04-09' '228','val_228','2008-04-09' '228','val_228','2008-04-08' '228','val_228','2008-04-08' '229','val_229','2008-04-08' '229','val_229','2008-04-08' '229','val_229','2008-04-08' '229','val_229','2008-04-08' '229','val_229','2008-04-09' '229','val_229','2008-04-09' '229','val_229','2008-04-09' '229','val_229','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '233','val_233','2008-04-08' '233','val_233','2008-04-08' '233','val_233','2008-04-08' '233','val_233','2008-04-08' '233','val_233','2008-04-09' '233','val_233','2008-04-09' '233','val_233','2008-04-09' '233','val_233','2008-04-09' '235','val_235','2008-04-09' '235','val_235','2008-04-09' '235','val_235','2008-04-08' '235','val_235','2008-04-08' '237','val_237','2008-04-08' '237','val_237','2008-04-08' '237','val_237','2008-04-08' '237','val_237','2008-04-08' '237','val_237','2008-04-09' '237','val_237','2008-04-09' '237','val_237','2008-04-09' '237','val_237','2008-04-09' '238','val_238','2008-04-09' '238','val_238','2008-04-09' '238','val_238','2008-04-09' '238','val_238','2008-04-09' '238','val_238','2008-04-08' '238','val_238','2008-04-08' '238','val_238','2008-04-08' '238','val_238','2008-04-08' '239','val_239','2008-04-08' '239','val_239','2008-04-08' '239','val_239','2008-04-08' '239','val_239','2008-04-08' '239','val_239','2008-04-09' '239','val_239','2008-04-09' '239','val_239','2008-04-09' '239','val_239','2008-04-09' '24','val_24','2008-04-09' '24','val_24','2008-04-09' '24','val_24','2008-04-09' '24','val_24','2008-04-09' '24','val_24','2008-04-08' '24','val_24','2008-04-08' '24','val_24','2008-04-08' '24','val_24','2008-04-08' '241','val_241','2008-04-08' '241','val_241','2008-04-08' '241','val_241','2008-04-09' '241','val_241','2008-04-09' '242','val_242','2008-04-09' '242','val_242','2008-04-09' '242','val_242','2008-04-09' '242','val_242','2008-04-09' '242','val_242','2008-04-08' '242','val_242','2008-04-08' '242','val_242','2008-04-08' '242','val_242','2008-04-08' '244','val_244','2008-04-08' '244','val_244','2008-04-08' '244','val_244','2008-04-09' '244','val_244','2008-04-09' '247','val_247','2008-04-09' '247','val_247','2008-04-09' '247','val_247','2008-04-08' '247','val_247','2008-04-08' '248','val_248','2008-04-08' '248','val_248','2008-04-08' '248','val_248','2008-04-09' '248','val_248','2008-04-09' '249','val_249','2008-04-09' '249','val_249','2008-04-09' '249','val_249','2008-04-08' '249','val_249','2008-04-08' '252','val_252','2008-04-08' '252','val_252','2008-04-08' '252','val_252','2008-04-09' '252','val_252','2008-04-09' '255','val_255','2008-04-09' '255','val_255','2008-04-09' '255','val_255','2008-04-09' '255','val_255','2008-04-09' '255','val_255','2008-04-08' '255','val_255','2008-04-08' '255','val_255','2008-04-08' '255','val_255','2008-04-08' '256','val_256','2008-04-08' '256','val_256','2008-04-08' '256','val_256','2008-04-08' '256','val_256','2008-04-08' '256','val_256','2008-04-09' '256','val_256','2008-04-09' '256','val_256','2008-04-09' '256','val_256','2008-04-09' '257','val_257','2008-04-09' '257','val_257','2008-04-09' '257','val_257','2008-04-08' '257','val_257','2008-04-08' '258','val_258','2008-04-08' '258','val_258','2008-04-08' '258','val_258','2008-04-09' '258','val_258','2008-04-09' '26','val_26','2008-04-09' '26','val_26','2008-04-09' '26','val_26','2008-04-09' '26','val_26','2008-04-09' '26','val_26','2008-04-08' '26','val_26','2008-04-08' '26','val_26','2008-04-08' '26','val_26','2008-04-08' '260','val_260','2008-04-08' '260','val_260','2008-04-08' '260','val_260','2008-04-09' '260','val_260','2008-04-09' '262','val_262','2008-04-09' '262','val_262','2008-04-09' '262','val_262','2008-04-08' '262','val_262','2008-04-08' '263','val_263','2008-04-08' '263','val_263','2008-04-08' '263','val_263','2008-04-09' '263','val_263','2008-04-09' '265','val_265','2008-04-09' '265','val_265','2008-04-09' '265','val_265','2008-04-09' '265','val_265','2008-04-09' '265','val_265','2008-04-08' '265','val_265','2008-04-08' '265','val_265','2008-04-08' '265','val_265','2008-04-08' '266','val_266','2008-04-08' '266','val_266','2008-04-08' '266','val_266','2008-04-09' '266','val_266','2008-04-09' '27','val_27','2008-04-09' '27','val_27','2008-04-09' '27','val_27','2008-04-08' '27','val_27','2008-04-08' '272','val_272','2008-04-08' '272','val_272','2008-04-08' '272','val_272','2008-04-08' '272','val_272','2008-04-08' '272','val_272','2008-04-09' '272','val_272','2008-04-09' '272','val_272','2008-04-09' '272','val_272','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '274','val_274','2008-04-08' '274','val_274','2008-04-08' '274','val_274','2008-04-09' '274','val_274','2008-04-09' '275','val_275','2008-04-09' '275','val_275','2008-04-09' '275','val_275','2008-04-08' '275','val_275','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '278','val_278','2008-04-09' '278','val_278','2008-04-09' '278','val_278','2008-04-09' '278','val_278','2008-04-09' '278','val_278','2008-04-08' '278','val_278','2008-04-08' '278','val_278','2008-04-08' '278','val_278','2008-04-08' '28','val_28','2008-04-08' '28','val_28','2008-04-08' '28','val_28','2008-04-09' '28','val_28','2008-04-09' '280','val_280','2008-04-09' '280','val_280','2008-04-09' '280','val_280','2008-04-09' '280','val_280','2008-04-09' '280','val_280','2008-04-08' '280','val_280','2008-04-08' '280','val_280','2008-04-08' '280','val_280','2008-04-08' '281','val_281','2008-04-08' '281','val_281','2008-04-08' '281','val_281','2008-04-08' '281','val_281','2008-04-08' '281','val_281','2008-04-09' '281','val_281','2008-04-09' '281','val_281','2008-04-09' '281','val_281','2008-04-09' '282','val_282','2008-04-09' '282','val_282','2008-04-09' '282','val_282','2008-04-09' '282','val_282','2008-04-09' '282','val_282','2008-04-08' '282','val_282','2008-04-08' '282','val_282','2008-04-08' '282','val_282','2008-04-08' '283','val_283','2008-04-08' '283','val_283','2008-04-08' '283','val_283','2008-04-09' '283','val_283','2008-04-09' '284','val_284','2008-04-09' '284','val_284','2008-04-09' '284','val_284','2008-04-08' '284','val_284','2008-04-08' '285','val_285','2008-04-08' '285','val_285','2008-04-08' '285','val_285','2008-04-09' '285','val_285','2008-04-09' '286','val_286','2008-04-09' '286','val_286','2008-04-09' '286','val_286','2008-04-08' '286','val_286','2008-04-08' '287','val_287','2008-04-08' '287','val_287','2008-04-08' '287','val_287','2008-04-09' '287','val_287','2008-04-09' '288','val_288','2008-04-09' '288','val_288','2008-04-09' '288','val_288','2008-04-09' '288','val_288','2008-04-09' '288','val_288','2008-04-08' '288','val_288','2008-04-08' '288','val_288','2008-04-08' '288','val_288','2008-04-08' '289','val_289','2008-04-08' '289','val_289','2008-04-08' '289','val_289','2008-04-09' '289','val_289','2008-04-09' '291','val_291','2008-04-09' '291','val_291','2008-04-09' '291','val_291','2008-04-08' '291','val_291','2008-04-08' '292','val_292','2008-04-08' '292','val_292','2008-04-08' '292','val_292','2008-04-09' '292','val_292','2008-04-09' '296','val_296','2008-04-09' '296','val_296','2008-04-09' '296','val_296','2008-04-08' '296','val_296','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '30','val_30','2008-04-09' '30','val_30','2008-04-09' '30','val_30','2008-04-08' '30','val_30','2008-04-08' '302','val_302','2008-04-08' '302','val_302','2008-04-08' '302','val_302','2008-04-09' '302','val_302','2008-04-09' '305','val_305','2008-04-09' '305','val_305','2008-04-09' '305','val_305','2008-04-08' '305','val_305','2008-04-08' '306','val_306','2008-04-08' '306','val_306','2008-04-08' '306','val_306','2008-04-09' '306','val_306','2008-04-09' '307','val_307','2008-04-09' '307','val_307','2008-04-09' '307','val_307','2008-04-09' '307','val_307','2008-04-09' '307','val_307','2008-04-08' '307','val_307','2008-04-08' '307','val_307','2008-04-08' '307','val_307','2008-04-08' '308','val_308','2008-04-08' '308','val_308','2008-04-08' '308','val_308','2008-04-09' '308','val_308','2008-04-09' '309','val_309','2008-04-09' '309','val_309','2008-04-09' '309','val_309','2008-04-09' '309','val_309','2008-04-09' '309','val_309','2008-04-08' '309','val_309','2008-04-08' '309','val_309','2008-04-08' '309','val_309','2008-04-08' '310','val_310','2008-04-08' '310','val_310','2008-04-08' '310','val_310','2008-04-09' '310','val_310','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '315','val_315','2008-04-08' '315','val_315','2008-04-08' '315','val_315','2008-04-09' '315','val_315','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '317','val_317','2008-04-08' '317','val_317','2008-04-08' '317','val_317','2008-04-08' '317','val_317','2008-04-08' '317','val_317','2008-04-09' '317','val_317','2008-04-09' '317','val_317','2008-04-09' '317','val_317','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '321','val_321','2008-04-08' '321','val_321','2008-04-08' '321','val_321','2008-04-08' '321','val_321','2008-04-08' '321','val_321','2008-04-09' '321','val_321','2008-04-09' '321','val_321','2008-04-09' '321','val_321','2008-04-09' '322','val_322','2008-04-09' '322','val_322','2008-04-09' '322','val_322','2008-04-09' '322','val_322','2008-04-09' '322','val_322','2008-04-08' '322','val_322','2008-04-08' '322','val_322','2008-04-08' '322','val_322','2008-04-08' '323','val_323','2008-04-08' '323','val_323','2008-04-08' '323','val_323','2008-04-09' '323','val_323','2008-04-09' '325','val_325','2008-04-09' '325','val_325','2008-04-09' '325','val_325','2008-04-09' '325','val_325','2008-04-09' '325','val_325','2008-04-08' '325','val_325','2008-04-08' '325','val_325','2008-04-08' '325','val_325','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '33','val_33','2008-04-09' '33','val_33','2008-04-09' '33','val_33','2008-04-08' '33','val_33','2008-04-08' '331','val_331','2008-04-08' '331','val_331','2008-04-08' '331','val_331','2008-04-08' '331','val_331','2008-04-08' '331','val_331','2008-04-09' '331','val_331','2008-04-09' '331','val_331','2008-04-09' '331','val_331','2008-04-09' '332','val_332','2008-04-09' '332','val_332','2008-04-09' '332','val_332','2008-04-08' '332','val_332','2008-04-08' '333','val_333','2008-04-08' '333','val_333','2008-04-08' '333','val_333','2008-04-08' '333','val_333','2008-04-08' '333','val_333','2008-04-09' '333','val_333','2008-04-09' '333','val_333','2008-04-09' '333','val_333','2008-04-09' '335','val_335','2008-04-09' '335','val_335','2008-04-09' '335','val_335','2008-04-08' '335','val_335','2008-04-08' '336','val_336','2008-04-08' '336','val_336','2008-04-08' '336','val_336','2008-04-09' '336','val_336','2008-04-09' '338','val_338','2008-04-09' '338','val_338','2008-04-09' '338','val_338','2008-04-08' '338','val_338','2008-04-08' '339','val_339','2008-04-08' '339','val_339','2008-04-08' '339','val_339','2008-04-09' '339','val_339','2008-04-09' '34','val_34','2008-04-09' '34','val_34','2008-04-09' '34','val_34','2008-04-08' '34','val_34','2008-04-08' '341','val_341','2008-04-08' '341','val_341','2008-04-08' '341','val_341','2008-04-09' '341','val_341','2008-04-09' '342','val_342','2008-04-09' '342','val_342','2008-04-09' '342','val_342','2008-04-09' '342','val_342','2008-04-09' '342','val_342','2008-04-08' '342','val_342','2008-04-08' '342','val_342','2008-04-08' '342','val_342','2008-04-08' '344','val_344','2008-04-08' '344','val_344','2008-04-08' '344','val_344','2008-04-08' '344','val_344','2008-04-08' '344','val_344','2008-04-09' '344','val_344','2008-04-09' '344','val_344','2008-04-09' '344','val_344','2008-04-09' '345','val_345','2008-04-09' '345','val_345','2008-04-09' '345','val_345','2008-04-08' '345','val_345','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '351','val_351','2008-04-08' '351','val_351','2008-04-08' '351','val_351','2008-04-09' '351','val_351','2008-04-09' '353','val_353','2008-04-09' '353','val_353','2008-04-09' '353','val_353','2008-04-09' '353','val_353','2008-04-09' '353','val_353','2008-04-08' '353','val_353','2008-04-08' '353','val_353','2008-04-08' '353','val_353','2008-04-08' '356','val_356','2008-04-08' '356','val_356','2008-04-08' '356','val_356','2008-04-09' '356','val_356','2008-04-09' '360','val_360','2008-04-09' '360','val_360','2008-04-09' '360','val_360','2008-04-08' '360','val_360','2008-04-08' '362','val_362','2008-04-08' '362','val_362','2008-04-08' '362','val_362','2008-04-09' '362','val_362','2008-04-09' '364','val_364','2008-04-09' '364','val_364','2008-04-09' '364','val_364','2008-04-08' '364','val_364','2008-04-08' '365','val_365','2008-04-08' '365','val_365','2008-04-08' '365','val_365','2008-04-09' '365','val_365','2008-04-09' '366','val_366','2008-04-09' '366','val_366','2008-04-09' '366','val_366','2008-04-08' '366','val_366','2008-04-08' '367','val_367','2008-04-08' '367','val_367','2008-04-08' '367','val_367','2008-04-08' '367','val_367','2008-04-08' '367','val_367','2008-04-09' '367','val_367','2008-04-09' '367','val_367','2008-04-09' '367','val_367','2008-04-09' '368','val_368','2008-04-09' '368','val_368','2008-04-09' '368','val_368','2008-04-08' '368','val_368','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '37','val_37','2008-04-09' '37','val_37','2008-04-09' '37','val_37','2008-04-09' '37','val_37','2008-04-09' '37','val_37','2008-04-08' '37','val_37','2008-04-08' '37','val_37','2008-04-08' '37','val_37','2008-04-08' '373','val_373','2008-04-08' '373','val_373','2008-04-08' '373','val_373','2008-04-09' '373','val_373','2008-04-09' '374','val_374','2008-04-09' '374','val_374','2008-04-09' '374','val_374','2008-04-08' '374','val_374','2008-04-08' '375','val_375','2008-04-08' '375','val_375','2008-04-08' '375','val_375','2008-04-09' '375','val_375','2008-04-09' '377','val_377','2008-04-09' '377','val_377','2008-04-09' '377','val_377','2008-04-08' '377','val_377','2008-04-08' '378','val_378','2008-04-08' '378','val_378','2008-04-08' '378','val_378','2008-04-09' '378','val_378','2008-04-09' '379','val_379','2008-04-09' '379','val_379','2008-04-09' '379','val_379','2008-04-08' '379','val_379','2008-04-08' '382','val_382','2008-04-08' '382','val_382','2008-04-08' '382','val_382','2008-04-08' '382','val_382','2008-04-08' '382','val_382','2008-04-09' '382','val_382','2008-04-09' '382','val_382','2008-04-09' '382','val_382','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '386','val_386','2008-04-08' '386','val_386','2008-04-08' '386','val_386','2008-04-09' '386','val_386','2008-04-09' '389','val_389','2008-04-09' '389','val_389','2008-04-09' '389','val_389','2008-04-08' '389','val_389','2008-04-08' '392','val_392','2008-04-08' '392','val_392','2008-04-08' '392','val_392','2008-04-09' '392','val_392','2008-04-09' '393','val_393','2008-04-09' '393','val_393','2008-04-09' '393','val_393','2008-04-08' '393','val_393','2008-04-08' '394','val_394','2008-04-08' '394','val_394','2008-04-08' '394','val_394','2008-04-09' '394','val_394','2008-04-09' '395','val_395','2008-04-09' '395','val_395','2008-04-09' '395','val_395','2008-04-09' '395','val_395','2008-04-09' '395','val_395','2008-04-08' '395','val_395','2008-04-08' '395','val_395','2008-04-08' '395','val_395','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '397','val_397','2008-04-09' '397','val_397','2008-04-09' '397','val_397','2008-04-09' '397','val_397','2008-04-09' '397','val_397','2008-04-08' '397','val_397','2008-04-08' '397','val_397','2008-04-08' '397','val_397','2008-04-08' '399','val_399','2008-04-08' '399','val_399','2008-04-08' '399','val_399','2008-04-08' '399','val_399','2008-04-08' '399','val_399','2008-04-09' '399','val_399','2008-04-09' '399','val_399','2008-04-09' '399','val_399','2008-04-09' '4','val_4','2008-04-09' '4','val_4','2008-04-09' '4','val_4','2008-04-08' '4','val_4','2008-04-08' '400','val_400','2008-04-08' '400','val_400','2008-04-08' '400','val_400','2008-04-09' '400','val_400','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '402','val_402','2008-04-08' '402','val_402','2008-04-08' '402','val_402','2008-04-09' '402','val_402','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '404','val_404','2008-04-08' '404','val_404','2008-04-08' '404','val_404','2008-04-08' '404','val_404','2008-04-08' '404','val_404','2008-04-09' '404','val_404','2008-04-09' '404','val_404','2008-04-09' '404','val_404','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '407','val_407','2008-04-08' '407','val_407','2008-04-08' '407','val_407','2008-04-09' '407','val_407','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '41','val_41','2008-04-08' '41','val_41','2008-04-08' '41','val_41','2008-04-09' '41','val_41','2008-04-09' '411','val_411','2008-04-09' '411','val_411','2008-04-09' '411','val_411','2008-04-08' '411','val_411','2008-04-08' '413','val_413','2008-04-08' '413','val_413','2008-04-08' '413','val_413','2008-04-08' '413','val_413','2008-04-08' '413','val_413','2008-04-09' '413','val_413','2008-04-09' '413','val_413','2008-04-09' '413','val_413','2008-04-09' '414','val_414','2008-04-09' '414','val_414','2008-04-09' '414','val_414','2008-04-09' '414','val_414','2008-04-09' '414','val_414','2008-04-08' '414','val_414','2008-04-08' '414','val_414','2008-04-08' '414','val_414','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '418','val_418','2008-04-09' '418','val_418','2008-04-09' '418','val_418','2008-04-08' '418','val_418','2008-04-08' '419','val_419','2008-04-08' '419','val_419','2008-04-08' '419','val_419','2008-04-09' '419','val_419','2008-04-09' '42','val_42','2008-04-09' '42','val_42','2008-04-09' '42','val_42','2008-04-09' '42','val_42','2008-04-09' '42','val_42','2008-04-08' '42','val_42','2008-04-08' '42','val_42','2008-04-08' '42','val_42','2008-04-08' '421','val_421','2008-04-08' '421','val_421','2008-04-08' '421','val_421','2008-04-09' '421','val_421','2008-04-09' '424','val_424','2008-04-09' '424','val_424','2008-04-09' '424','val_424','2008-04-09' '424','val_424','2008-04-09' '424','val_424','2008-04-08' '424','val_424','2008-04-08' '424','val_424','2008-04-08' '424','val_424','2008-04-08' '427','val_427','2008-04-08' '427','val_427','2008-04-08' '427','val_427','2008-04-09' '427','val_427','2008-04-09' '429','val_429','2008-04-09' '429','val_429','2008-04-09' '429','val_429','2008-04-09' '429','val_429','2008-04-09' '429','val_429','2008-04-08' '429','val_429','2008-04-08' '429','val_429','2008-04-08' '429','val_429','2008-04-08' '43','val_43','2008-04-08' '43','val_43','2008-04-08' '43','val_43','2008-04-09' '43','val_43','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '432','val_432','2008-04-09' '432','val_432','2008-04-09' '432','val_432','2008-04-08' '432','val_432','2008-04-08' '435','val_435','2008-04-08' '435','val_435','2008-04-08' '435','val_435','2008-04-09' '435','val_435','2008-04-09' '436','val_436','2008-04-09' '436','val_436','2008-04-09' '436','val_436','2008-04-08' '436','val_436','2008-04-08' '437','val_437','2008-04-08' '437','val_437','2008-04-08' '437','val_437','2008-04-09' '437','val_437','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '439','val_439','2008-04-08' '439','val_439','2008-04-08' '439','val_439','2008-04-08' '439','val_439','2008-04-08' '439','val_439','2008-04-09' '439','val_439','2008-04-09' '439','val_439','2008-04-09' '439','val_439','2008-04-09' '44','val_44','2008-04-09' '44','val_44','2008-04-09' '44','val_44','2008-04-08' '44','val_44','2008-04-08' '443','val_443','2008-04-08' '443','val_443','2008-04-08' '443','val_443','2008-04-09' '443','val_443','2008-04-09' '444','val_444','2008-04-09' '444','val_444','2008-04-09' '444','val_444','2008-04-08' '444','val_444','2008-04-08' '446','val_446','2008-04-08' '446','val_446','2008-04-08' '446','val_446','2008-04-09' '446','val_446','2008-04-09' '448','val_448','2008-04-09' '448','val_448','2008-04-09' '448','val_448','2008-04-08' '448','val_448','2008-04-08' '449','val_449','2008-04-08' '449','val_449','2008-04-08' '449','val_449','2008-04-09' '449','val_449','2008-04-09' '452','val_452','2008-04-09' '452','val_452','2008-04-09' '452','val_452','2008-04-08' '452','val_452','2008-04-08' '453','val_453','2008-04-08' '453','val_453','2008-04-08' '453','val_453','2008-04-09' '453','val_453','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '455','val_455','2008-04-08' '455','val_455','2008-04-08' '455','val_455','2008-04-09' '455','val_455','2008-04-09' '457','val_457','2008-04-09' '457','val_457','2008-04-09' '457','val_457','2008-04-08' '457','val_457','2008-04-08' '458','val_458','2008-04-08' '458','val_458','2008-04-08' '458','val_458','2008-04-08' '458','val_458','2008-04-08' '458','val_458','2008-04-09' '458','val_458','2008-04-09' '458','val_458','2008-04-09' '458','val_458','2008-04-09' '459','val_459','2008-04-09' '459','val_459','2008-04-09' '459','val_459','2008-04-09' '459','val_459','2008-04-09' '459','val_459','2008-04-08' '459','val_459','2008-04-08' '459','val_459','2008-04-08' '459','val_459','2008-04-08' '460','val_460','2008-04-08' '460','val_460','2008-04-08' '460','val_460','2008-04-09' '460','val_460','2008-04-09' '462','val_462','2008-04-09' '462','val_462','2008-04-09' '462','val_462','2008-04-09' '462','val_462','2008-04-09' '462','val_462','2008-04-08' '462','val_462','2008-04-08' '462','val_462','2008-04-08' '462','val_462','2008-04-08' '463','val_463','2008-04-08' '463','val_463','2008-04-08' '463','val_463','2008-04-08' '463','val_463','2008-04-08' '463','val_463','2008-04-09' '463','val_463','2008-04-09' '463','val_463','2008-04-09' '463','val_463','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '467','val_467','2008-04-08' '467','val_467','2008-04-08' '467','val_467','2008-04-09' '467','val_467','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '47','val_47','2008-04-09' '47','val_47','2008-04-09' '47','val_47','2008-04-08' '47','val_47','2008-04-08' '470','val_470','2008-04-08' '470','val_470','2008-04-08' '470','val_470','2008-04-09' '470','val_470','2008-04-09' '472','val_472','2008-04-09' '472','val_472','2008-04-09' '472','val_472','2008-04-08' '472','val_472','2008-04-08' '475','val_475','2008-04-08' '475','val_475','2008-04-08' '475','val_475','2008-04-09' '475','val_475','2008-04-09' '477','val_477','2008-04-09' '477','val_477','2008-04-09' '477','val_477','2008-04-08' '477','val_477','2008-04-08' '478','val_478','2008-04-08' '478','val_478','2008-04-08' '478','val_478','2008-04-08' '478','val_478','2008-04-08' '478','val_478','2008-04-09' '478','val_478','2008-04-09' '478','val_478','2008-04-09' '478','val_478','2008-04-09' '479','val_479','2008-04-09' '479','val_479','2008-04-09' '479','val_479','2008-04-08' '479','val_479','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '481','val_481','2008-04-09' '481','val_481','2008-04-09' '481','val_481','2008-04-08' '481','val_481','2008-04-08' '482','val_482','2008-04-08' '482','val_482','2008-04-08' '482','val_482','2008-04-09' '482','val_482','2008-04-09' '483','val_483','2008-04-09' '483','val_483','2008-04-09' '483','val_483','2008-04-08' '483','val_483','2008-04-08' '484','val_484','2008-04-08' '484','val_484','2008-04-08' '484','val_484','2008-04-09' '484','val_484','2008-04-09' '485','val_485','2008-04-09' '485','val_485','2008-04-09' '485','val_485','2008-04-08' '485','val_485','2008-04-08' '487','val_487','2008-04-08' '487','val_487','2008-04-08' '487','val_487','2008-04-09' '487','val_487','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '490','val_490','2008-04-08' '490','val_490','2008-04-08' '490','val_490','2008-04-09' '490','val_490','2008-04-09' '491','val_491','2008-04-09' '491','val_491','2008-04-09' '491','val_491','2008-04-08' '491','val_491','2008-04-08' '492','val_492','2008-04-08' '492','val_492','2008-04-08' '492','val_492','2008-04-08' '492','val_492','2008-04-08' '492','val_492','2008-04-09' '492','val_492','2008-04-09' '492','val_492','2008-04-09' '492','val_492','2008-04-09' '493','val_493','2008-04-09' '493','val_493','2008-04-09' '493','val_493','2008-04-08' '493','val_493','2008-04-08' '494','val_494','2008-04-08' '494','val_494','2008-04-08' '494','val_494','2008-04-09' '494','val_494','2008-04-09' '495','val_495','2008-04-09' '495','val_495','2008-04-09' '495','val_495','2008-04-08' '495','val_495','2008-04-08' '496','val_496','2008-04-08' '496','val_496','2008-04-08' '496','val_496','2008-04-09' '496','val_496','2008-04-09' '497','val_497','2008-04-09' '497','val_497','2008-04-09' '497','val_497','2008-04-08' '497','val_497','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '51','val_51','2008-04-08' '51','val_51','2008-04-08' '51','val_51','2008-04-08' '51','val_51','2008-04-08' '51','val_51','2008-04-09' '51','val_51','2008-04-09' '51','val_51','2008-04-09' '51','val_51','2008-04-09' '53','val_53','2008-04-09' '53','val_53','2008-04-09' '53','val_53','2008-04-08' '53','val_53','2008-04-08' '54','val_54','2008-04-08' '54','val_54','2008-04-08' '54','val_54','2008-04-09' '54','val_54','2008-04-09' '57','val_57','2008-04-09' '57','val_57','2008-04-09' '57','val_57','2008-04-08' '57','val_57','2008-04-08' '58','val_58','2008-04-08' '58','val_58','2008-04-08' '58','val_58','2008-04-08' '58','val_58','2008-04-08' '58','val_58','2008-04-09' '58','val_58','2008-04-09' '58','val_58','2008-04-09' '58','val_58','2008-04-09' '64','val_64','2008-04-09' '64','val_64','2008-04-09' '64','val_64','2008-04-08' '64','val_64','2008-04-08' '65','val_65','2008-04-08' '65','val_65','2008-04-08' '65','val_65','2008-04-09' '65','val_65','2008-04-09' '66','val_66','2008-04-09' '66','val_66','2008-04-09' '66','val_66','2008-04-08' '66','val_66','2008-04-08' '67','val_67','2008-04-08' '67','val_67','2008-04-08' '67','val_67','2008-04-08' '67','val_67','2008-04-08' '67','val_67','2008-04-09' '67','val_67','2008-04-09' '67','val_67','2008-04-09' '67','val_67','2008-04-09' '69','val_69','2008-04-09' '69','val_69','2008-04-09' '69','val_69','2008-04-08' '69','val_69','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '72','val_72','2008-04-09' '72','val_72','2008-04-09' '72','val_72','2008-04-09' '72','val_72','2008-04-09' '72','val_72','2008-04-08' '72','val_72','2008-04-08' '72','val_72','2008-04-08' '72','val_72','2008-04-08' '74','val_74','2008-04-08' '74','val_74','2008-04-08' '74','val_74','2008-04-09' '74','val_74','2008-04-09' '76','val_76','2008-04-09' '76','val_76','2008-04-09' '76','val_76','2008-04-09' '76','val_76','2008-04-09' '76','val_76','2008-04-08' '76','val_76','2008-04-08' '76','val_76','2008-04-08' '76','val_76','2008-04-08' '77','val_77','2008-04-08' '77','val_77','2008-04-08' '77','val_77','2008-04-09' '77','val_77','2008-04-09' '78','val_78','2008-04-09' '78','val_78','2008-04-09' '78','val_78','2008-04-08' '78','val_78','2008-04-08' '8','val_8','2008-04-08' '8','val_8','2008-04-08' '8','val_8','2008-04-09' '8','val_8','2008-04-09' '80','val_80','2008-04-09' '80','val_80','2008-04-09' '80','val_80','2008-04-08' '80','val_80','2008-04-08' '82','val_82','2008-04-08' '82','val_82','2008-04-08' '82','val_82','2008-04-09' '82','val_82','2008-04-09' '83','val_83','2008-04-09' '83','val_83','2008-04-09' '83','val_83','2008-04-09' '83','val_83','2008-04-09' '83','val_83','2008-04-08' '83','val_83','2008-04-08' '83','val_83','2008-04-08' '83','val_83','2008-04-08' '84','val_84','2008-04-08' '84','val_84','2008-04-08' '84','val_84','2008-04-08' '84','val_84','2008-04-08' '84','val_84','2008-04-09' '84','val_84','2008-04-09' '84','val_84','2008-04-09' '84','val_84','2008-04-09' '85','val_85','2008-04-09' '85','val_85','2008-04-09' '85','val_85','2008-04-08' '85','val_85','2008-04-08' '86','val_86','2008-04-08' '86','val_86','2008-04-08' '86','val_86','2008-04-09' '86','val_86','2008-04-09' '87','val_87','2008-04-09' '87','val_87','2008-04-09' '87','val_87','2008-04-08' '87','val_87','2008-04-08' '9','val_9','2008-04-08' '9','val_9','2008-04-08' '9','val_9','2008-04-09' '9','val_9','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '92','val_92','2008-04-08' '92','val_92','2008-04-08' '92','val_92','2008-04-09' '92','val_92','2008-04-09' '95','val_95','2008-04-09' '95','val_95','2008-04-09' '95','val_95','2008-04-09' '95','val_95','2008-04-09' '95','val_95','2008-04-08' '95','val_95','2008-04-08' '95','val_95','2008-04-08' '95','val_95','2008-04-08' '96','val_96','2008-04-08' '96','val_96','2008-04-08' '96','val_96','2008-04-09' '96','val_96','2008-04-09' '97','val_97','2008-04-09' '97','val_97','2008-04-09' '97','val_97','2008-04-09' '97','val_97','2008-04-09' '97','val_97','2008-04-08' '97','val_97','2008-04-08' '97','val_97','2008-04-08' '97','val_97','2008-04-08' '98','val_98','2008-04-08' '98','val_98','2008-04-08' '98','val_98','2008-04-08' '98','val_98','2008-04-08' '98','val_98','2008-04-09' '98','val_98','2008-04-09' '98','val_98','2008-04-09' '98','val_98','2008-04-09' 2,000 rows selected >>> >>> drop table merge_src_part2; No rows affected >>> >>> create table merge_src_part2 like merge_src_part; No rows affected >>> >>> explain extended from (select * from merge_src_part where ds is not null distribute by ds) s insert overwrite table merge_src_part2 partition(ds) select key, value, ds; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME merge_src_part))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL ds))) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL ds)))) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME merge_src_part2) (TOK_PARTSPEC (TOK_PARTVAL ds)))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds)))))' '' 'STAGE DEPENDENCIES:' ' Stage-1 is a root stage' ' Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5' ' Stage-4' ' Stage-0 depends on stages: Stage-4, Stage-3, Stage-6' ' Stage-2 depends on stages: Stage-0' ' Stage-3' ' Stage-5' ' Stage-6 depends on stages: Stage-5' '' 'STAGE PLANS:' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' s:merge_src_part ' ' TableScan' ' alias: merge_src_part' ' GatherStats: false' ' Select Operator' ' expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' expr: ds' ' type: string' ' outputColumnNames: _col0, _col1, _col2' ' Reduce Output Operator' ' sort order: ' ' Map-reduce partition columns:' ' expr: _col2' ' type: string' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' Needs Tagging: false' ' Path -> Alias:' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-08 [s:merge_src_part]' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-09 [s:merge_src_part]' ' Path -> Partition:' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-08 ' ' Partition' ' base file name: ds=2008-04-08' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' partition values:' ' ds 2008-04-08' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-08' ' name merge3.merge_src_part' ' numFiles 2' ' numPartitions 2' ' numRows 1000' ' partition_columns ds' ' rawDataSize 10624' ' serialization.ddl struct merge_src_part { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 11624' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part' ' name merge3.merge_src_part' ' numFiles 4' ' numPartitions 2' ' numRows 2000' ' partition_columns ds' ' rawDataSize 21248' ' serialization.ddl struct merge_src_part { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 23248' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part' ' name: merge3.merge_src_part' ' !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-09 ' ' Partition' ' base file name: ds=2008-04-09' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' partition values:' ' ds 2008-04-09' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part/ds=2008-04-09' ' name merge3.merge_src_part' ' numFiles 2' ' numPartitions 2' ' numRows 1000' ' partition_columns ds' ' rawDataSize 10624' ' serialization.ddl struct merge_src_part { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 11624' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part' ' name merge3.merge_src_part' ' numFiles 4' ' numPartitions 2' ' numRows 2000' ' partition_columns ds' ' rawDataSize 21248' ' serialization.ddl struct merge_src_part { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' totalSize 23248' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part' ' name: merge3.merge_src_part' ' Reduce Operator Tree:' ' Extract' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' outputColumnNames: _col0, _col1, _col2' ' File Output Operator' ' compressed: false' ' GlobalTableId: 1' ' directory: pfile:!!{hive.exec.scratchdir}!!' ' NumFilesPerFileSink: 1' ' Stats Publishing Key Prefix: pfile:!!{hive.exec.scratchdir}!!' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' TotalFiles: 1' ' GatherStats: true' ' MultiFileSpray: false' '' ' Stage: Stage-7' ' Conditional Operator' '' ' Stage: Stage-4' ' Move Operator' ' files:' ' hdfs directory: true' ' source: pfile:!!{hive.exec.scratchdir}!!' ' destination: pfile:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-0' ' Move Operator' ' tables:' ' partition:' ' ds ' ' replace: true' ' source: pfile:!!{hive.exec.scratchdir}!!' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' tmp directory: pfile:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-2' ' Stats-Aggr Operator' ' Stats Aggregation Key Prefix: pfile:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-3' ' Map Reduce' ' Alias -> Map Operator Tree:' ' pfile:!!{hive.exec.scratchdir}!! ' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' directory: pfile:!!{hive.exec.scratchdir}!!' ' NumFilesPerFileSink: 1' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' TotalFiles: 1' ' GatherStats: false' ' MultiFileSpray: false' ' Needs Tagging: false' ' Path -> Alias:' ' pfile:!!{hive.exec.scratchdir}!! [pfile:!!{hive.exec.scratchdir}!!]' ' Path -> Partition:' ' pfile:!!{hive.exec.scratchdir}!! ' ' Partition' ' base file name: -ext-10002' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' name: merge3.merge_src_part2' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' pfile:!!{hive.exec.scratchdir}!! ' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' directory: pfile:!!{hive.exec.scratchdir}!!' ' NumFilesPerFileSink: 1' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' TotalFiles: 1' ' GatherStats: false' ' MultiFileSpray: false' ' Needs Tagging: false' ' Path -> Alias:' ' pfile:!!{hive.exec.scratchdir}!! [pfile:!!{hive.exec.scratchdir}!!]' ' Path -> Partition:' ' pfile:!!{hive.exec.scratchdir}!! ' ' Partition' ' base file name: -ext-10002' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' ' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' properties:' ' bucket_count -1' ' columns key,value' ' columns.types string:string' ' file.inputformat org.apache.hadoop.mapred.TextInputFormat' ' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' location !!{hive.metastore.warehouse.dir}!!/merge3.db/merge_src_part2' ' name merge3.merge_src_part2' ' partition_columns ds' ' serialization.ddl struct merge_src_part2 { string key, string value}' ' serialization.format 1' ' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' transient_lastDdlTime !!UNIXTIME!!' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: merge3.merge_src_part2' ' name: merge3.merge_src_part2' '' ' Stage: Stage-6' ' Move Operator' ' files:' ' hdfs directory: true' ' source: pfile:!!{hive.exec.scratchdir}!!' ' destination: pfile:!!{hive.exec.scratchdir}!!' '' '' 382 rows selected >>> >>> from (select * from merge_src_part where ds is not null distribute by ds) s insert overwrite table merge_src_part2 partition(ds) select key, value, ds; 'key','value','ds' No rows selected >>> >>> show partitions merge_src_part2; 'partition' 'ds=2008-04-08' 'ds=2008-04-09' 2 rows selected >>> >>> select * from merge_src_part2 where ds is not null ORDER BY key ASC, value ASC; 'key','value','ds' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-08' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '0','val_0','2008-04-09' '10','val_10','2008-04-09' '10','val_10','2008-04-09' '10','val_10','2008-04-08' '10','val_10','2008-04-08' '100','val_100','2008-04-08' '100','val_100','2008-04-08' '100','val_100','2008-04-08' '100','val_100','2008-04-08' '100','val_100','2008-04-09' '100','val_100','2008-04-09' '100','val_100','2008-04-09' '100','val_100','2008-04-09' '103','val_103','2008-04-09' '103','val_103','2008-04-09' '103','val_103','2008-04-09' '103','val_103','2008-04-09' '103','val_103','2008-04-08' '103','val_103','2008-04-08' '103','val_103','2008-04-08' '103','val_103','2008-04-08' '104','val_104','2008-04-08' '104','val_104','2008-04-08' '104','val_104','2008-04-08' '104','val_104','2008-04-08' '104','val_104','2008-04-09' '104','val_104','2008-04-09' '104','val_104','2008-04-09' '104','val_104','2008-04-09' '105','val_105','2008-04-09' '105','val_105','2008-04-09' '105','val_105','2008-04-08' '105','val_105','2008-04-08' '11','val_11','2008-04-08' '11','val_11','2008-04-08' '11','val_11','2008-04-09' '11','val_11','2008-04-09' '111','val_111','2008-04-09' '111','val_111','2008-04-09' '111','val_111','2008-04-08' '111','val_111','2008-04-08' '113','val_113','2008-04-08' '113','val_113','2008-04-08' '113','val_113','2008-04-08' '113','val_113','2008-04-08' '113','val_113','2008-04-09' '113','val_113','2008-04-09' '113','val_113','2008-04-09' '113','val_113','2008-04-09' '114','val_114','2008-04-09' '114','val_114','2008-04-09' '114','val_114','2008-04-08' '114','val_114','2008-04-08' '116','val_116','2008-04-08' '116','val_116','2008-04-08' '116','val_116','2008-04-09' '116','val_116','2008-04-09' '118','val_118','2008-04-09' '118','val_118','2008-04-09' '118','val_118','2008-04-09' '118','val_118','2008-04-09' '118','val_118','2008-04-08' '118','val_118','2008-04-08' '118','val_118','2008-04-08' '118','val_118','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-08' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '119','val_119','2008-04-09' '12','val_12','2008-04-09' '12','val_12','2008-04-09' '12','val_12','2008-04-09' '12','val_12','2008-04-09' '12','val_12','2008-04-08' '12','val_12','2008-04-08' '12','val_12','2008-04-08' '12','val_12','2008-04-08' '120','val_120','2008-04-08' '120','val_120','2008-04-08' '120','val_120','2008-04-08' '120','val_120','2008-04-08' '120','val_120','2008-04-09' '120','val_120','2008-04-09' '120','val_120','2008-04-09' '120','val_120','2008-04-09' '125','val_125','2008-04-09' '125','val_125','2008-04-09' '125','val_125','2008-04-09' '125','val_125','2008-04-09' '125','val_125','2008-04-08' '125','val_125','2008-04-08' '125','val_125','2008-04-08' '125','val_125','2008-04-08' '126','val_126','2008-04-08' '126','val_126','2008-04-08' '126','val_126','2008-04-09' '126','val_126','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-09' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '128','val_128','2008-04-08' '129','val_129','2008-04-08' '129','val_129','2008-04-08' '129','val_129','2008-04-08' '129','val_129','2008-04-08' '129','val_129','2008-04-09' '129','val_129','2008-04-09' '129','val_129','2008-04-09' '129','val_129','2008-04-09' '131','val_131','2008-04-09' '131','val_131','2008-04-09' '131','val_131','2008-04-08' '131','val_131','2008-04-08' '133','val_133','2008-04-08' '133','val_133','2008-04-08' '133','val_133','2008-04-09' '133','val_133','2008-04-09' '134','val_134','2008-04-09' '134','val_134','2008-04-09' '134','val_134','2008-04-09' '134','val_134','2008-04-09' '134','val_134','2008-04-08' '134','val_134','2008-04-08' '134','val_134','2008-04-08' '134','val_134','2008-04-08' '136','val_136','2008-04-08' '136','val_136','2008-04-08' '136','val_136','2008-04-09' '136','val_136','2008-04-09' '137','val_137','2008-04-09' '137','val_137','2008-04-09' '137','val_137','2008-04-09' '137','val_137','2008-04-09' '137','val_137','2008-04-08' '137','val_137','2008-04-08' '137','val_137','2008-04-08' '137','val_137','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-08' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '138','val_138','2008-04-09' '143','val_143','2008-04-09' '143','val_143','2008-04-09' '143','val_143','2008-04-08' '143','val_143','2008-04-08' '145','val_145','2008-04-08' '145','val_145','2008-04-08' '145','val_145','2008-04-09' '145','val_145','2008-04-09' '146','val_146','2008-04-09' '146','val_146','2008-04-09' '146','val_146','2008-04-09' '146','val_146','2008-04-09' '146','val_146','2008-04-08' '146','val_146','2008-04-08' '146','val_146','2008-04-08' '146','val_146','2008-04-08' '149','val_149','2008-04-08' '149','val_149','2008-04-08' '149','val_149','2008-04-08' '149','val_149','2008-04-08' '149','val_149','2008-04-09' '149','val_149','2008-04-09' '149','val_149','2008-04-09' '149','val_149','2008-04-09' '15','val_15','2008-04-09' '15','val_15','2008-04-09' '15','val_15','2008-04-09' '15','val_15','2008-04-09' '15','val_15','2008-04-08' '15','val_15','2008-04-08' '15','val_15','2008-04-08' '15','val_15','2008-04-08' '150','val_150','2008-04-08' '150','val_150','2008-04-08' '150','val_150','2008-04-09' '150','val_150','2008-04-09' '152','val_152','2008-04-09' '152','val_152','2008-04-09' '152','val_152','2008-04-09' '152','val_152','2008-04-09' '152','val_152','2008-04-08' '152','val_152','2008-04-08' '152','val_152','2008-04-08' '152','val_152','2008-04-08' '153','val_153','2008-04-08' '153','val_153','2008-04-08' '153','val_153','2008-04-09' '153','val_153','2008-04-09' '155','val_155','2008-04-09' '155','val_155','2008-04-09' '155','val_155','2008-04-08' '155','val_155','2008-04-08' '156','val_156','2008-04-08' '156','val_156','2008-04-08' '156','val_156','2008-04-09' '156','val_156','2008-04-09' '157','val_157','2008-04-09' '157','val_157','2008-04-09' '157','val_157','2008-04-08' '157','val_157','2008-04-08' '158','val_158','2008-04-08' '158','val_158','2008-04-08' '158','val_158','2008-04-09' '158','val_158','2008-04-09' '160','val_160','2008-04-09' '160','val_160','2008-04-09' '160','val_160','2008-04-08' '160','val_160','2008-04-08' '162','val_162','2008-04-08' '162','val_162','2008-04-08' '162','val_162','2008-04-09' '162','val_162','2008-04-09' '163','val_163','2008-04-09' '163','val_163','2008-04-09' '163','val_163','2008-04-08' '163','val_163','2008-04-08' '164','val_164','2008-04-08' '164','val_164','2008-04-08' '164','val_164','2008-04-08' '164','val_164','2008-04-08' '164','val_164','2008-04-09' '164','val_164','2008-04-09' '164','val_164','2008-04-09' '164','val_164','2008-04-09' '165','val_165','2008-04-09' '165','val_165','2008-04-09' '165','val_165','2008-04-09' '165','val_165','2008-04-09' '165','val_165','2008-04-08' '165','val_165','2008-04-08' '165','val_165','2008-04-08' '165','val_165','2008-04-08' '166','val_166','2008-04-08' '166','val_166','2008-04-08' '166','val_166','2008-04-09' '166','val_166','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-09' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '167','val_167','2008-04-08' '168','val_168','2008-04-08' '168','val_168','2008-04-08' '168','val_168','2008-04-09' '168','val_168','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-09' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '169','val_169','2008-04-08' '17','val_17','2008-04-08' '17','val_17','2008-04-08' '17','val_17','2008-04-09' '17','val_17','2008-04-09' '170','val_170','2008-04-09' '170','val_170','2008-04-09' '170','val_170','2008-04-08' '170','val_170','2008-04-08' '172','val_172','2008-04-08' '172','val_172','2008-04-08' '172','val_172','2008-04-08' '172','val_172','2008-04-08' '172','val_172','2008-04-09' '172','val_172','2008-04-09' '172','val_172','2008-04-09' '172','val_172','2008-04-09' '174','val_174','2008-04-09' '174','val_174','2008-04-09' '174','val_174','2008-04-09' '174','val_174','2008-04-09' '174','val_174','2008-04-08' '174','val_174','2008-04-08' '174','val_174','2008-04-08' '174','val_174','2008-04-08' '175','val_175','2008-04-08' '175','val_175','2008-04-08' '175','val_175','2008-04-08' '175','val_175','2008-04-08' '175','val_175','2008-04-09' '175','val_175','2008-04-09' '175','val_175','2008-04-09' '175','val_175','2008-04-09' '176','val_176','2008-04-09' '176','val_176','2008-04-09' '176','val_176','2008-04-09' '176','val_176','2008-04-09' '176','val_176','2008-04-08' '176','val_176','2008-04-08' '176','val_176','2008-04-08' '176','val_176','2008-04-08' '177','val_177','2008-04-08' '177','val_177','2008-04-08' '177','val_177','2008-04-09' '177','val_177','2008-04-09' '178','val_178','2008-04-09' '178','val_178','2008-04-09' '178','val_178','2008-04-08' '178','val_178','2008-04-08' '179','val_179','2008-04-08' '179','val_179','2008-04-08' '179','val_179','2008-04-08' '179','val_179','2008-04-08' '179','val_179','2008-04-09' '179','val_179','2008-04-09' '179','val_179','2008-04-09' '179','val_179','2008-04-09' '18','val_18','2008-04-09' '18','val_18','2008-04-09' '18','val_18','2008-04-09' '18','val_18','2008-04-09' '18','val_18','2008-04-08' '18','val_18','2008-04-08' '18','val_18','2008-04-08' '18','val_18','2008-04-08' '180','val_180','2008-04-08' '180','val_180','2008-04-08' '180','val_180','2008-04-09' '180','val_180','2008-04-09' '181','val_181','2008-04-09' '181','val_181','2008-04-09' '181','val_181','2008-04-08' '181','val_181','2008-04-08' '183','val_183','2008-04-08' '183','val_183','2008-04-08' '183','val_183','2008-04-09' '183','val_183','2008-04-09' '186','val_186','2008-04-09' '186','val_186','2008-04-09' '186','val_186','2008-04-08' '186','val_186','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-08' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '187','val_187','2008-04-09' '189','val_189','2008-04-09' '189','val_189','2008-04-09' '189','val_189','2008-04-08' '189','val_189','2008-04-08' '19','val_19','2008-04-08' '19','val_19','2008-04-08' '19','val_19','2008-04-09' '19','val_19','2008-04-09' '190','val_190','2008-04-09' '190','val_190','2008-04-09' '190','val_190','2008-04-08' '190','val_190','2008-04-08' '191','val_191','2008-04-08' '191','val_191','2008-04-08' '191','val_191','2008-04-08' '191','val_191','2008-04-08' '191','val_191','2008-04-09' '191','val_191','2008-04-09' '191','val_191','2008-04-09' '191','val_191','2008-04-09' '192','val_192','2008-04-09' '192','val_192','2008-04-09' '192','val_192','2008-04-08' '192','val_192','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-08' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '193','val_193','2008-04-09' '194','val_194','2008-04-09' '194','val_194','2008-04-09' '194','val_194','2008-04-08' '194','val_194','2008-04-08' '195','val_195','2008-04-08' '195','val_195','2008-04-08' '195','val_195','2008-04-08' '195','val_195','2008-04-08' '195','val_195','2008-04-09' '195','val_195','2008-04-09' '195','val_195','2008-04-09' '195','val_195','2008-04-09' '196','val_196','2008-04-09' '196','val_196','2008-04-09' '196','val_196','2008-04-08' '196','val_196','2008-04-08' '197','val_197','2008-04-08' '197','val_197','2008-04-08' '197','val_197','2008-04-08' '197','val_197','2008-04-08' '197','val_197','2008-04-09' '197','val_197','2008-04-09' '197','val_197','2008-04-09' '197','val_197','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-09' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '199','val_199','2008-04-08' '2','val_2','2008-04-08' '2','val_2','2008-04-08' '2','val_2','2008-04-09' '2','val_2','2008-04-09' '20','val_20','2008-04-09' '20','val_20','2008-04-09' '20','val_20','2008-04-08' '20','val_20','2008-04-08' '200','val_200','2008-04-08' '200','val_200','2008-04-08' '200','val_200','2008-04-08' '200','val_200','2008-04-08' '200','val_200','2008-04-09' '200','val_200','2008-04-09' '200','val_200','2008-04-09' '200','val_200','2008-04-09' '201','val_201','2008-04-09' '201','val_201','2008-04-09' '201','val_201','2008-04-08' '201','val_201','2008-04-08' '202','val_202','2008-04-08' '202','val_202','2008-04-08' '202','val_202','2008-04-09' '202','val_202','2008-04-09' '203','val_203','2008-04-09' '203','val_203','2008-04-09' '203','val_203','2008-04-09' '203','val_203','2008-04-09' '203','val_203','2008-04-08' '203','val_203','2008-04-08' '203','val_203','2008-04-08' '203','val_203','2008-04-08' '205','val_205','2008-04-08' '205','val_205','2008-04-08' '205','val_205','2008-04-08' '205','val_205','2008-04-08' '205','val_205','2008-04-09' '205','val_205','2008-04-09' '205','val_205','2008-04-09' '205','val_205','2008-04-09' '207','val_207','2008-04-09' '207','val_207','2008-04-09' '207','val_207','2008-04-09' '207','val_207','2008-04-09' '207','val_207','2008-04-08' '207','val_207','2008-04-08' '207','val_207','2008-04-08' '207','val_207','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-08' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '208','val_208','2008-04-09' '209','val_209','2008-04-09' '209','val_209','2008-04-09' '209','val_209','2008-04-09' '209','val_209','2008-04-09' '209','val_209','2008-04-08' '209','val_209','2008-04-08' '209','val_209','2008-04-08' '209','val_209','2008-04-08' '213','val_213','2008-04-08' '213','val_213','2008-04-08' '213','val_213','2008-04-08' '213','val_213','2008-04-08' '213','val_213','2008-04-09' '213','val_213','2008-04-09' '213','val_213','2008-04-09' '213','val_213','2008-04-09' '214','val_214','2008-04-09' '214','val_214','2008-04-09' '214','val_214','2008-04-08' '214','val_214','2008-04-08' '216','val_216','2008-04-08' '216','val_216','2008-04-08' '216','val_216','2008-04-08' '216','val_216','2008-04-08' '216','val_216','2008-04-09' '216','val_216','2008-04-09' '216','val_216','2008-04-09' '216','val_216','2008-04-09' '217','val_217','2008-04-09' '217','val_217','2008-04-09' '217','val_217','2008-04-09' '217','val_217','2008-04-09' '217','val_217','2008-04-08' '217','val_217','2008-04-08' '217','val_217','2008-04-08' '217','val_217','2008-04-08' '218','val_218','2008-04-08' '218','val_218','2008-04-08' '218','val_218','2008-04-09' '218','val_218','2008-04-09' '219','val_219','2008-04-09' '219','val_219','2008-04-09' '219','val_219','2008-04-09' '219','val_219','2008-04-09' '219','val_219','2008-04-08' '219','val_219','2008-04-08' '219','val_219','2008-04-08' '219','val_219','2008-04-08' '221','val_221','2008-04-08' '221','val_221','2008-04-08' '221','val_221','2008-04-08' '221','val_221','2008-04-08' '221','val_221','2008-04-09' '221','val_221','2008-04-09' '221','val_221','2008-04-09' '221','val_221','2008-04-09' '222','val_222','2008-04-09' '222','val_222','2008-04-09' '222','val_222','2008-04-08' '222','val_222','2008-04-08' '223','val_223','2008-04-08' '223','val_223','2008-04-08' '223','val_223','2008-04-08' '223','val_223','2008-04-08' '223','val_223','2008-04-09' '223','val_223','2008-04-09' '223','val_223','2008-04-09' '223','val_223','2008-04-09' '224','val_224','2008-04-09' '224','val_224','2008-04-09' '224','val_224','2008-04-09' '224','val_224','2008-04-09' '224','val_224','2008-04-08' '224','val_224','2008-04-08' '224','val_224','2008-04-08' '224','val_224','2008-04-08' '226','val_226','2008-04-08' '226','val_226','2008-04-08' '226','val_226','2008-04-09' '226','val_226','2008-04-09' '228','val_228','2008-04-09' '228','val_228','2008-04-09' '228','val_228','2008-04-08' '228','val_228','2008-04-08' '229','val_229','2008-04-08' '229','val_229','2008-04-08' '229','val_229','2008-04-08' '229','val_229','2008-04-08' '229','val_229','2008-04-09' '229','val_229','2008-04-09' '229','val_229','2008-04-09' '229','val_229','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-09' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '230','val_230','2008-04-08' '233','val_233','2008-04-08' '233','val_233','2008-04-08' '233','val_233','2008-04-08' '233','val_233','2008-04-08' '233','val_233','2008-04-09' '233','val_233','2008-04-09' '233','val_233','2008-04-09' '233','val_233','2008-04-09' '235','val_235','2008-04-09' '235','val_235','2008-04-09' '235','val_235','2008-04-08' '235','val_235','2008-04-08' '237','val_237','2008-04-08' '237','val_237','2008-04-08' '237','val_237','2008-04-08' '237','val_237','2008-04-08' '237','val_237','2008-04-09' '237','val_237','2008-04-09' '237','val_237','2008-04-09' '237','val_237','2008-04-09' '238','val_238','2008-04-09' '238','val_238','2008-04-09' '238','val_238','2008-04-09' '238','val_238','2008-04-09' '238','val_238','2008-04-08' '238','val_238','2008-04-08' '238','val_238','2008-04-08' '238','val_238','2008-04-08' '239','val_239','2008-04-08' '239','val_239','2008-04-08' '239','val_239','2008-04-08' '239','val_239','2008-04-08' '239','val_239','2008-04-09' '239','val_239','2008-04-09' '239','val_239','2008-04-09' '239','val_239','2008-04-09' '24','val_24','2008-04-09' '24','val_24','2008-04-09' '24','val_24','2008-04-09' '24','val_24','2008-04-09' '24','val_24','2008-04-08' '24','val_24','2008-04-08' '24','val_24','2008-04-08' '24','val_24','2008-04-08' '241','val_241','2008-04-08' '241','val_241','2008-04-08' '241','val_241','2008-04-09' '241','val_241','2008-04-09' '242','val_242','2008-04-09' '242','val_242','2008-04-09' '242','val_242','2008-04-09' '242','val_242','2008-04-09' '242','val_242','2008-04-08' '242','val_242','2008-04-08' '242','val_242','2008-04-08' '242','val_242','2008-04-08' '244','val_244','2008-04-08' '244','val_244','2008-04-08' '244','val_244','2008-04-09' '244','val_244','2008-04-09' '247','val_247','2008-04-09' '247','val_247','2008-04-09' '247','val_247','2008-04-08' '247','val_247','2008-04-08' '248','val_248','2008-04-08' '248','val_248','2008-04-08' '248','val_248','2008-04-09' '248','val_248','2008-04-09' '249','val_249','2008-04-09' '249','val_249','2008-04-09' '249','val_249','2008-04-08' '249','val_249','2008-04-08' '252','val_252','2008-04-08' '252','val_252','2008-04-08' '252','val_252','2008-04-09' '252','val_252','2008-04-09' '255','val_255','2008-04-09' '255','val_255','2008-04-09' '255','val_255','2008-04-09' '255','val_255','2008-04-09' '255','val_255','2008-04-08' '255','val_255','2008-04-08' '255','val_255','2008-04-08' '255','val_255','2008-04-08' '256','val_256','2008-04-08' '256','val_256','2008-04-08' '256','val_256','2008-04-08' '256','val_256','2008-04-08' '256','val_256','2008-04-09' '256','val_256','2008-04-09' '256','val_256','2008-04-09' '256','val_256','2008-04-09' '257','val_257','2008-04-09' '257','val_257','2008-04-09' '257','val_257','2008-04-08' '257','val_257','2008-04-08' '258','val_258','2008-04-08' '258','val_258','2008-04-08' '258','val_258','2008-04-09' '258','val_258','2008-04-09' '26','val_26','2008-04-09' '26','val_26','2008-04-09' '26','val_26','2008-04-09' '26','val_26','2008-04-09' '26','val_26','2008-04-08' '26','val_26','2008-04-08' '26','val_26','2008-04-08' '26','val_26','2008-04-08' '260','val_260','2008-04-08' '260','val_260','2008-04-08' '260','val_260','2008-04-09' '260','val_260','2008-04-09' '262','val_262','2008-04-09' '262','val_262','2008-04-09' '262','val_262','2008-04-08' '262','val_262','2008-04-08' '263','val_263','2008-04-08' '263','val_263','2008-04-08' '263','val_263','2008-04-09' '263','val_263','2008-04-09' '265','val_265','2008-04-09' '265','val_265','2008-04-09' '265','val_265','2008-04-09' '265','val_265','2008-04-09' '265','val_265','2008-04-08' '265','val_265','2008-04-08' '265','val_265','2008-04-08' '265','val_265','2008-04-08' '266','val_266','2008-04-08' '266','val_266','2008-04-08' '266','val_266','2008-04-09' '266','val_266','2008-04-09' '27','val_27','2008-04-09' '27','val_27','2008-04-09' '27','val_27','2008-04-08' '27','val_27','2008-04-08' '272','val_272','2008-04-08' '272','val_272','2008-04-08' '272','val_272','2008-04-08' '272','val_272','2008-04-08' '272','val_272','2008-04-09' '272','val_272','2008-04-09' '272','val_272','2008-04-09' '272','val_272','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-09' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '273','val_273','2008-04-08' '274','val_274','2008-04-08' '274','val_274','2008-04-08' '274','val_274','2008-04-09' '274','val_274','2008-04-09' '275','val_275','2008-04-09' '275','val_275','2008-04-09' '275','val_275','2008-04-08' '275','val_275','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-08' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '277','val_277','2008-04-09' '278','val_278','2008-04-09' '278','val_278','2008-04-09' '278','val_278','2008-04-09' '278','val_278','2008-04-09' '278','val_278','2008-04-08' '278','val_278','2008-04-08' '278','val_278','2008-04-08' '278','val_278','2008-04-08' '28','val_28','2008-04-08' '28','val_28','2008-04-08' '28','val_28','2008-04-09' '28','val_28','2008-04-09' '280','val_280','2008-04-09' '280','val_280','2008-04-09' '280','val_280','2008-04-09' '280','val_280','2008-04-09' '280','val_280','2008-04-08' '280','val_280','2008-04-08' '280','val_280','2008-04-08' '280','val_280','2008-04-08' '281','val_281','2008-04-08' '281','val_281','2008-04-08' '281','val_281','2008-04-08' '281','val_281','2008-04-08' '281','val_281','2008-04-09' '281','val_281','2008-04-09' '281','val_281','2008-04-09' '281','val_281','2008-04-09' '282','val_282','2008-04-09' '282','val_282','2008-04-09' '282','val_282','2008-04-09' '282','val_282','2008-04-09' '282','val_282','2008-04-08' '282','val_282','2008-04-08' '282','val_282','2008-04-08' '282','val_282','2008-04-08' '283','val_283','2008-04-08' '283','val_283','2008-04-08' '283','val_283','2008-04-09' '283','val_283','2008-04-09' '284','val_284','2008-04-09' '284','val_284','2008-04-09' '284','val_284','2008-04-08' '284','val_284','2008-04-08' '285','val_285','2008-04-08' '285','val_285','2008-04-08' '285','val_285','2008-04-09' '285','val_285','2008-04-09' '286','val_286','2008-04-09' '286','val_286','2008-04-09' '286','val_286','2008-04-08' '286','val_286','2008-04-08' '287','val_287','2008-04-08' '287','val_287','2008-04-08' '287','val_287','2008-04-09' '287','val_287','2008-04-09' '288','val_288','2008-04-09' '288','val_288','2008-04-09' '288','val_288','2008-04-09' '288','val_288','2008-04-09' '288','val_288','2008-04-08' '288','val_288','2008-04-08' '288','val_288','2008-04-08' '288','val_288','2008-04-08' '289','val_289','2008-04-08' '289','val_289','2008-04-08' '289','val_289','2008-04-09' '289','val_289','2008-04-09' '291','val_291','2008-04-09' '291','val_291','2008-04-09' '291','val_291','2008-04-08' '291','val_291','2008-04-08' '292','val_292','2008-04-08' '292','val_292','2008-04-08' '292','val_292','2008-04-09' '292','val_292','2008-04-09' '296','val_296','2008-04-09' '296','val_296','2008-04-09' '296','val_296','2008-04-08' '296','val_296','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-08' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '298','val_298','2008-04-09' '30','val_30','2008-04-09' '30','val_30','2008-04-09' '30','val_30','2008-04-08' '30','val_30','2008-04-08' '302','val_302','2008-04-08' '302','val_302','2008-04-08' '302','val_302','2008-04-09' '302','val_302','2008-04-09' '305','val_305','2008-04-09' '305','val_305','2008-04-09' '305','val_305','2008-04-08' '305','val_305','2008-04-08' '306','val_306','2008-04-08' '306','val_306','2008-04-08' '306','val_306','2008-04-09' '306','val_306','2008-04-09' '307','val_307','2008-04-09' '307','val_307','2008-04-09' '307','val_307','2008-04-09' '307','val_307','2008-04-09' '307','val_307','2008-04-08' '307','val_307','2008-04-08' '307','val_307','2008-04-08' '307','val_307','2008-04-08' '308','val_308','2008-04-08' '308','val_308','2008-04-08' '308','val_308','2008-04-09' '308','val_308','2008-04-09' '309','val_309','2008-04-09' '309','val_309','2008-04-09' '309','val_309','2008-04-09' '309','val_309','2008-04-09' '309','val_309','2008-04-08' '309','val_309','2008-04-08' '309','val_309','2008-04-08' '309','val_309','2008-04-08' '310','val_310','2008-04-08' '310','val_310','2008-04-08' '310','val_310','2008-04-09' '310','val_310','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-09' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '311','val_311','2008-04-08' '315','val_315','2008-04-08' '315','val_315','2008-04-08' '315','val_315','2008-04-09' '315','val_315','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-09' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '316','val_316','2008-04-08' '317','val_317','2008-04-08' '317','val_317','2008-04-08' '317','val_317','2008-04-08' '317','val_317','2008-04-08' '317','val_317','2008-04-09' '317','val_317','2008-04-09' '317','val_317','2008-04-09' '317','val_317','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-09' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '318','val_318','2008-04-08' '321','val_321','2008-04-08' '321','val_321','2008-04-08' '321','val_321','2008-04-08' '321','val_321','2008-04-08' '321','val_321','2008-04-09' '321','val_321','2008-04-09' '321','val_321','2008-04-09' '321','val_321','2008-04-09' '322','val_322','2008-04-09' '322','val_322','2008-04-09' '322','val_322','2008-04-09' '322','val_322','2008-04-09' '322','val_322','2008-04-08' '322','val_322','2008-04-08' '322','val_322','2008-04-08' '322','val_322','2008-04-08' '323','val_323','2008-04-08' '323','val_323','2008-04-08' '323','val_323','2008-04-09' '323','val_323','2008-04-09' '325','val_325','2008-04-09' '325','val_325','2008-04-09' '325','val_325','2008-04-09' '325','val_325','2008-04-09' '325','val_325','2008-04-08' '325','val_325','2008-04-08' '325','val_325','2008-04-08' '325','val_325','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-08' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '327','val_327','2008-04-09' '33','val_33','2008-04-09' '33','val_33','2008-04-09' '33','val_33','2008-04-08' '33','val_33','2008-04-08' '331','val_331','2008-04-08' '331','val_331','2008-04-08' '331','val_331','2008-04-08' '331','val_331','2008-04-08' '331','val_331','2008-04-09' '331','val_331','2008-04-09' '331','val_331','2008-04-09' '331','val_331','2008-04-09' '332','val_332','2008-04-09' '332','val_332','2008-04-09' '332','val_332','2008-04-08' '332','val_332','2008-04-08' '333','val_333','2008-04-08' '333','val_333','2008-04-08' '333','val_333','2008-04-08' '333','val_333','2008-04-08' '333','val_333','2008-04-09' '333','val_333','2008-04-09' '333','val_333','2008-04-09' '333','val_333','2008-04-09' '335','val_335','2008-04-09' '335','val_335','2008-04-09' '335','val_335','2008-04-08' '335','val_335','2008-04-08' '336','val_336','2008-04-08' '336','val_336','2008-04-08' '336','val_336','2008-04-09' '336','val_336','2008-04-09' '338','val_338','2008-04-09' '338','val_338','2008-04-09' '338','val_338','2008-04-08' '338','val_338','2008-04-08' '339','val_339','2008-04-08' '339','val_339','2008-04-08' '339','val_339','2008-04-09' '339','val_339','2008-04-09' '34','val_34','2008-04-09' '34','val_34','2008-04-09' '34','val_34','2008-04-08' '34','val_34','2008-04-08' '341','val_341','2008-04-08' '341','val_341','2008-04-08' '341','val_341','2008-04-09' '341','val_341','2008-04-09' '342','val_342','2008-04-09' '342','val_342','2008-04-09' '342','val_342','2008-04-09' '342','val_342','2008-04-09' '342','val_342','2008-04-08' '342','val_342','2008-04-08' '342','val_342','2008-04-08' '342','val_342','2008-04-08' '344','val_344','2008-04-08' '344','val_344','2008-04-08' '344','val_344','2008-04-08' '344','val_344','2008-04-08' '344','val_344','2008-04-09' '344','val_344','2008-04-09' '344','val_344','2008-04-09' '344','val_344','2008-04-09' '345','val_345','2008-04-09' '345','val_345','2008-04-09' '345','val_345','2008-04-08' '345','val_345','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-08' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '348','val_348','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-09' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '35','val_35','2008-04-08' '351','val_351','2008-04-08' '351','val_351','2008-04-08' '351','val_351','2008-04-09' '351','val_351','2008-04-09' '353','val_353','2008-04-09' '353','val_353','2008-04-09' '353','val_353','2008-04-09' '353','val_353','2008-04-09' '353','val_353','2008-04-08' '353','val_353','2008-04-08' '353','val_353','2008-04-08' '353','val_353','2008-04-08' '356','val_356','2008-04-08' '356','val_356','2008-04-08' '356','val_356','2008-04-09' '356','val_356','2008-04-09' '360','val_360','2008-04-09' '360','val_360','2008-04-09' '360','val_360','2008-04-08' '360','val_360','2008-04-08' '362','val_362','2008-04-08' '362','val_362','2008-04-08' '362','val_362','2008-04-09' '362','val_362','2008-04-09' '364','val_364','2008-04-09' '364','val_364','2008-04-09' '364','val_364','2008-04-08' '364','val_364','2008-04-08' '365','val_365','2008-04-08' '365','val_365','2008-04-08' '365','val_365','2008-04-09' '365','val_365','2008-04-09' '366','val_366','2008-04-09' '366','val_366','2008-04-09' '366','val_366','2008-04-08' '366','val_366','2008-04-08' '367','val_367','2008-04-08' '367','val_367','2008-04-08' '367','val_367','2008-04-08' '367','val_367','2008-04-08' '367','val_367','2008-04-09' '367','val_367','2008-04-09' '367','val_367','2008-04-09' '367','val_367','2008-04-09' '368','val_368','2008-04-09' '368','val_368','2008-04-09' '368','val_368','2008-04-08' '368','val_368','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-08' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '369','val_369','2008-04-09' '37','val_37','2008-04-09' '37','val_37','2008-04-09' '37','val_37','2008-04-09' '37','val_37','2008-04-09' '37','val_37','2008-04-08' '37','val_37','2008-04-08' '37','val_37','2008-04-08' '37','val_37','2008-04-08' '373','val_373','2008-04-08' '373','val_373','2008-04-08' '373','val_373','2008-04-09' '373','val_373','2008-04-09' '374','val_374','2008-04-09' '374','val_374','2008-04-09' '374','val_374','2008-04-08' '374','val_374','2008-04-08' '375','val_375','2008-04-08' '375','val_375','2008-04-08' '375','val_375','2008-04-09' '375','val_375','2008-04-09' '377','val_377','2008-04-09' '377','val_377','2008-04-09' '377','val_377','2008-04-08' '377','val_377','2008-04-08' '378','val_378','2008-04-08' '378','val_378','2008-04-08' '378','val_378','2008-04-09' '378','val_378','2008-04-09' '379','val_379','2008-04-09' '379','val_379','2008-04-09' '379','val_379','2008-04-08' '379','val_379','2008-04-08' '382','val_382','2008-04-08' '382','val_382','2008-04-08' '382','val_382','2008-04-08' '382','val_382','2008-04-08' '382','val_382','2008-04-09' '382','val_382','2008-04-09' '382','val_382','2008-04-09' '382','val_382','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-09' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '384','val_384','2008-04-08' '386','val_386','2008-04-08' '386','val_386','2008-04-08' '386','val_386','2008-04-09' '386','val_386','2008-04-09' '389','val_389','2008-04-09' '389','val_389','2008-04-09' '389','val_389','2008-04-08' '389','val_389','2008-04-08' '392','val_392','2008-04-08' '392','val_392','2008-04-08' '392','val_392','2008-04-09' '392','val_392','2008-04-09' '393','val_393','2008-04-09' '393','val_393','2008-04-09' '393','val_393','2008-04-08' '393','val_393','2008-04-08' '394','val_394','2008-04-08' '394','val_394','2008-04-08' '394','val_394','2008-04-09' '394','val_394','2008-04-09' '395','val_395','2008-04-09' '395','val_395','2008-04-09' '395','val_395','2008-04-09' '395','val_395','2008-04-09' '395','val_395','2008-04-08' '395','val_395','2008-04-08' '395','val_395','2008-04-08' '395','val_395','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-08' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '396','val_396','2008-04-09' '397','val_397','2008-04-09' '397','val_397','2008-04-09' '397','val_397','2008-04-09' '397','val_397','2008-04-09' '397','val_397','2008-04-08' '397','val_397','2008-04-08' '397','val_397','2008-04-08' '397','val_397','2008-04-08' '399','val_399','2008-04-08' '399','val_399','2008-04-08' '399','val_399','2008-04-08' '399','val_399','2008-04-08' '399','val_399','2008-04-09' '399','val_399','2008-04-09' '399','val_399','2008-04-09' '399','val_399','2008-04-09' '4','val_4','2008-04-09' '4','val_4','2008-04-09' '4','val_4','2008-04-08' '4','val_4','2008-04-08' '400','val_400','2008-04-08' '400','val_400','2008-04-08' '400','val_400','2008-04-09' '400','val_400','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-09' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '401','val_401','2008-04-08' '402','val_402','2008-04-08' '402','val_402','2008-04-08' '402','val_402','2008-04-09' '402','val_402','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-09' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '403','val_403','2008-04-08' '404','val_404','2008-04-08' '404','val_404','2008-04-08' '404','val_404','2008-04-08' '404','val_404','2008-04-08' '404','val_404','2008-04-09' '404','val_404','2008-04-09' '404','val_404','2008-04-09' '404','val_404','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-09' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '406','val_406','2008-04-08' '407','val_407','2008-04-08' '407','val_407','2008-04-08' '407','val_407','2008-04-09' '407','val_407','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-09' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '409','val_409','2008-04-08' '41','val_41','2008-04-08' '41','val_41','2008-04-08' '41','val_41','2008-04-09' '41','val_41','2008-04-09' '411','val_411','2008-04-09' '411','val_411','2008-04-09' '411','val_411','2008-04-08' '411','val_411','2008-04-08' '413','val_413','2008-04-08' '413','val_413','2008-04-08' '413','val_413','2008-04-08' '413','val_413','2008-04-08' '413','val_413','2008-04-09' '413','val_413','2008-04-09' '413','val_413','2008-04-09' '413','val_413','2008-04-09' '414','val_414','2008-04-09' '414','val_414','2008-04-09' '414','val_414','2008-04-09' '414','val_414','2008-04-09' '414','val_414','2008-04-08' '414','val_414','2008-04-08' '414','val_414','2008-04-08' '414','val_414','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-08' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '417','val_417','2008-04-09' '418','val_418','2008-04-09' '418','val_418','2008-04-09' '418','val_418','2008-04-08' '418','val_418','2008-04-08' '419','val_419','2008-04-08' '419','val_419','2008-04-08' '419','val_419','2008-04-09' '419','val_419','2008-04-09' '42','val_42','2008-04-09' '42','val_42','2008-04-09' '42','val_42','2008-04-09' '42','val_42','2008-04-09' '42','val_42','2008-04-08' '42','val_42','2008-04-08' '42','val_42','2008-04-08' '42','val_42','2008-04-08' '421','val_421','2008-04-08' '421','val_421','2008-04-08' '421','val_421','2008-04-09' '421','val_421','2008-04-09' '424','val_424','2008-04-09' '424','val_424','2008-04-09' '424','val_424','2008-04-09' '424','val_424','2008-04-09' '424','val_424','2008-04-08' '424','val_424','2008-04-08' '424','val_424','2008-04-08' '424','val_424','2008-04-08' '427','val_427','2008-04-08' '427','val_427','2008-04-08' '427','val_427','2008-04-09' '427','val_427','2008-04-09' '429','val_429','2008-04-09' '429','val_429','2008-04-09' '429','val_429','2008-04-09' '429','val_429','2008-04-09' '429','val_429','2008-04-08' '429','val_429','2008-04-08' '429','val_429','2008-04-08' '429','val_429','2008-04-08' '43','val_43','2008-04-08' '43','val_43','2008-04-08' '43','val_43','2008-04-09' '43','val_43','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-09' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '430','val_430','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-08' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '431','val_431','2008-04-09' '432','val_432','2008-04-09' '432','val_432','2008-04-09' '432','val_432','2008-04-08' '432','val_432','2008-04-08' '435','val_435','2008-04-08' '435','val_435','2008-04-08' '435','val_435','2008-04-09' '435','val_435','2008-04-09' '436','val_436','2008-04-09' '436','val_436','2008-04-09' '436','val_436','2008-04-08' '436','val_436','2008-04-08' '437','val_437','2008-04-08' '437','val_437','2008-04-08' '437','val_437','2008-04-09' '437','val_437','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-09' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '438','val_438','2008-04-08' '439','val_439','2008-04-08' '439','val_439','2008-04-08' '439','val_439','2008-04-08' '439','val_439','2008-04-08' '439','val_439','2008-04-09' '439','val_439','2008-04-09' '439','val_439','2008-04-09' '439','val_439','2008-04-09' '44','val_44','2008-04-09' '44','val_44','2008-04-09' '44','val_44','2008-04-08' '44','val_44','2008-04-08' '443','val_443','2008-04-08' '443','val_443','2008-04-08' '443','val_443','2008-04-09' '443','val_443','2008-04-09' '444','val_444','2008-04-09' '444','val_444','2008-04-09' '444','val_444','2008-04-08' '444','val_444','2008-04-08' '446','val_446','2008-04-08' '446','val_446','2008-04-08' '446','val_446','2008-04-09' '446','val_446','2008-04-09' '448','val_448','2008-04-09' '448','val_448','2008-04-09' '448','val_448','2008-04-08' '448','val_448','2008-04-08' '449','val_449','2008-04-08' '449','val_449','2008-04-08' '449','val_449','2008-04-09' '449','val_449','2008-04-09' '452','val_452','2008-04-09' '452','val_452','2008-04-09' '452','val_452','2008-04-08' '452','val_452','2008-04-08' '453','val_453','2008-04-08' '453','val_453','2008-04-08' '453','val_453','2008-04-09' '453','val_453','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-09' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '454','val_454','2008-04-08' '455','val_455','2008-04-08' '455','val_455','2008-04-08' '455','val_455','2008-04-09' '455','val_455','2008-04-09' '457','val_457','2008-04-09' '457','val_457','2008-04-09' '457','val_457','2008-04-08' '457','val_457','2008-04-08' '458','val_458','2008-04-08' '458','val_458','2008-04-08' '458','val_458','2008-04-08' '458','val_458','2008-04-08' '458','val_458','2008-04-09' '458','val_458','2008-04-09' '458','val_458','2008-04-09' '458','val_458','2008-04-09' '459','val_459','2008-04-09' '459','val_459','2008-04-09' '459','val_459','2008-04-09' '459','val_459','2008-04-09' '459','val_459','2008-04-08' '459','val_459','2008-04-08' '459','val_459','2008-04-08' '459','val_459','2008-04-08' '460','val_460','2008-04-08' '460','val_460','2008-04-08' '460','val_460','2008-04-09' '460','val_460','2008-04-09' '462','val_462','2008-04-09' '462','val_462','2008-04-09' '462','val_462','2008-04-09' '462','val_462','2008-04-09' '462','val_462','2008-04-08' '462','val_462','2008-04-08' '462','val_462','2008-04-08' '462','val_462','2008-04-08' '463','val_463','2008-04-08' '463','val_463','2008-04-08' '463','val_463','2008-04-08' '463','val_463','2008-04-08' '463','val_463','2008-04-09' '463','val_463','2008-04-09' '463','val_463','2008-04-09' '463','val_463','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-09' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '466','val_466','2008-04-08' '467','val_467','2008-04-08' '467','val_467','2008-04-08' '467','val_467','2008-04-09' '467','val_467','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-09' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '468','val_468','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-08' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '469','val_469','2008-04-09' '47','val_47','2008-04-09' '47','val_47','2008-04-09' '47','val_47','2008-04-08' '47','val_47','2008-04-08' '470','val_470','2008-04-08' '470','val_470','2008-04-08' '470','val_470','2008-04-09' '470','val_470','2008-04-09' '472','val_472','2008-04-09' '472','val_472','2008-04-09' '472','val_472','2008-04-08' '472','val_472','2008-04-08' '475','val_475','2008-04-08' '475','val_475','2008-04-08' '475','val_475','2008-04-09' '475','val_475','2008-04-09' '477','val_477','2008-04-09' '477','val_477','2008-04-09' '477','val_477','2008-04-08' '477','val_477','2008-04-08' '478','val_478','2008-04-08' '478','val_478','2008-04-08' '478','val_478','2008-04-08' '478','val_478','2008-04-08' '478','val_478','2008-04-09' '478','val_478','2008-04-09' '478','val_478','2008-04-09' '478','val_478','2008-04-09' '479','val_479','2008-04-09' '479','val_479','2008-04-09' '479','val_479','2008-04-08' '479','val_479','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-08' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '480','val_480','2008-04-09' '481','val_481','2008-04-09' '481','val_481','2008-04-09' '481','val_481','2008-04-08' '481','val_481','2008-04-08' '482','val_482','2008-04-08' '482','val_482','2008-04-08' '482','val_482','2008-04-09' '482','val_482','2008-04-09' '483','val_483','2008-04-09' '483','val_483','2008-04-09' '483','val_483','2008-04-08' '483','val_483','2008-04-08' '484','val_484','2008-04-08' '484','val_484','2008-04-08' '484','val_484','2008-04-09' '484','val_484','2008-04-09' '485','val_485','2008-04-09' '485','val_485','2008-04-09' '485','val_485','2008-04-08' '485','val_485','2008-04-08' '487','val_487','2008-04-08' '487','val_487','2008-04-08' '487','val_487','2008-04-09' '487','val_487','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-09' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '489','val_489','2008-04-08' '490','val_490','2008-04-08' '490','val_490','2008-04-08' '490','val_490','2008-04-09' '490','val_490','2008-04-09' '491','val_491','2008-04-09' '491','val_491','2008-04-09' '491','val_491','2008-04-08' '491','val_491','2008-04-08' '492','val_492','2008-04-08' '492','val_492','2008-04-08' '492','val_492','2008-04-08' '492','val_492','2008-04-08' '492','val_492','2008-04-09' '492','val_492','2008-04-09' '492','val_492','2008-04-09' '492','val_492','2008-04-09' '493','val_493','2008-04-09' '493','val_493','2008-04-09' '493','val_493','2008-04-08' '493','val_493','2008-04-08' '494','val_494','2008-04-08' '494','val_494','2008-04-08' '494','val_494','2008-04-09' '494','val_494','2008-04-09' '495','val_495','2008-04-09' '495','val_495','2008-04-09' '495','val_495','2008-04-08' '495','val_495','2008-04-08' '496','val_496','2008-04-08' '496','val_496','2008-04-08' '496','val_496','2008-04-09' '496','val_496','2008-04-09' '497','val_497','2008-04-09' '497','val_497','2008-04-09' '497','val_497','2008-04-08' '497','val_497','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-08' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '498','val_498','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-09' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '5','val_5','2008-04-08' '51','val_51','2008-04-08' '51','val_51','2008-04-08' '51','val_51','2008-04-08' '51','val_51','2008-04-08' '51','val_51','2008-04-09' '51','val_51','2008-04-09' '51','val_51','2008-04-09' '51','val_51','2008-04-09' '53','val_53','2008-04-09' '53','val_53','2008-04-09' '53','val_53','2008-04-08' '53','val_53','2008-04-08' '54','val_54','2008-04-08' '54','val_54','2008-04-08' '54','val_54','2008-04-09' '54','val_54','2008-04-09' '57','val_57','2008-04-09' '57','val_57','2008-04-09' '57','val_57','2008-04-08' '57','val_57','2008-04-08' '58','val_58','2008-04-08' '58','val_58','2008-04-08' '58','val_58','2008-04-08' '58','val_58','2008-04-08' '58','val_58','2008-04-09' '58','val_58','2008-04-09' '58','val_58','2008-04-09' '58','val_58','2008-04-09' '64','val_64','2008-04-09' '64','val_64','2008-04-09' '64','val_64','2008-04-08' '64','val_64','2008-04-08' '65','val_65','2008-04-08' '65','val_65','2008-04-08' '65','val_65','2008-04-09' '65','val_65','2008-04-09' '66','val_66','2008-04-09' '66','val_66','2008-04-09' '66','val_66','2008-04-08' '66','val_66','2008-04-08' '67','val_67','2008-04-08' '67','val_67','2008-04-08' '67','val_67','2008-04-08' '67','val_67','2008-04-08' '67','val_67','2008-04-09' '67','val_67','2008-04-09' '67','val_67','2008-04-09' '67','val_67','2008-04-09' '69','val_69','2008-04-09' '69','val_69','2008-04-09' '69','val_69','2008-04-08' '69','val_69','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-08' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '70','val_70','2008-04-09' '72','val_72','2008-04-09' '72','val_72','2008-04-09' '72','val_72','2008-04-09' '72','val_72','2008-04-09' '72','val_72','2008-04-08' '72','val_72','2008-04-08' '72','val_72','2008-04-08' '72','val_72','2008-04-08' '74','val_74','2008-04-08' '74','val_74','2008-04-08' '74','val_74','2008-04-09' '74','val_74','2008-04-09' '76','val_76','2008-04-09' '76','val_76','2008-04-09' '76','val_76','2008-04-09' '76','val_76','2008-04-09' '76','val_76','2008-04-08' '76','val_76','2008-04-08' '76','val_76','2008-04-08' '76','val_76','2008-04-08' '77','val_77','2008-04-08' '77','val_77','2008-04-08' '77','val_77','2008-04-09' '77','val_77','2008-04-09' '78','val_78','2008-04-09' '78','val_78','2008-04-09' '78','val_78','2008-04-08' '78','val_78','2008-04-08' '8','val_8','2008-04-08' '8','val_8','2008-04-08' '8','val_8','2008-04-09' '8','val_8','2008-04-09' '80','val_80','2008-04-09' '80','val_80','2008-04-09' '80','val_80','2008-04-08' '80','val_80','2008-04-08' '82','val_82','2008-04-08' '82','val_82','2008-04-08' '82','val_82','2008-04-09' '82','val_82','2008-04-09' '83','val_83','2008-04-09' '83','val_83','2008-04-09' '83','val_83','2008-04-09' '83','val_83','2008-04-09' '83','val_83','2008-04-08' '83','val_83','2008-04-08' '83','val_83','2008-04-08' '83','val_83','2008-04-08' '84','val_84','2008-04-08' '84','val_84','2008-04-08' '84','val_84','2008-04-08' '84','val_84','2008-04-08' '84','val_84','2008-04-09' '84','val_84','2008-04-09' '84','val_84','2008-04-09' '84','val_84','2008-04-09' '85','val_85','2008-04-09' '85','val_85','2008-04-09' '85','val_85','2008-04-08' '85','val_85','2008-04-08' '86','val_86','2008-04-08' '86','val_86','2008-04-08' '86','val_86','2008-04-09' '86','val_86','2008-04-09' '87','val_87','2008-04-09' '87','val_87','2008-04-09' '87','val_87','2008-04-08' '87','val_87','2008-04-08' '9','val_9','2008-04-08' '9','val_9','2008-04-08' '9','val_9','2008-04-09' '9','val_9','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-09' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '90','val_90','2008-04-08' '92','val_92','2008-04-08' '92','val_92','2008-04-08' '92','val_92','2008-04-09' '92','val_92','2008-04-09' '95','val_95','2008-04-09' '95','val_95','2008-04-09' '95','val_95','2008-04-09' '95','val_95','2008-04-09' '95','val_95','2008-04-08' '95','val_95','2008-04-08' '95','val_95','2008-04-08' '95','val_95','2008-04-08' '96','val_96','2008-04-08' '96','val_96','2008-04-08' '96','val_96','2008-04-09' '96','val_96','2008-04-09' '97','val_97','2008-04-09' '97','val_97','2008-04-09' '97','val_97','2008-04-09' '97','val_97','2008-04-09' '97','val_97','2008-04-08' '97','val_97','2008-04-08' '97','val_97','2008-04-08' '97','val_97','2008-04-08' '98','val_98','2008-04-08' '98','val_98','2008-04-08' '98','val_98','2008-04-08' '98','val_98','2008-04-08' '98','val_98','2008-04-09' '98','val_98','2008-04-09' '98','val_98','2008-04-09' '98','val_98','2008-04-09' 2,000 rows selected >>> !record