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