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