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