You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2017/02/03 21:50:18 UTC
[05/51] [partial] hive git commit: HIVE-15790: Remove unused beeline
golden files (Gunther Hagleitner, reviewed by Sergey Shelukhin)
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input40.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input40.q.out b/ql/src/test/results/beelinepositive/input40.q.out
deleted file mode 100644
index 72ee053..0000000
--- a/ql/src/test/results/beelinepositive/input40.q.out
+++ /dev/null
@@ -1,2030 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input40.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input40.q
->>>
->>>
->>>
->>> create table tmp_insert_test (key string, value string) stored as textfile;
-No rows affected
->>> load data local inpath '../data/files/kv1.txt' into table tmp_insert_test;
-No rows affected
->>> select * from tmp_insert_test;
-'key','value'
-'238','val_238'
-'86','val_86'
-'311','val_311'
-'27','val_27'
-'165','val_165'
-'409','val_409'
-'255','val_255'
-'278','val_278'
-'98','val_98'
-'484','val_484'
-'265','val_265'
-'193','val_193'
-'401','val_401'
-'150','val_150'
-'273','val_273'
-'224','val_224'
-'369','val_369'
-'66','val_66'
-'128','val_128'
-'213','val_213'
-'146','val_146'
-'406','val_406'
-'429','val_429'
-'374','val_374'
-'152','val_152'
-'469','val_469'
-'145','val_145'
-'495','val_495'
-'37','val_37'
-'327','val_327'
-'281','val_281'
-'277','val_277'
-'209','val_209'
-'15','val_15'
-'82','val_82'
-'403','val_403'
-'166','val_166'
-'417','val_417'
-'430','val_430'
-'252','val_252'
-'292','val_292'
-'219','val_219'
-'287','val_287'
-'153','val_153'
-'193','val_193'
-'338','val_338'
-'446','val_446'
-'459','val_459'
-'394','val_394'
-'237','val_237'
-'482','val_482'
-'174','val_174'
-'413','val_413'
-'494','val_494'
-'207','val_207'
-'199','val_199'
-'466','val_466'
-'208','val_208'
-'174','val_174'
-'399','val_399'
-'396','val_396'
-'247','val_247'
-'417','val_417'
-'489','val_489'
-'162','val_162'
-'377','val_377'
-'397','val_397'
-'309','val_309'
-'365','val_365'
-'266','val_266'
-'439','val_439'
-'342','val_342'
-'367','val_367'
-'325','val_325'
-'167','val_167'
-'195','val_195'
-'475','val_475'
-'17','val_17'
-'113','val_113'
-'155','val_155'
-'203','val_203'
-'339','val_339'
-'0','val_0'
-'455','val_455'
-'128','val_128'
-'311','val_311'
-'316','val_316'
-'57','val_57'
-'302','val_302'
-'205','val_205'
-'149','val_149'
-'438','val_438'
-'345','val_345'
-'129','val_129'
-'170','val_170'
-'20','val_20'
-'489','val_489'
-'157','val_157'
-'378','val_378'
-'221','val_221'
-'92','val_92'
-'111','val_111'
-'47','val_47'
-'72','val_72'
-'4','val_4'
-'280','val_280'
-'35','val_35'
-'427','val_427'
-'277','val_277'
-'208','val_208'
-'356','val_356'
-'399','val_399'
-'169','val_169'
-'382','val_382'
-'498','val_498'
-'125','val_125'
-'386','val_386'
-'437','val_437'
-'469','val_469'
-'192','val_192'
-'286','val_286'
-'187','val_187'
-'176','val_176'
-'54','val_54'
-'459','val_459'
-'51','val_51'
-'138','val_138'
-'103','val_103'
-'239','val_239'
-'213','val_213'
-'216','val_216'
-'430','val_430'
-'278','val_278'
-'176','val_176'
-'289','val_289'
-'221','val_221'
-'65','val_65'
-'318','val_318'
-'332','val_332'
-'311','val_311'
-'275','val_275'
-'137','val_137'
-'241','val_241'
-'83','val_83'
-'333','val_333'
-'180','val_180'
-'284','val_284'
-'12','val_12'
-'230','val_230'
-'181','val_181'
-'67','val_67'
-'260','val_260'
-'404','val_404'
-'384','val_384'
-'489','val_489'
-'353','val_353'
-'373','val_373'
-'272','val_272'
-'138','val_138'
-'217','val_217'
-'84','val_84'
-'348','val_348'
-'466','val_466'
-'58','val_58'
-'8','val_8'
-'411','val_411'
-'230','val_230'
-'208','val_208'
-'348','val_348'
-'24','val_24'
-'463','val_463'
-'431','val_431'
-'179','val_179'
-'172','val_172'
-'42','val_42'
-'129','val_129'
-'158','val_158'
-'119','val_119'
-'496','val_496'
-'0','val_0'
-'322','val_322'
-'197','val_197'
-'468','val_468'
-'393','val_393'
-'454','val_454'
-'100','val_100'
-'298','val_298'
-'199','val_199'
-'191','val_191'
-'418','val_418'
-'96','val_96'
-'26','val_26'
-'165','val_165'
-'327','val_327'
-'230','val_230'
-'205','val_205'
-'120','val_120'
-'131','val_131'
-'51','val_51'
-'404','val_404'
-'43','val_43'
-'436','val_436'
-'156','val_156'
-'469','val_469'
-'468','val_468'
-'308','val_308'
-'95','val_95'
-'196','val_196'
-'288','val_288'
-'481','val_481'
-'457','val_457'
-'98','val_98'
-'282','val_282'
-'197','val_197'
-'187','val_187'
-'318','val_318'
-'318','val_318'
-'409','val_409'
-'470','val_470'
-'137','val_137'
-'369','val_369'
-'316','val_316'
-'169','val_169'
-'413','val_413'
-'85','val_85'
-'77','val_77'
-'0','val_0'
-'490','val_490'
-'87','val_87'
-'364','val_364'
-'179','val_179'
-'118','val_118'
-'134','val_134'
-'395','val_395'
-'282','val_282'
-'138','val_138'
-'238','val_238'
-'419','val_419'
-'15','val_15'
-'118','val_118'
-'72','val_72'
-'90','val_90'
-'307','val_307'
-'19','val_19'
-'435','val_435'
-'10','val_10'
-'277','val_277'
-'273','val_273'
-'306','val_306'
-'224','val_224'
-'309','val_309'
-'389','val_389'
-'327','val_327'
-'242','val_242'
-'369','val_369'
-'392','val_392'
-'272','val_272'
-'331','val_331'
-'401','val_401'
-'242','val_242'
-'452','val_452'
-'177','val_177'
-'226','val_226'
-'5','val_5'
-'497','val_497'
-'402','val_402'
-'396','val_396'
-'317','val_317'
-'395','val_395'
-'58','val_58'
-'35','val_35'
-'336','val_336'
-'95','val_95'
-'11','val_11'
-'168','val_168'
-'34','val_34'
-'229','val_229'
-'233','val_233'
-'143','val_143'
-'472','val_472'
-'322','val_322'
-'498','val_498'
-'160','val_160'
-'195','val_195'
-'42','val_42'
-'321','val_321'
-'430','val_430'
-'119','val_119'
-'489','val_489'
-'458','val_458'
-'78','val_78'
-'76','val_76'
-'41','val_41'
-'223','val_223'
-'492','val_492'
-'149','val_149'
-'449','val_449'
-'218','val_218'
-'228','val_228'
-'138','val_138'
-'453','val_453'
-'30','val_30'
-'209','val_209'
-'64','val_64'
-'468','val_468'
-'76','val_76'
-'74','val_74'
-'342','val_342'
-'69','val_69'
-'230','val_230'
-'33','val_33'
-'368','val_368'
-'103','val_103'
-'296','val_296'
-'113','val_113'
-'216','val_216'
-'367','val_367'
-'344','val_344'
-'167','val_167'
-'274','val_274'
-'219','val_219'
-'239','val_239'
-'485','val_485'
-'116','val_116'
-'223','val_223'
-'256','val_256'
-'263','val_263'
-'70','val_70'
-'487','val_487'
-'480','val_480'
-'401','val_401'
-'288','val_288'
-'191','val_191'
-'5','val_5'
-'244','val_244'
-'438','val_438'
-'128','val_128'
-'467','val_467'
-'432','val_432'
-'202','val_202'
-'316','val_316'
-'229','val_229'
-'469','val_469'
-'463','val_463'
-'280','val_280'
-'2','val_2'
-'35','val_35'
-'283','val_283'
-'331','val_331'
-'235','val_235'
-'80','val_80'
-'44','val_44'
-'193','val_193'
-'321','val_321'
-'335','val_335'
-'104','val_104'
-'466','val_466'
-'366','val_366'
-'175','val_175'
-'403','val_403'
-'483','val_483'
-'53','val_53'
-'105','val_105'
-'257','val_257'
-'406','val_406'
-'409','val_409'
-'190','val_190'
-'406','val_406'
-'401','val_401'
-'114','val_114'
-'258','val_258'
-'90','val_90'
-'203','val_203'
-'262','val_262'
-'348','val_348'
-'424','val_424'
-'12','val_12'
-'396','val_396'
-'201','val_201'
-'217','val_217'
-'164','val_164'
-'431','val_431'
-'454','val_454'
-'478','val_478'
-'298','val_298'
-'125','val_125'
-'431','val_431'
-'164','val_164'
-'424','val_424'
-'187','val_187'
-'382','val_382'
-'5','val_5'
-'70','val_70'
-'397','val_397'
-'480','val_480'
-'291','val_291'
-'24','val_24'
-'351','val_351'
-'255','val_255'
-'104','val_104'
-'70','val_70'
-'163','val_163'
-'438','val_438'
-'119','val_119'
-'414','val_414'
-'200','val_200'
-'491','val_491'
-'237','val_237'
-'439','val_439'
-'360','val_360'
-'248','val_248'
-'479','val_479'
-'305','val_305'
-'417','val_417'
-'199','val_199'
-'444','val_444'
-'120','val_120'
-'429','val_429'
-'169','val_169'
-'443','val_443'
-'323','val_323'
-'325','val_325'
-'277','val_277'
-'230','val_230'
-'478','val_478'
-'178','val_178'
-'468','val_468'
-'310','val_310'
-'317','val_317'
-'333','val_333'
-'493','val_493'
-'460','val_460'
-'207','val_207'
-'249','val_249'
-'265','val_265'
-'480','val_480'
-'83','val_83'
-'136','val_136'
-'353','val_353'
-'172','val_172'
-'214','val_214'
-'462','val_462'
-'233','val_233'
-'406','val_406'
-'133','val_133'
-'175','val_175'
-'189','val_189'
-'454','val_454'
-'375','val_375'
-'401','val_401'
-'421','val_421'
-'407','val_407'
-'384','val_384'
-'256','val_256'
-'26','val_26'
-'134','val_134'
-'67','val_67'
-'384','val_384'
-'379','val_379'
-'18','val_18'
-'462','val_462'
-'492','val_492'
-'100','val_100'
-'298','val_298'
-'9','val_9'
-'341','val_341'
-'498','val_498'
-'146','val_146'
-'458','val_458'
-'362','val_362'
-'186','val_186'
-'285','val_285'
-'348','val_348'
-'167','val_167'
-'18','val_18'
-'273','val_273'
-'183','val_183'
-'281','val_281'
-'344','val_344'
-'97','val_97'
-'469','val_469'
-'315','val_315'
-'84','val_84'
-'28','val_28'
-'37','val_37'
-'448','val_448'
-'152','val_152'
-'348','val_348'
-'307','val_307'
-'194','val_194'
-'414','val_414'
-'477','val_477'
-'222','val_222'
-'126','val_126'
-'90','val_90'
-'169','val_169'
-'403','val_403'
-'400','val_400'
-'200','val_200'
-'97','val_97'
-500 rows selected
->>>
->>> create table tmp_insert_test_p (key string, value string) partitioned by (ds string) stored as textfile;
-No rows affected
->>>
->>> load data local inpath '../data/files/kv1.txt' into table tmp_insert_test_p partition (ds = '2009-08-01');
-No rows affected
->>> select * from tmp_insert_test_p where ds= '2009-08-01'
-order by key, value;
-'key','value','ds'
-'0','val_0','2009-08-01'
-'0','val_0','2009-08-01'
-'0','val_0','2009-08-01'
-'10','val_10','2009-08-01'
-'100','val_100','2009-08-01'
-'100','val_100','2009-08-01'
-'103','val_103','2009-08-01'
-'103','val_103','2009-08-01'
-'104','val_104','2009-08-01'
-'104','val_104','2009-08-01'
-'105','val_105','2009-08-01'
-'11','val_11','2009-08-01'
-'111','val_111','2009-08-01'
-'113','val_113','2009-08-01'
-'113','val_113','2009-08-01'
-'114','val_114','2009-08-01'
-'116','val_116','2009-08-01'
-'118','val_118','2009-08-01'
-'118','val_118','2009-08-01'
-'119','val_119','2009-08-01'
-'119','val_119','2009-08-01'
-'119','val_119','2009-08-01'
-'12','val_12','2009-08-01'
-'12','val_12','2009-08-01'
-'120','val_120','2009-08-01'
-'120','val_120','2009-08-01'
-'125','val_125','2009-08-01'
-'125','val_125','2009-08-01'
-'126','val_126','2009-08-01'
-'128','val_128','2009-08-01'
-'128','val_128','2009-08-01'
-'128','val_128','2009-08-01'
-'129','val_129','2009-08-01'
-'129','val_129','2009-08-01'
-'131','val_131','2009-08-01'
-'133','val_133','2009-08-01'
-'134','val_134','2009-08-01'
-'134','val_134','2009-08-01'
-'136','val_136','2009-08-01'
-'137','val_137','2009-08-01'
-'137','val_137','2009-08-01'
-'138','val_138','2009-08-01'
-'138','val_138','2009-08-01'
-'138','val_138','2009-08-01'
-'138','val_138','2009-08-01'
-'143','val_143','2009-08-01'
-'145','val_145','2009-08-01'
-'146','val_146','2009-08-01'
-'146','val_146','2009-08-01'
-'149','val_149','2009-08-01'
-'149','val_149','2009-08-01'
-'15','val_15','2009-08-01'
-'15','val_15','2009-08-01'
-'150','val_150','2009-08-01'
-'152','val_152','2009-08-01'
-'152','val_152','2009-08-01'
-'153','val_153','2009-08-01'
-'155','val_155','2009-08-01'
-'156','val_156','2009-08-01'
-'157','val_157','2009-08-01'
-'158','val_158','2009-08-01'
-'160','val_160','2009-08-01'
-'162','val_162','2009-08-01'
-'163','val_163','2009-08-01'
-'164','val_164','2009-08-01'
-'164','val_164','2009-08-01'
-'165','val_165','2009-08-01'
-'165','val_165','2009-08-01'
-'166','val_166','2009-08-01'
-'167','val_167','2009-08-01'
-'167','val_167','2009-08-01'
-'167','val_167','2009-08-01'
-'168','val_168','2009-08-01'
-'169','val_169','2009-08-01'
-'169','val_169','2009-08-01'
-'169','val_169','2009-08-01'
-'169','val_169','2009-08-01'
-'17','val_17','2009-08-01'
-'170','val_170','2009-08-01'
-'172','val_172','2009-08-01'
-'172','val_172','2009-08-01'
-'174','val_174','2009-08-01'
-'174','val_174','2009-08-01'
-'175','val_175','2009-08-01'
-'175','val_175','2009-08-01'
-'176','val_176','2009-08-01'
-'176','val_176','2009-08-01'
-'177','val_177','2009-08-01'
-'178','val_178','2009-08-01'
-'179','val_179','2009-08-01'
-'179','val_179','2009-08-01'
-'18','val_18','2009-08-01'
-'18','val_18','2009-08-01'
-'180','val_180','2009-08-01'
-'181','val_181','2009-08-01'
-'183','val_183','2009-08-01'
-'186','val_186','2009-08-01'
-'187','val_187','2009-08-01'
-'187','val_187','2009-08-01'
-'187','val_187','2009-08-01'
-'189','val_189','2009-08-01'
-'19','val_19','2009-08-01'
-'190','val_190','2009-08-01'
-'191','val_191','2009-08-01'
-'191','val_191','2009-08-01'
-'192','val_192','2009-08-01'
-'193','val_193','2009-08-01'
-'193','val_193','2009-08-01'
-'193','val_193','2009-08-01'
-'194','val_194','2009-08-01'
-'195','val_195','2009-08-01'
-'195','val_195','2009-08-01'
-'196','val_196','2009-08-01'
-'197','val_197','2009-08-01'
-'197','val_197','2009-08-01'
-'199','val_199','2009-08-01'
-'199','val_199','2009-08-01'
-'199','val_199','2009-08-01'
-'2','val_2','2009-08-01'
-'20','val_20','2009-08-01'
-'200','val_200','2009-08-01'
-'200','val_200','2009-08-01'
-'201','val_201','2009-08-01'
-'202','val_202','2009-08-01'
-'203','val_203','2009-08-01'
-'203','val_203','2009-08-01'
-'205','val_205','2009-08-01'
-'205','val_205','2009-08-01'
-'207','val_207','2009-08-01'
-'207','val_207','2009-08-01'
-'208','val_208','2009-08-01'
-'208','val_208','2009-08-01'
-'208','val_208','2009-08-01'
-'209','val_209','2009-08-01'
-'209','val_209','2009-08-01'
-'213','val_213','2009-08-01'
-'213','val_213','2009-08-01'
-'214','val_214','2009-08-01'
-'216','val_216','2009-08-01'
-'216','val_216','2009-08-01'
-'217','val_217','2009-08-01'
-'217','val_217','2009-08-01'
-'218','val_218','2009-08-01'
-'219','val_219','2009-08-01'
-'219','val_219','2009-08-01'
-'221','val_221','2009-08-01'
-'221','val_221','2009-08-01'
-'222','val_222','2009-08-01'
-'223','val_223','2009-08-01'
-'223','val_223','2009-08-01'
-'224','val_224','2009-08-01'
-'224','val_224','2009-08-01'
-'226','val_226','2009-08-01'
-'228','val_228','2009-08-01'
-'229','val_229','2009-08-01'
-'229','val_229','2009-08-01'
-'230','val_230','2009-08-01'
-'230','val_230','2009-08-01'
-'230','val_230','2009-08-01'
-'230','val_230','2009-08-01'
-'230','val_230','2009-08-01'
-'233','val_233','2009-08-01'
-'233','val_233','2009-08-01'
-'235','val_235','2009-08-01'
-'237','val_237','2009-08-01'
-'237','val_237','2009-08-01'
-'238','val_238','2009-08-01'
-'238','val_238','2009-08-01'
-'239','val_239','2009-08-01'
-'239','val_239','2009-08-01'
-'24','val_24','2009-08-01'
-'24','val_24','2009-08-01'
-'241','val_241','2009-08-01'
-'242','val_242','2009-08-01'
-'242','val_242','2009-08-01'
-'244','val_244','2009-08-01'
-'247','val_247','2009-08-01'
-'248','val_248','2009-08-01'
-'249','val_249','2009-08-01'
-'252','val_252','2009-08-01'
-'255','val_255','2009-08-01'
-'255','val_255','2009-08-01'
-'256','val_256','2009-08-01'
-'256','val_256','2009-08-01'
-'257','val_257','2009-08-01'
-'258','val_258','2009-08-01'
-'26','val_26','2009-08-01'
-'26','val_26','2009-08-01'
-'260','val_260','2009-08-01'
-'262','val_262','2009-08-01'
-'263','val_263','2009-08-01'
-'265','val_265','2009-08-01'
-'265','val_265','2009-08-01'
-'266','val_266','2009-08-01'
-'27','val_27','2009-08-01'
-'272','val_272','2009-08-01'
-'272','val_272','2009-08-01'
-'273','val_273','2009-08-01'
-'273','val_273','2009-08-01'
-'273','val_273','2009-08-01'
-'274','val_274','2009-08-01'
-'275','val_275','2009-08-01'
-'277','val_277','2009-08-01'
-'277','val_277','2009-08-01'
-'277','val_277','2009-08-01'
-'277','val_277','2009-08-01'
-'278','val_278','2009-08-01'
-'278','val_278','2009-08-01'
-'28','val_28','2009-08-01'
-'280','val_280','2009-08-01'
-'280','val_280','2009-08-01'
-'281','val_281','2009-08-01'
-'281','val_281','2009-08-01'
-'282','val_282','2009-08-01'
-'282','val_282','2009-08-01'
-'283','val_283','2009-08-01'
-'284','val_284','2009-08-01'
-'285','val_285','2009-08-01'
-'286','val_286','2009-08-01'
-'287','val_287','2009-08-01'
-'288','val_288','2009-08-01'
-'288','val_288','2009-08-01'
-'289','val_289','2009-08-01'
-'291','val_291','2009-08-01'
-'292','val_292','2009-08-01'
-'296','val_296','2009-08-01'
-'298','val_298','2009-08-01'
-'298','val_298','2009-08-01'
-'298','val_298','2009-08-01'
-'30','val_30','2009-08-01'
-'302','val_302','2009-08-01'
-'305','val_305','2009-08-01'
-'306','val_306','2009-08-01'
-'307','val_307','2009-08-01'
-'307','val_307','2009-08-01'
-'308','val_308','2009-08-01'
-'309','val_309','2009-08-01'
-'309','val_309','2009-08-01'
-'310','val_310','2009-08-01'
-'311','val_311','2009-08-01'
-'311','val_311','2009-08-01'
-'311','val_311','2009-08-01'
-'315','val_315','2009-08-01'
-'316','val_316','2009-08-01'
-'316','val_316','2009-08-01'
-'316','val_316','2009-08-01'
-'317','val_317','2009-08-01'
-'317','val_317','2009-08-01'
-'318','val_318','2009-08-01'
-'318','val_318','2009-08-01'
-'318','val_318','2009-08-01'
-'321','val_321','2009-08-01'
-'321','val_321','2009-08-01'
-'322','val_322','2009-08-01'
-'322','val_322','2009-08-01'
-'323','val_323','2009-08-01'
-'325','val_325','2009-08-01'
-'325','val_325','2009-08-01'
-'327','val_327','2009-08-01'
-'327','val_327','2009-08-01'
-'327','val_327','2009-08-01'
-'33','val_33','2009-08-01'
-'331','val_331','2009-08-01'
-'331','val_331','2009-08-01'
-'332','val_332','2009-08-01'
-'333','val_333','2009-08-01'
-'333','val_333','2009-08-01'
-'335','val_335','2009-08-01'
-'336','val_336','2009-08-01'
-'338','val_338','2009-08-01'
-'339','val_339','2009-08-01'
-'34','val_34','2009-08-01'
-'341','val_341','2009-08-01'
-'342','val_342','2009-08-01'
-'342','val_342','2009-08-01'
-'344','val_344','2009-08-01'
-'344','val_344','2009-08-01'
-'345','val_345','2009-08-01'
-'348','val_348','2009-08-01'
-'348','val_348','2009-08-01'
-'348','val_348','2009-08-01'
-'348','val_348','2009-08-01'
-'348','val_348','2009-08-01'
-'35','val_35','2009-08-01'
-'35','val_35','2009-08-01'
-'35','val_35','2009-08-01'
-'351','val_351','2009-08-01'
-'353','val_353','2009-08-01'
-'353','val_353','2009-08-01'
-'356','val_356','2009-08-01'
-'360','val_360','2009-08-01'
-'362','val_362','2009-08-01'
-'364','val_364','2009-08-01'
-'365','val_365','2009-08-01'
-'366','val_366','2009-08-01'
-'367','val_367','2009-08-01'
-'367','val_367','2009-08-01'
-'368','val_368','2009-08-01'
-'369','val_369','2009-08-01'
-'369','val_369','2009-08-01'
-'369','val_369','2009-08-01'
-'37','val_37','2009-08-01'
-'37','val_37','2009-08-01'
-'373','val_373','2009-08-01'
-'374','val_374','2009-08-01'
-'375','val_375','2009-08-01'
-'377','val_377','2009-08-01'
-'378','val_378','2009-08-01'
-'379','val_379','2009-08-01'
-'382','val_382','2009-08-01'
-'382','val_382','2009-08-01'
-'384','val_384','2009-08-01'
-'384','val_384','2009-08-01'
-'384','val_384','2009-08-01'
-'386','val_386','2009-08-01'
-'389','val_389','2009-08-01'
-'392','val_392','2009-08-01'
-'393','val_393','2009-08-01'
-'394','val_394','2009-08-01'
-'395','val_395','2009-08-01'
-'395','val_395','2009-08-01'
-'396','val_396','2009-08-01'
-'396','val_396','2009-08-01'
-'396','val_396','2009-08-01'
-'397','val_397','2009-08-01'
-'397','val_397','2009-08-01'
-'399','val_399','2009-08-01'
-'399','val_399','2009-08-01'
-'4','val_4','2009-08-01'
-'400','val_400','2009-08-01'
-'401','val_401','2009-08-01'
-'401','val_401','2009-08-01'
-'401','val_401','2009-08-01'
-'401','val_401','2009-08-01'
-'401','val_401','2009-08-01'
-'402','val_402','2009-08-01'
-'403','val_403','2009-08-01'
-'403','val_403','2009-08-01'
-'403','val_403','2009-08-01'
-'404','val_404','2009-08-01'
-'404','val_404','2009-08-01'
-'406','val_406','2009-08-01'
-'406','val_406','2009-08-01'
-'406','val_406','2009-08-01'
-'406','val_406','2009-08-01'
-'407','val_407','2009-08-01'
-'409','val_409','2009-08-01'
-'409','val_409','2009-08-01'
-'409','val_409','2009-08-01'
-'41','val_41','2009-08-01'
-'411','val_411','2009-08-01'
-'413','val_413','2009-08-01'
-'413','val_413','2009-08-01'
-'414','val_414','2009-08-01'
-'414','val_414','2009-08-01'
-'417','val_417','2009-08-01'
-'417','val_417','2009-08-01'
-'417','val_417','2009-08-01'
-'418','val_418','2009-08-01'
-'419','val_419','2009-08-01'
-'42','val_42','2009-08-01'
-'42','val_42','2009-08-01'
-'421','val_421','2009-08-01'
-'424','val_424','2009-08-01'
-'424','val_424','2009-08-01'
-'427','val_427','2009-08-01'
-'429','val_429','2009-08-01'
-'429','val_429','2009-08-01'
-'43','val_43','2009-08-01'
-'430','val_430','2009-08-01'
-'430','val_430','2009-08-01'
-'430','val_430','2009-08-01'
-'431','val_431','2009-08-01'
-'431','val_431','2009-08-01'
-'431','val_431','2009-08-01'
-'432','val_432','2009-08-01'
-'435','val_435','2009-08-01'
-'436','val_436','2009-08-01'
-'437','val_437','2009-08-01'
-'438','val_438','2009-08-01'
-'438','val_438','2009-08-01'
-'438','val_438','2009-08-01'
-'439','val_439','2009-08-01'
-'439','val_439','2009-08-01'
-'44','val_44','2009-08-01'
-'443','val_443','2009-08-01'
-'444','val_444','2009-08-01'
-'446','val_446','2009-08-01'
-'448','val_448','2009-08-01'
-'449','val_449','2009-08-01'
-'452','val_452','2009-08-01'
-'453','val_453','2009-08-01'
-'454','val_454','2009-08-01'
-'454','val_454','2009-08-01'
-'454','val_454','2009-08-01'
-'455','val_455','2009-08-01'
-'457','val_457','2009-08-01'
-'458','val_458','2009-08-01'
-'458','val_458','2009-08-01'
-'459','val_459','2009-08-01'
-'459','val_459','2009-08-01'
-'460','val_460','2009-08-01'
-'462','val_462','2009-08-01'
-'462','val_462','2009-08-01'
-'463','val_463','2009-08-01'
-'463','val_463','2009-08-01'
-'466','val_466','2009-08-01'
-'466','val_466','2009-08-01'
-'466','val_466','2009-08-01'
-'467','val_467','2009-08-01'
-'468','val_468','2009-08-01'
-'468','val_468','2009-08-01'
-'468','val_468','2009-08-01'
-'468','val_468','2009-08-01'
-'469','val_469','2009-08-01'
-'469','val_469','2009-08-01'
-'469','val_469','2009-08-01'
-'469','val_469','2009-08-01'
-'469','val_469','2009-08-01'
-'47','val_47','2009-08-01'
-'470','val_470','2009-08-01'
-'472','val_472','2009-08-01'
-'475','val_475','2009-08-01'
-'477','val_477','2009-08-01'
-'478','val_478','2009-08-01'
-'478','val_478','2009-08-01'
-'479','val_479','2009-08-01'
-'480','val_480','2009-08-01'
-'480','val_480','2009-08-01'
-'480','val_480','2009-08-01'
-'481','val_481','2009-08-01'
-'482','val_482','2009-08-01'
-'483','val_483','2009-08-01'
-'484','val_484','2009-08-01'
-'485','val_485','2009-08-01'
-'487','val_487','2009-08-01'
-'489','val_489','2009-08-01'
-'489','val_489','2009-08-01'
-'489','val_489','2009-08-01'
-'489','val_489','2009-08-01'
-'490','val_490','2009-08-01'
-'491','val_491','2009-08-01'
-'492','val_492','2009-08-01'
-'492','val_492','2009-08-01'
-'493','val_493','2009-08-01'
-'494','val_494','2009-08-01'
-'495','val_495','2009-08-01'
-'496','val_496','2009-08-01'
-'497','val_497','2009-08-01'
-'498','val_498','2009-08-01'
-'498','val_498','2009-08-01'
-'498','val_498','2009-08-01'
-'5','val_5','2009-08-01'
-'5','val_5','2009-08-01'
-'5','val_5','2009-08-01'
-'51','val_51','2009-08-01'
-'51','val_51','2009-08-01'
-'53','val_53','2009-08-01'
-'54','val_54','2009-08-01'
-'57','val_57','2009-08-01'
-'58','val_58','2009-08-01'
-'58','val_58','2009-08-01'
-'64','val_64','2009-08-01'
-'65','val_65','2009-08-01'
-'66','val_66','2009-08-01'
-'67','val_67','2009-08-01'
-'67','val_67','2009-08-01'
-'69','val_69','2009-08-01'
-'70','val_70','2009-08-01'
-'70','val_70','2009-08-01'
-'70','val_70','2009-08-01'
-'72','val_72','2009-08-01'
-'72','val_72','2009-08-01'
-'74','val_74','2009-08-01'
-'76','val_76','2009-08-01'
-'76','val_76','2009-08-01'
-'77','val_77','2009-08-01'
-'78','val_78','2009-08-01'
-'8','val_8','2009-08-01'
-'80','val_80','2009-08-01'
-'82','val_82','2009-08-01'
-'83','val_83','2009-08-01'
-'83','val_83','2009-08-01'
-'84','val_84','2009-08-01'
-'84','val_84','2009-08-01'
-'85','val_85','2009-08-01'
-'86','val_86','2009-08-01'
-'87','val_87','2009-08-01'
-'9','val_9','2009-08-01'
-'90','val_90','2009-08-01'
-'90','val_90','2009-08-01'
-'90','val_90','2009-08-01'
-'92','val_92','2009-08-01'
-'95','val_95','2009-08-01'
-'95','val_95','2009-08-01'
-'96','val_96','2009-08-01'
-'97','val_97','2009-08-01'
-'97','val_97','2009-08-01'
-'98','val_98','2009-08-01'
-'98','val_98','2009-08-01'
-500 rows selected
->>>
->>> load data local inpath '../data/files/kv2.txt' into table tmp_insert_test_p partition (ds = '2009-08-01');
-No rows affected
->>> select * from tmp_insert_test_p where ds= '2009-08-01'
-order by key, value;
-'key','value','ds'
-'0','val_0','2009-08-01'
-'0','val_0','2009-08-01'
-'0','val_0','2009-08-01'
-'0','val_1','2009-08-01'
-'0','val_1','2009-08-01'
-'1','val_2','2009-08-01'
-'10','val_10','2009-08-01'
-'10','val_11','2009-08-01'
-'100','val_100','2009-08-01'
-'100','val_100','2009-08-01'
-'100','val_101','2009-08-01'
-'100','val_101','2009-08-01'
-'101','val_102','2009-08-01'
-'102','val_103','2009-08-01'
-'103','val_103','2009-08-01'
-'103','val_103','2009-08-01'
-'104','val_104','2009-08-01'
-'104','val_104','2009-08-01'
-'104','val_105','2009-08-01'
-'104','val_105','2009-08-01'
-'104','val_105','2009-08-01'
-'105','val_105','2009-08-01'
-'105','val_106','2009-08-01'
-'105','val_106','2009-08-01'
-'106','val_107','2009-08-01'
-'11','val_11','2009-08-01'
-'11','val_12','2009-08-01'
-'11','val_12','2009-08-01'
-'11','val_12','2009-08-01'
-'110','val_111','2009-08-01'
-'111','val_111','2009-08-01'
-'113','val_113','2009-08-01'
-'113','val_113','2009-08-01'
-'114','val_114','2009-08-01'
-'114','val_115','2009-08-01'
-'114','val_115','2009-08-01'
-'114','val_115','2009-08-01'
-'116','val_116','2009-08-01'
-'116','val_117','2009-08-01'
-'117','val_118','2009-08-01'
-'117','val_118','2009-08-01'
-'118','val_118','2009-08-01'
-'118','val_118','2009-08-01'
-'118','val_119','2009-08-01'
-'118','val_119','2009-08-01'
-'118','val_119','2009-08-01'
-'119','val_119','2009-08-01'
-'119','val_119','2009-08-01'
-'119','val_119','2009-08-01'
-'119','val_120','2009-08-01'
-'119','val_120','2009-08-01'
-'119','val_120','2009-08-01'
-'12','val_12','2009-08-01'
-'12','val_12','2009-08-01'
-'12','val_13','2009-08-01'
-'120','val_120','2009-08-01'
-'120','val_120','2009-08-01'
-'120','val_121','2009-08-01'
-'121','val_122','2009-08-01'
-'121','val_122','2009-08-01'
-'122','val_123','2009-08-01'
-'122','val_123','2009-08-01'
-'122','val_123','2009-08-01'
-'123','val_124','2009-08-01'
-'123','val_124','2009-08-01'
-'125','val_125','2009-08-01'
-'125','val_125','2009-08-01'
-'125','val_126','2009-08-01'
-'126','val_126','2009-08-01'
-'126','val_127','2009-08-01'
-'126','val_127','2009-08-01'
-'128','val_128','2009-08-01'
-'128','val_128','2009-08-01'
-'128','val_128','2009-08-01'
-'128','val_129','2009-08-01'
-'128','val_129','2009-08-01'
-'129','val_129','2009-08-01'
-'129','val_129','2009-08-01'
-'129','val_130','2009-08-01'
-'129','val_130','2009-08-01'
-'131','val_131','2009-08-01'
-'132','val_133','2009-08-01'
-'132','val_133','2009-08-01'
-'133','val_133','2009-08-01'
-'133','val_134','2009-08-01'
-'134','val_134','2009-08-01'
-'134','val_134','2009-08-01'
-'134','val_135','2009-08-01'
-'135','val_136','2009-08-01'
-'135','val_136','2009-08-01'
-'135','val_136','2009-08-01'
-'136','val_136','2009-08-01'
-'136','val_137','2009-08-01'
-'137','val_137','2009-08-01'
-'137','val_137','2009-08-01'
-'137','val_138','2009-08-01'
-'138','val_138','2009-08-01'
-'138','val_138','2009-08-01'
-'138','val_138','2009-08-01'
-'138','val_138','2009-08-01'
-'138','val_139','2009-08-01'
-'138','val_139','2009-08-01'
-'140','val_141','2009-08-01'
-'143','val_143','2009-08-01'
-'143','val_144','2009-08-01'
-'144','val_145','2009-08-01'
-'145','val_145','2009-08-01'
-'146','val_146','2009-08-01'
-'146','val_146','2009-08-01'
-'147','val_148','2009-08-01'
-'147','val_148','2009-08-01'
-'149','val_149','2009-08-01'
-'149','val_149','2009-08-01'
-'149','val_150','2009-08-01'
-'15','val_15','2009-08-01'
-'15','val_15','2009-08-01'
-'15','val_16','2009-08-01'
-'15','val_16','2009-08-01'
-'150','val_150','2009-08-01'
-'151','val_152','2009-08-01'
-'151','val_152','2009-08-01'
-'152','val_152','2009-08-01'
-'152','val_152','2009-08-01'
-'152','val_153','2009-08-01'
-'152','val_153','2009-08-01'
-'152','val_153','2009-08-01'
-'153','val_153','2009-08-01'
-'153','val_154','2009-08-01'
-'153','val_154','2009-08-01'
-'155','val_155','2009-08-01'
-'156','val_156','2009-08-01'
-'156','val_157','2009-08-01'
-'156','val_157','2009-08-01'
-'157','val_157','2009-08-01'
-'157','val_158','2009-08-01'
-'157','val_158','2009-08-01'
-'158','val_158','2009-08-01'
-'16','val_17','2009-08-01'
-'16','val_17','2009-08-01'
-'160','val_160','2009-08-01'
-'160','val_161','2009-08-01'
-'161','val_162','2009-08-01'
-'161','val_162','2009-08-01'
-'161','val_162','2009-08-01'
-'161','val_162','2009-08-01'
-'162','val_162','2009-08-01'
-'162','val_163','2009-08-01'
-'163','val_163','2009-08-01'
-'164','val_164','2009-08-01'
-'164','val_164','2009-08-01'
-'164','val_165','2009-08-01'
-'164','val_165','2009-08-01'
-'165','val_165','2009-08-01'
-'165','val_165','2009-08-01'
-'165','val_166','2009-08-01'
-'166','val_166','2009-08-01'
-'167','val_167','2009-08-01'
-'167','val_167','2009-08-01'
-'167','val_167','2009-08-01'
-'167','val_168','2009-08-01'
-'168','val_168','2009-08-01'
-'168','val_169','2009-08-01'
-'169','val_169','2009-08-01'
-'169','val_169','2009-08-01'
-'169','val_169','2009-08-01'
-'169','val_169','2009-08-01'
-'17','val_17','2009-08-01'
-'170','val_170','2009-08-01'
-'170','val_171','2009-08-01'
-'172','val_172','2009-08-01'
-'172','val_172','2009-08-01'
-'172','val_173','2009-08-01'
-'174','val_174','2009-08-01'
-'174','val_174','2009-08-01'
-'174','val_175','2009-08-01'
-'174','val_175','2009-08-01'
-'175','val_175','2009-08-01'
-'175','val_175','2009-08-01'
-'175','val_176','2009-08-01'
-'175','val_176','2009-08-01'
-'176','val_176','2009-08-01'
-'176','val_176','2009-08-01'
-'177','val_177','2009-08-01'
-'177','val_178','2009-08-01'
-'177','val_178','2009-08-01'
-'178','val_178','2009-08-01'
-'178','val_179','2009-08-01'
-'178','val_179','2009-08-01'
-'179','val_179','2009-08-01'
-'179','val_179','2009-08-01'
-'179','val_180','2009-08-01'
-'18','val_18','2009-08-01'
-'18','val_18','2009-08-01'
-'180','val_180','2009-08-01'
-'181','val_181','2009-08-01'
-'182','val_183','2009-08-01'
-'183','val_183','2009-08-01'
-'183','val_184','2009-08-01'
-'184','val_185','2009-08-01'
-'185','val_186','2009-08-01'
-'186','val_186','2009-08-01'
-'187','val_187','2009-08-01'
-'187','val_187','2009-08-01'
-'187','val_187','2009-08-01'
-'189','val_189','2009-08-01'
-'189','val_190','2009-08-01'
-'19','val_19','2009-08-01'
-'19','val_20','2009-08-01'
-'190','val_190','2009-08-01'
-'191','val_191','2009-08-01'
-'191','val_191','2009-08-01'
-'191','val_192','2009-08-01'
-'192','val_192','2009-08-01'
-'192','val_193','2009-08-01'
-'193','val_193','2009-08-01'
-'193','val_193','2009-08-01'
-'193','val_193','2009-08-01'
-'194','val_194','2009-08-01'
-'195','val_195','2009-08-01'
-'195','val_195','2009-08-01'
-'196','val_196','2009-08-01'
-'196','val_197','2009-08-01'
-'196','val_197','2009-08-01'
-'196','val_197','2009-08-01'
-'197','val_197','2009-08-01'
-'197','val_197','2009-08-01'
-'197','val_198','2009-08-01'
-'199','val_199','2009-08-01'
-'199','val_199','2009-08-01'
-'199','val_199','2009-08-01'
-'199','val_200','2009-08-01'
-'2','val_2','2009-08-01'
-'2','val_3','2009-08-01'
-'20','val_20','2009-08-01'
-'20','val_21','2009-08-01'
-'20','val_21','2009-08-01'
-'200','val_200','2009-08-01'
-'200','val_200','2009-08-01'
-'201','val_201','2009-08-01'
-'202','val_202','2009-08-01'
-'203','val_203','2009-08-01'
-'203','val_203','2009-08-01'
-'204','val_205','2009-08-01'
-'205','val_205','2009-08-01'
-'205','val_205','2009-08-01'
-'205','val_206','2009-08-01'
-'206','val_207','2009-08-01'
-'206','val_207','2009-08-01'
-'206','val_207','2009-08-01'
-'207','val_207','2009-08-01'
-'207','val_207','2009-08-01'
-'208','val_208','2009-08-01'
-'208','val_208','2009-08-01'
-'208','val_208','2009-08-01'
-'209','val_209','2009-08-01'
-'209','val_209','2009-08-01'
-'209','val_210','2009-08-01'
-'209','val_210','2009-08-01'
-'21','val_22','2009-08-01'
-'21','val_22','2009-08-01'
-'21','val_22','2009-08-01'
-'21','val_22','2009-08-01'
-'212','val_213','2009-08-01'
-'213','val_213','2009-08-01'
-'213','val_213','2009-08-01'
-'213','val_214','2009-08-01'
-'214','val_214','2009-08-01'
-'215','val_216','2009-08-01'
-'216','val_216','2009-08-01'
-'216','val_216','2009-08-01'
-'216','val_217','2009-08-01'
-'217','val_217','2009-08-01'
-'217','val_217','2009-08-01'
-'217','val_218','2009-08-01'
-'217','val_218','2009-08-01'
-'218','val_218','2009-08-01'
-'219','val_219','2009-08-01'
-'219','val_219','2009-08-01'
-'22','val_23','2009-08-01'
-'221','val_221','2009-08-01'
-'221','val_221','2009-08-01'
-'222','val_222','2009-08-01'
-'222','val_223','2009-08-01'
-'223','val_223','2009-08-01'
-'223','val_223','2009-08-01'
-'224','val_224','2009-08-01'
-'224','val_224','2009-08-01'
-'224','val_225','2009-08-01'
-'226','val_226','2009-08-01'
-'226','val_227','2009-08-01'
-'226','val_227','2009-08-01'
-'226','val_227','2009-08-01'
-'226','val_227','2009-08-01'
-'227','val_228','2009-08-01'
-'228','val_228','2009-08-01'
-'228','val_229','2009-08-01'
-'229','val_229','2009-08-01'
-'229','val_229','2009-08-01'
-'23','val_24','2009-08-01'
-'230','val_230','2009-08-01'
-'230','val_230','2009-08-01'
-'230','val_230','2009-08-01'
-'230','val_230','2009-08-01'
-'230','val_230','2009-08-01'
-'231','val_232','2009-08-01'
-'233','val_233','2009-08-01'
-'233','val_233','2009-08-01'
-'235','val_235','2009-08-01'
-'235','val_236','2009-08-01'
-'237','val_237','2009-08-01'
-'237','val_237','2009-08-01'
-'238','val_238','2009-08-01'
-'238','val_238','2009-08-01'
-'238','val_239','2009-08-01'
-'239','val_239','2009-08-01'
-'239','val_239','2009-08-01'
-'239','val_240','2009-08-01'
-'239','val_240','2009-08-01'
-'24','val_24','2009-08-01'
-'24','val_24','2009-08-01'
-'240','val_241','2009-08-01'
-'241','val_241','2009-08-01'
-'241','val_242','2009-08-01'
-'241','val_242','2009-08-01'
-'241','val_242','2009-08-01'
-'241','val_242','2009-08-01'
-'242','val_242','2009-08-01'
-'242','val_242','2009-08-01'
-'242','val_243','2009-08-01'
-'243','val_244','2009-08-01'
-'243','val_244','2009-08-01'
-'244','val_244','2009-08-01'
-'244','val_245','2009-08-01'
-'244','val_245','2009-08-01'
-'244','val_245','2009-08-01'
-'245','val_246','2009-08-01'
-'245','val_246','2009-08-01'
-'246','val_247','2009-08-01'
-'246','val_247','2009-08-01'
-'247','val_247','2009-08-01'
-'248','val_248','2009-08-01'
-'248','val_249','2009-08-01'
-'249','val_249','2009-08-01'
-'249','val_250','2009-08-01'
-'249','val_250','2009-08-01'
-'252','val_252','2009-08-01'
-'252','val_253','2009-08-01'
-'254','val_255','2009-08-01'
-'255','val_255','2009-08-01'
-'255','val_255','2009-08-01'
-'256','val_256','2009-08-01'
-'256','val_256','2009-08-01'
-'256','val_257','2009-08-01'
-'257','val_257','2009-08-01'
-'257','val_258','2009-08-01'
-'257','val_258','2009-08-01'
-'258','val_258','2009-08-01'
-'258','val_259','2009-08-01'
-'259','val_260','2009-08-01'
-'259','val_260','2009-08-01'
-'26','val_26','2009-08-01'
-'26','val_26','2009-08-01'
-'260','val_260','2009-08-01'
-'260','val_261','2009-08-01'
-'260','val_261','2009-08-01'
-'261','val_262','2009-08-01'
-'262','val_262','2009-08-01'
-'262','val_263','2009-08-01'
-'262','val_263','2009-08-01'
-'263','val_263','2009-08-01'
-'264','val_265','2009-08-01'
-'264','val_265','2009-08-01'
-'265','val_265','2009-08-01'
-'265','val_265','2009-08-01'
-'265','val_266','2009-08-01'
-'266','val_266','2009-08-01'
-'267','val_268','2009-08-01'
-'268','val_269','2009-08-01'
-'27','val_27','2009-08-01'
-'271','val_272','2009-08-01'
-'272','val_272','2009-08-01'
-'272','val_272','2009-08-01'
-'272','val_273','2009-08-01'
-'273','val_273','2009-08-01'
-'273','val_273','2009-08-01'
-'273','val_273','2009-08-01'
-'273','val_274','2009-08-01'
-'274','val_274','2009-08-01'
-'274','val_275','2009-08-01'
-'275','val_275','2009-08-01'
-'275','val_276','2009-08-01'
-'275','val_276','2009-08-01'
-'276','val_277','2009-08-01'
-'277','val_277','2009-08-01'
-'277','val_277','2009-08-01'
-'277','val_277','2009-08-01'
-'277','val_277','2009-08-01'
-'277','val_278','2009-08-01'
-'277','val_278','2009-08-01'
-'278','val_278','2009-08-01'
-'278','val_278','2009-08-01'
-'278','val_279','2009-08-01'
-'28','val_28','2009-08-01'
-'280','val_280','2009-08-01'
-'280','val_280','2009-08-01'
-'281','val_281','2009-08-01'
-'281','val_281','2009-08-01'
-'281','val_282','2009-08-01'
-'281','val_282','2009-08-01'
-'281','val_282','2009-08-01'
-'282','val_282','2009-08-01'
-'282','val_282','2009-08-01'
-'283','val_283','2009-08-01'
-'284','val_284','2009-08-01'
-'284','val_285','2009-08-01'
-'284','val_285','2009-08-01'
-'285','val_285','2009-08-01'
-'285','val_286','2009-08-01'
-'286','val_286','2009-08-01'
-'286','val_287','2009-08-01'
-'287','val_287','2009-08-01'
-'287','val_288','2009-08-01'
-'287','val_288','2009-08-01'
-'288','val_288','2009-08-01'
-'288','val_288','2009-08-01'
-'289','val_289','2009-08-01'
-'289','val_290','2009-08-01'
-'29','val_30','2009-08-01'
-'29','val_30','2009-08-01'
-'291','val_291','2009-08-01'
-'291','val_292','2009-08-01'
-'291','val_292','2009-08-01'
-'292','val_292','2009-08-01'
-'292','val_293','2009-08-01'
-'292','val_293','2009-08-01'
-'293','val_294','2009-08-01'
-'293','val_294','2009-08-01'
-'295','val_296','2009-08-01'
-'295','val_296','2009-08-01'
-'296','val_296','2009-08-01'
-'296','val_297','2009-08-01'
-'298','val_298','2009-08-01'
-'298','val_298','2009-08-01'
-'298','val_298','2009-08-01'
-'3','val_4','2009-08-01'
-'30','val_30','2009-08-01'
-'30','val_31','2009-08-01'
-'300','val_301','2009-08-01'
-'300','val_301','2009-08-01'
-'302','val_302','2009-08-01'
-'302','val_303','2009-08-01'
-'303','val_304','2009-08-01'
-'303','val_304','2009-08-01'
-'304','val_305','2009-08-01'
-'305','val_305','2009-08-01'
-'305','val_306','2009-08-01'
-'306','val_306','2009-08-01'
-'306','val_307','2009-08-01'
-'307','val_307','2009-08-01'
-'307','val_307','2009-08-01'
-'308','val_308','2009-08-01'
-'308','val_309','2009-08-01'
-'308','val_309','2009-08-01'
-'309','val_309','2009-08-01'
-'309','val_309','2009-08-01'
-'309','val_310','2009-08-01'
-'31','val_32','2009-08-01'
-'310','val_310','2009-08-01'
-'310','val_311','2009-08-01'
-'310','val_311','2009-08-01'
-'310','val_311','2009-08-01'
-'311','val_311','2009-08-01'
-'311','val_311','2009-08-01'
-'311','val_311','2009-08-01'
-'313','val_314','2009-08-01'
-'314','val_315','2009-08-01'
-'315','val_315','2009-08-01'
-'316','val_316','2009-08-01'
-'316','val_316','2009-08-01'
-'316','val_316','2009-08-01'
-'317','val_317','2009-08-01'
-'317','val_317','2009-08-01'
-'317','val_318','2009-08-01'
-'318','val_318','2009-08-01'
-'318','val_318','2009-08-01'
-'318','val_318','2009-08-01'
-'318','val_319','2009-08-01'
-'32','val_33','2009-08-01'
-'321','val_321','2009-08-01'
-'321','val_321','2009-08-01'
-'322','val_322','2009-08-01'
-'322','val_322','2009-08-01'
-'322','val_323','2009-08-01'
-'323','val_323','2009-08-01'
-'323','val_324','2009-08-01'
-'324','val_325','2009-08-01'
-'325','val_325','2009-08-01'
-'325','val_325','2009-08-01'
-'326','val_327','2009-08-01'
-'327','val_327','2009-08-01'
-'327','val_327','2009-08-01'
-'327','val_327','2009-08-01'
-'328','val_329','2009-08-01'
-'328','val_329','2009-08-01'
-'33','val_33','2009-08-01'
-'33','val_34','2009-08-01'
-'330','val_331','2009-08-01'
-'331','val_331','2009-08-01'
-'331','val_331','2009-08-01'
-'331','val_332','2009-08-01'
-'331','val_332','2009-08-01'
-'332','val_332','2009-08-01'
-'333','val_333','2009-08-01'
-'333','val_333','2009-08-01'
-'333','val_334','2009-08-01'
-'334','val_335','2009-08-01'
-'335','val_335','2009-08-01'
-'335','val_336','2009-08-01'
-'335','val_336','2009-08-01'
-'336','val_336','2009-08-01'
-'336','val_337','2009-08-01'
-'337','val_338','2009-08-01'
-'338','val_338','2009-08-01'
-'338','val_339','2009-08-01'
-'339','val_339','2009-08-01'
-'34','val_34','2009-08-01'
-'340','val_341','2009-08-01'
-'341','val_341','2009-08-01'
-'341','val_342','2009-08-01'
-'341','val_342','2009-08-01'
-'341','val_342','2009-08-01'
-'342','val_342','2009-08-01'
-'342','val_342','2009-08-01'
-'342','val_343','2009-08-01'
-'343','val_344','2009-08-01'
-'344','val_344','2009-08-01'
-'344','val_344','2009-08-01'
-'344','val_345','2009-08-01'
-'345','val_345','2009-08-01'
-'347','val_348','2009-08-01'
-'347','val_348','2009-08-01'
-'348','val_348','2009-08-01'
-'348','val_348','2009-08-01'
-'348','val_348','2009-08-01'
-'348','val_348','2009-08-01'
-'348','val_348','2009-08-01'
-'348','val_349','2009-08-01'
-'349','val_350','2009-08-01'
-'349','val_350','2009-08-01'
-'349','val_350','2009-08-01'
-'349','val_350','2009-08-01'
-'35','val_35','2009-08-01'
-'35','val_35','2009-08-01'
-'35','val_35','2009-08-01'
-'35','val_36','2009-08-01'
-'35','val_36','2009-08-01'
-'35','val_36','2009-08-01'
-'351','val_351','2009-08-01'
-'351','val_352','2009-08-01'
-'351','val_352','2009-08-01'
-'352','val_353','2009-08-01'
-'352','val_353','2009-08-01'
-'353','val_353','2009-08-01'
-'353','val_353','2009-08-01'
-'353','val_354','2009-08-01'
-'355','val_356','2009-08-01'
-'355','val_356','2009-08-01'
-'356','val_356','2009-08-01'
-'356','val_357','2009-08-01'
-'356','val_357','2009-08-01'
-'358','val_359','2009-08-01'
-'360','val_360','2009-08-01'
-'360','val_361','2009-08-01'
-'362','val_362','2009-08-01'
-'363','val_364','2009-08-01'
-'363','val_364','2009-08-01'
-'363','val_364','2009-08-01'
-'364','val_364','2009-08-01'
-'364','val_365','2009-08-01'
-'365','val_365','2009-08-01'
-'366','val_366','2009-08-01'
-'367','val_367','2009-08-01'
-'367','val_367','2009-08-01'
-'367','val_368','2009-08-01'
-'367','val_368','2009-08-01'
-'368','val_368','2009-08-01'
-'369','val_369','2009-08-01'
-'369','val_369','2009-08-01'
-'369','val_369','2009-08-01'
-'369','val_370','2009-08-01'
-'37','val_37','2009-08-01'
-'37','val_37','2009-08-01'
-'371','val_372','2009-08-01'
-'371','val_372','2009-08-01'
-'371','val_372','2009-08-01'
-'371','val_372','2009-08-01'
-'373','val_373','2009-08-01'
-'373','val_374','2009-08-01'
-'374','val_374','2009-08-01'
-'374','val_375','2009-08-01'
-'375','val_375','2009-08-01'
-'375','val_376','2009-08-01'
-'375','val_376','2009-08-01'
-'375','val_376','2009-08-01'
-'375','val_376','2009-08-01'
-'375','val_376','2009-08-01'
-'376','val_377','2009-08-01'
-'377','val_377','2009-08-01'
-'378','val_378','2009-08-01'
-'378','val_379','2009-08-01'
-'379','val_379','2009-08-01'
-'379','val_380','2009-08-01'
-'381','val_382','2009-08-01'
-'382','val_382','2009-08-01'
-'382','val_382','2009-08-01'
-'382','val_383','2009-08-01'
-'382','val_383','2009-08-01'
-'384','val_384','2009-08-01'
-'384','val_384','2009-08-01'
-'384','val_384','2009-08-01'
-'384','val_385','2009-08-01'
-'384','val_385','2009-08-01'
-'384','val_385','2009-08-01'
-'385','val_386','2009-08-01'
-'385','val_386','2009-08-01'
-'386','val_386','2009-08-01'
-'386','val_387','2009-08-01'
-'386','val_387','2009-08-01'
-'388','val_389','2009-08-01'
-'389','val_389','2009-08-01'
-'389','val_390','2009-08-01'
-'389','val_390','2009-08-01'
-'390','val_391','2009-08-01'
-'390','val_391','2009-08-01'
-'390','val_391','2009-08-01'
-'391','val_392','2009-08-01'
-'391','val_392','2009-08-01'
-'392','val_392','2009-08-01'
-'392','val_393','2009-08-01'
-'392','val_393','2009-08-01'
-'393','val_393','2009-08-01'
-'393','val_394','2009-08-01'
-'393','val_394','2009-08-01'
-'394','val_394','2009-08-01'
-'395','val_395','2009-08-01'
-'395','val_395','2009-08-01'
-'395','val_396','2009-08-01'
-'395','val_396','2009-08-01'
-'396','val_396','2009-08-01'
-'396','val_396','2009-08-01'
-'396','val_396','2009-08-01'
-'397','val_397','2009-08-01'
-'397','val_397','2009-08-01'
-'398','val_399','2009-08-01'
-'399','val_399','2009-08-01'
-'399','val_399','2009-08-01'
-'399','val_400','2009-08-01'
-'399','val_400','2009-08-01'
-'4','val_4','2009-08-01'
-'4','val_5','2009-08-01'
-'40','val_41','2009-08-01'
-'40','val_41','2009-08-01'
-'400','val_400','2009-08-01'
-'401','val_401','2009-08-01'
-'401','val_401','2009-08-01'
-'401','val_401','2009-08-01'
-'401','val_401','2009-08-01'
-'401','val_401','2009-08-01'
-'401','val_402','2009-08-01'
-'402','val_402','2009-08-01'
-'402','val_403','2009-08-01'
-'402','val_403','2009-08-01'
-'402','val_403','2009-08-01'
-'403','val_403','2009-08-01'
-'403','val_403','2009-08-01'
-'403','val_403','2009-08-01'
-'404','val_404','2009-08-01'
-'404','val_404','2009-08-01'
-'404','val_405','2009-08-01'
-'404','val_405','2009-08-01'
-'404','val_405','2009-08-01'
-'405','val_406','2009-08-01'
-'406','val_406','2009-08-01'
-'406','val_406','2009-08-01'
-'406','val_406','2009-08-01'
-'406','val_406','2009-08-01'
-'406','val_407','2009-08-01'
-'407','val_407','2009-08-01'
-'407','val_408','2009-08-01'
-'407','val_408','2009-08-01'
-'407','val_408','2009-08-01'
-'408','val_409','2009-08-01'
-'408','val_409','2009-08-01'
-'409','val_409','2009-08-01'
-'409','val_409','2009-08-01'
-'409','val_409','2009-08-01'
-'409','val_410','2009-08-01'
-'409','val_410','2009-08-01'
-'41','val_41','2009-08-01'
-'410','val_411','2009-08-01'
-'411','val_411','2009-08-01'
-'411','val_412','2009-08-01'
-'412','val_413','2009-08-01'
-'412','val_413','2009-08-01'
-'413','val_413','2009-08-01'
-'413','val_413','2009-08-01'
-'413','val_414','2009-08-01'
-'414','val_414','2009-08-01'
-'414','val_414','2009-08-01'
-'414','val_415','2009-08-01'
-'415','val_416','2009-08-01'
-'416','val_417','2009-08-01'
-'417','val_417','2009-08-01'
-'417','val_417','2009-08-01'
-'417','val_417','2009-08-01'
-'418','val_418','2009-08-01'
-'419','val_419','2009-08-01'
-'42','val_42','2009-08-01'
-'42','val_42','2009-08-01'
-'42','val_43','2009-08-01'
-'42','val_43','2009-08-01'
-'42','val_43','2009-08-01'
-'421','val_421','2009-08-01'
-'421','val_422','2009-08-01'
-'421','val_422','2009-08-01'
-'423','val_424','2009-08-01'
-'424','val_424','2009-08-01'
-'424','val_424','2009-08-01'
-'424','val_425','2009-08-01'
-'425','val_426','2009-08-01'
-'426','val_427','2009-08-01'
-'427','val_427','2009-08-01'
-'427','val_428','2009-08-01'
-'427','val_428','2009-08-01'
-'428','val_429','2009-08-01'
-'429','val_429','2009-08-01'
-'429','val_429','2009-08-01'
-'429','val_430','2009-08-01'
-'429','val_430','2009-08-01'
-'43','val_43','2009-08-01'
-'430','val_430','2009-08-01'
-'430','val_430','2009-08-01'
-'430','val_430','2009-08-01'
-'430','val_431','2009-08-01'
-'431','val_431','2009-08-01'
-'431','val_431','2009-08-01'
-'431','val_431','2009-08-01'
-'431','val_432','2009-08-01'
-'432','val_432','2009-08-01'
-'432','val_433','2009-08-01'
-'435','val_435','2009-08-01'
-'435','val_436','2009-08-01'
-'436','val_436','2009-08-01'
-'436','val_437','2009-08-01'
-'437','val_437','2009-08-01'
-'437','val_438','2009-08-01'
-'438','val_438','2009-08-01'
-'438','val_438','2009-08-01'
-'438','val_438','2009-08-01'
-'438','val_439','2009-08-01'
-'438','val_439','2009-08-01'
-'439','val_439','2009-08-01'
-'439','val_439','2009-08-01'
-'439','val_440','2009-08-01'
-'439','val_440','2009-08-01'
-'44','val_44','2009-08-01'
-'440','val_441','2009-08-01'
-'440','val_441','2009-08-01'
-'441','val_442','2009-08-01'
-'442','val_443','2009-08-01'
-'443','val_443','2009-08-01'
-'443','val_444','2009-08-01'
-'443','val_444','2009-08-01'
-'443','val_444','2009-08-01'
-'444','val_444','2009-08-01'
-'446','val_446','2009-08-01'
-'446','val_447','2009-08-01'
-'446','val_447','2009-08-01'
-'447','val_448','2009-08-01'
-'448','val_448','2009-08-01'
-'448','val_449','2009-08-01'
-'449','val_449','2009-08-01'
-'450','val_451','2009-08-01'
-'450','val_451','2009-08-01'
-'451','val_452','2009-08-01'
-'452','val_452','2009-08-01'
-'453','val_453','2009-08-01'
-'453','val_454','2009-08-01'
-'454','val_454','2009-08-01'
-'454','val_454','2009-08-01'
-'454','val_454','2009-08-01'
-'454','val_455','2009-08-01'
-'454','val_455','2009-08-01'
-'455','val_455','2009-08-01'
-'455','val_456','2009-08-01'
-'455','val_456','2009-08-01'
-'457','val_457','2009-08-01'
-'457','val_458','2009-08-01'
-'457','val_458','2009-08-01'
-'458','val_458','2009-08-01'
-'458','val_458','2009-08-01'
-'459','val_459','2009-08-01'
-'459','val_459','2009-08-01'
-'459','val_460','2009-08-01'
-'46','val_47','2009-08-01'
-'460','val_460','2009-08-01'
-'461','val_462','2009-08-01'
-'462','val_462','2009-08-01'
-'462','val_462','2009-08-01'
-'462','val_463','2009-08-01'
-'463','val_463','2009-08-01'
-'463','val_463','2009-08-01'
-'463','val_464','2009-08-01'
-'466','val_466','2009-08-01'
-'466','val_466','2009-08-01'
-'466','val_466','2009-08-01'
-'467','val_467','2009-08-01'
-'467','val_468','2009-08-01'
-'468','val_468','2009-08-01'
-'468','val_468','2009-08-01'
-'468','val_468','2009-08-01'
-'468','val_468','2009-08-01'
-'468','val_469','2009-08-01'
-'468','val_469','2009-08-01'
-'468','val_469','2009-08-01'
-'469','val_469','2009-08-01'
-'469','val_469','2009-08-01'
-'469','val_469','2009-08-01'
-'469','val_469','2009-08-01'
-'469','val_469','2009-08-01'
-'469','val_470','2009-08-01'
-'47','val_47','2009-08-01'
-'47','val_48','2009-08-01'
-'470','val_470','2009-08-01'
-'470','val_471','2009-08-01'
-'472','val_472','2009-08-01'
-'473','val_474','2009-08-01'
-'474','val_475','2009-08-01'
-'474','val_475','2009-08-01'
-'475','val_475','2009-08-01'
-'475','val_476','2009-08-01'
-'476','val_477','2009-08-01'
-'476','val_477','2009-08-01'
-'477','val_477','2009-08-01'
-'477','val_478','2009-08-01'
-'478','val_478','2009-08-01'
-'478','val_478','2009-08-01'
-'478','val_479','2009-08-01'
-'478','val_479','2009-08-01'
-'479','val_479','2009-08-01'
-'48','val_49','2009-08-01'
-'48','val_49','2009-08-01'
-'480','val_480','2009-08-01'
-'480','val_480','2009-08-01'
-'480','val_480','2009-08-01'
-'480','val_481','2009-08-01'
-'480','val_481','2009-08-01'
-'481','val_481','2009-08-01'
-'481','val_482','2009-08-01'
-'482','val_482','2009-08-01'
-'482','val_483','2009-08-01'
-'483','val_483','2009-08-01'
-'484','val_484','2009-08-01'
-'484','val_485','2009-08-01'
-'485','val_485','2009-08-01'
-'485','val_486','2009-08-01'
-'485','val_486','2009-08-01'
-'486','val_487','2009-08-01'
-'487','val_487','2009-08-01'
-'487','val_488','2009-08-01'
-'488','val_489','2009-08-01'
-'489','val_489','2009-08-01'
-'489','val_489','2009-08-01'
-'489','val_489','2009-08-01'
-'489','val_489','2009-08-01'
-'489','val_490','2009-08-01'
-'49','val_50','2009-08-01'
-'49','val_50','2009-08-01'
-'490','val_490','2009-08-01'
-'490','val_491','2009-08-01'
-'491','val_491','2009-08-01'
-'491','val_492','2009-08-01'
-'491','val_492','2009-08-01'
-'492','val_492','2009-08-01'
-'492','val_492','2009-08-01'
-'492','val_493','2009-08-01'
-'492','val_493','2009-08-01'
-'493','val_493','2009-08-01'
-'494','val_494','2009-08-01'
-'494','val_495','2009-08-01'
-'494','val_495','2009-08-01'
-'495','val_495','2009-08-01'
-'495','val_496','2009-08-01'
-'496','val_496','2009-08-01'
-'496','val_497','2009-08-01'
-'497','val_497','2009-08-01'
-'497','val_498','2009-08-01'
-'497','val_498','2009-08-01'
-'498','val_498','2009-08-01'
-'498','val_498','2009-08-01'
-'498','val_498','2009-08-01'
-'5','val_5','2009-08-01'
-'5','val_5','2009-08-01'
-'5','val_5','2009-08-01'
-'5','val_6','2009-08-01'
-'50','val_51','2009-08-01'
-'51','val_51','2009-08-01'
-'51','val_51','2009-08-01'
-'51','val_52','2009-08-01'
-'52','val_53','2009-08-01'
-'52','val_53','2009-08-01'
-'52','val_53','2009-08-01'
-'52','val_53','2009-08-01'
-'53','val_53','2009-08-01'
-'53','val_54','2009-08-01'
-'54','val_54','2009-08-01'
-'56','val_57','2009-08-01'
-'57','val_57','2009-08-01'
-'58','val_58','2009-08-01'
-'58','val_58','2009-08-01'
-'58','val_59','2009-08-01'
-'58','val_59','2009-08-01'
-'59','val_60','2009-08-01'
-'6','val_7','2009-08-01'
-'6','val_7','2009-08-01'
-'60','val_61','2009-08-01'
-'61','val_62','2009-08-01'
-'62','val_63','2009-08-01'
-'62','val_63','2009-08-01'
-'63','val_64','2009-08-01'
-'64','val_64','2009-08-01'
-'65','val_65','2009-08-01'
-'65','val_66','2009-08-01'
-'65','val_66','2009-08-01'
-'66','val_66','2009-08-01'
-'67','val_67','2009-08-01'
-'67','val_67','2009-08-01'
-'68','val_69','2009-08-01'
-'69','val_69','2009-08-01'
-'69','val_70','2009-08-01'
-'70','val_70','2009-08-01'
-'70','val_70','2009-08-01'
-'70','val_70','2009-08-01'
-'70','val_71','2009-08-01'
-'71','val_72','2009-08-01'
-'72','val_72','2009-08-01'
-'72','val_72','2009-08-01'
-'74','val_74','2009-08-01'
-'75','val_76','2009-08-01'
-'76','val_76','2009-08-01'
-'76','val_76','2009-08-01'
-'76','val_77','2009-08-01'
-'76','val_77','2009-08-01'
-'76','val_77','2009-08-01'
-'77','val_77','2009-08-01'
-'77','val_78','2009-08-01'
-'77','val_78','2009-08-01'
-'78','val_78','2009-08-01'
-'78','val_79','2009-08-01'
-'8','val_8','2009-08-01'
-'8','val_9','2009-08-01'
-'80','val_80','2009-08-01'
-'80','val_81','2009-08-01'
-'82','val_82','2009-08-01'
-'82','val_83','2009-08-01'
-'82','val_83','2009-08-01'
-'83','val_83','2009-08-01'
-'83','val_83','2009-08-01'
-'84','val_84','2009-08-01'
-'84','val_84','2009-08-01'
-'85','val_85','2009-08-01'
-'85','val_86','2009-08-01'
-'86','val_86','2009-08-01'
-'86','val_87','2009-08-01'
-'87','val_87','2009-08-01'
-'87','val_88','2009-08-01'
-'87','val_88','2009-08-01'
-'89','val_90','2009-08-01'
-'89','val_90','2009-08-01'
-'89','val_90','2009-08-01'
-'9','val_9','2009-08-01'
-'90','val_90','2009-08-01'
-'90','val_90','2009-08-01'
-'90','val_90','2009-08-01'
-'91','val_92','2009-08-01'
-'92','val_92','2009-08-01'
-'93','val_94','2009-08-01'
-'93','val_94','2009-08-01'
-'93','val_94','2009-08-01'
-'94','val_95','2009-08-01'
-'95','val_95','2009-08-01'
-'95','val_95','2009-08-01'
-'96','val_96','2009-08-01'
-'97','val_97','2009-08-01'
-'97','val_97','2009-08-01'
-'97','val_98','2009-08-01'
-'97','val_98','2009-08-01'
-'98','val_98','2009-08-01'
-'98','val_98','2009-08-01'
-'99','val_100','2009-08-01'
-1,000 rows selected
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input41.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input41.q.out b/ql/src/test/results/beelinepositive/input41.q.out
deleted file mode 100644
index 915688b..0000000
--- a/ql/src/test/results/beelinepositive/input41.q.out
+++ /dev/null
@@ -1,25 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input41.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input41.q
->>> set hive.mapred.mode=strict;
-No rows affected
->>>
->>> create table dest_sp (cnt int);
-No rows affected
->>>
->>> insert overwrite table dest_sp
-select * from
-(select count(1) as cnt from src
-union all
-select count(1) as cnt from srcpart where ds = '2009-08-09'
-)x;
-'_col0'
-No rows selected
->>>
->>> select * from dest_sp x order by x.cnt limit 2;
-'cnt'
-'0'
-'500'
-2 rows selected
->>>
->>>
->>> !record