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:19 UTC
[06/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/input35.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input35.q.out b/ql/src/test/results/beelinepositive/input35.q.out
deleted file mode 100644
index 7d74e1b..0000000
--- a/ql/src/test/results/beelinepositive/input35.q.out
+++ /dev/null
@@ -1,640 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input35.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input35.q
->>> CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
-No rows affected
->>>
->>> EXPLAIN
-FROM (
-FROM src
-SELECT TRANSFORM(src.key, src.value) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
-USING 'cat'
-AS (tkey, tvalue) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
-) tmap
-INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-' (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value)) (TOK_SERDE (TOK_SERDEPROPS (TOK_TABLEROWFORMATFIELD '\002'))) TOK_RECORDWRITER 'cat' (TOK_SERDE (TOK_SERDEPROPS (TOK_TABLEROWFORMATFIELD '\002'))) TOK_RECORDREADER (TOK_ALIASLIST tkey tvalue)))))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL tkey)) (TOK_SELEXPR (TOK_TABLE_OR_COL tvalue)))))'
-''
-'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:'
-' tmap:src '
-' TableScan'
-' alias: src'
-' Select Operator'
-' expressions:'
-' expr: key'
-' type: string'
-' expr: value'
-' type: string'
-' outputColumnNames: _col0, _col1'
-' Transform Operator'
-' command: cat'
-' output info:'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' Select Operator'
-' expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' type: string'
-' outputColumnNames: _col0, _col1'
-' Select Operator'
-' expressions:'
-' expr: UDFToInteger(_col0)'
-' type: int'
-' expr: _col1'
-' 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: input35.dest1'
-''
-' 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:'
-' 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: input35.dest1'
-''
-' 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: input35.dest1'
-''
-' 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: input35.dest1'
-''
-' Stage: Stage-6'
-' Move Operator'
-' files:'
-' hdfs directory: true'
-' destination: pfile:!!{hive.exec.scratchdir}!!'
-''
-''
-110 rows selected
->>>
->>> FROM (
-FROM src
-SELECT TRANSFORM(src.key, src.value) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
-USING 'cat'
-AS (tkey, tvalue) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
-) tmap
-INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue;
-'_col0','_col1'
-No rows selected
->>>
->>> SELECT dest1.* FROM dest1;
-'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
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input36.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input36.q.out b/ql/src/test/results/beelinepositive/input36.q.out
deleted file mode 100644
index f48eb1a..0000000
--- a/ql/src/test/results/beelinepositive/input36.q.out
+++ /dev/null
@@ -1,640 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input36.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input36.q
->>> CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
-No rows affected
->>>
->>> EXPLAIN
-FROM (
-FROM src
-SELECT TRANSFORM(src.key, src.value) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
-USING 'cat'
-AS (tkey, tvalue) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\003'
-) tmap
-INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-' (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value)) (TOK_SERDE (TOK_SERDEPROPS (TOK_TABLEROWFORMATFIELD '\002'))) TOK_RECORDWRITER 'cat' (TOK_SERDE (TOK_SERDEPROPS (TOK_TABLEROWFORMATFIELD '\003'))) TOK_RECORDREADER (TOK_ALIASLIST tkey tvalue)))))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL tkey)) (TOK_SELEXPR (TOK_TABLE_OR_COL tvalue)))))'
-''
-'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:'
-' tmap:src '
-' TableScan'
-' alias: src'
-' Select Operator'
-' expressions:'
-' expr: key'
-' type: string'
-' expr: value'
-' type: string'
-' outputColumnNames: _col0, _col1'
-' Transform Operator'
-' command: cat'
-' output info:'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' Select Operator'
-' expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' type: string'
-' outputColumnNames: _col0, _col1'
-' Select Operator'
-' expressions:'
-' expr: UDFToInteger(_col0)'
-' type: int'
-' expr: _col1'
-' 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: input36.dest1'
-''
-' 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:'
-' 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: input36.dest1'
-''
-' 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: input36.dest1'
-''
-' 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: input36.dest1'
-''
-' Stage: Stage-6'
-' Move Operator'
-' files:'
-' hdfs directory: true'
-' destination: pfile:!!{hive.exec.scratchdir}!!'
-''
-''
-110 rows selected
->>>
->>> FROM (
-FROM src
-SELECT TRANSFORM(src.key, src.value) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002'
-USING 'cat'
-AS (tkey, tvalue) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\003'
-) tmap
-INSERT OVERWRITE TABLE dest1 SELECT tkey, tvalue;
-'_col0','_col1'
-No rows selected
->>>
->>> SELECT dest1.* FROM dest1;
-'key','value'
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-'',''
-500 rows selected
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input37.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input37.q.out b/ql/src/test/results/beelinepositive/input37.q.out
deleted file mode 100644
index 676b72d..0000000
--- a/ql/src/test/results/beelinepositive/input37.q.out
+++ /dev/null
@@ -1,25 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input37.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input37.q
->>> create table documents(contents string) stored as textfile;
-No rows affected
->>>
->>> LOAD DATA LOCAL INPATH '../data/files/docurl.txt' INTO TABLE documents;
-No rows affected
->>>
->>>
->>> select url, count(1)
-FROM
-(
-FROM documents
-MAP documents.contents
-USING 'java -cp ../util/target/classes/ org.apache.hadoop.hive.scripts.extracturl' AS (url, count)
-) subq
-group by url;
-'url','_c1'
-'1uauniajqtunlsvadmxhlxvngxpqjuzbpzvdiwmzphmbaicduzkgxgtdeiunduosu.html','4'
-'4uzsbtwvdypfitqfqdjosynqp.html','4'
-2 rows selected
->>>
->>>
->>>
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input38.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input38.q.out b/ql/src/test/results/beelinepositive/input38.q.out
deleted file mode 100644
index 52cfe72..0000000
--- a/ql/src/test/results/beelinepositive/input38.q.out
+++ /dev/null
@@ -1,639 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input38.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input38.q
->>>
->>> CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE;
-No rows affected
->>>
->>> EXPLAIN
-FROM (
-FROM src
-SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
-USING 'cat'
-) tmap
-INSERT OVERWRITE TABLE dest1 SELECT tmap.key, tmap.value;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-' (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value) (+ 1 2) (+ 3 4)) TOK_SERDE TOK_RECORDWRITER 'cat' TOK_SERDE TOK_RECORDREADER))))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) value)))))'
-''
-'STAGE DEPENDENCIES:'
-' Stage-1 is a root stage'
-' Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5'
-' Stage-4'
-' Stage-0 depends on stages: Stage-4, Stage-3, Stage-6'
-' Stage-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:'
-' tmap:src '
-' TableScan'
-' alias: src'
-' Select Operator'
-' expressions:'
-' expr: key'
-' type: string'
-' expr: value'
-' type: string'
-' expr: (1 + 2)'
-' type: int'
-' expr: (3 + 4)'
-' type: int'
-' outputColumnNames: _col0, _col1, _col2, _col3'
-' Transform Operator'
-' command: cat'
-' output info:'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' Select Operator'
-' expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' 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: input38.dest1'
-''
-' 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:'
-' 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: input38.dest1'
-''
-' 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: input38.dest1'
-''
-' 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: input38.dest1'
-''
-' Stage: Stage-6'
-' Move Operator'
-' files:'
-' hdfs directory: true'
-' destination: pfile:!!{hive.exec.scratchdir}!!'
-''
-''
-107 rows selected
->>>
->>> FROM (
-FROM src
-SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
-USING 'cat'
-) tmap
-INSERT OVERWRITE TABLE dest1 SELECT tmap.key, tmap.value;
-'key','value'
-No rows selected
->>>
->>>
->>> SELECT dest1.* FROM dest1;
-'key','value'
-'238','val_238 3 7'
-'86','val_86 3 7'
-'311','val_311 3 7'
-'27','val_27 3 7'
-'165','val_165 3 7'
-'409','val_409 3 7'
-'255','val_255 3 7'
-'278','val_278 3 7'
-'98','val_98 3 7'
-'484','val_484 3 7'
-'265','val_265 3 7'
-'193','val_193 3 7'
-'401','val_401 3 7'
-'150','val_150 3 7'
-'273','val_273 3 7'
-'224','val_224 3 7'
-'369','val_369 3 7'
-'66','val_66 3 7'
-'128','val_128 3 7'
-'213','val_213 3 7'
-'146','val_146 3 7'
-'406','val_406 3 7'
-'429','val_429 3 7'
-'374','val_374 3 7'
-'152','val_152 3 7'
-'469','val_469 3 7'
-'145','val_145 3 7'
-'495','val_495 3 7'
-'37','val_37 3 7'
-'327','val_327 3 7'
-'281','val_281 3 7'
-'277','val_277 3 7'
-'209','val_209 3 7'
-'15','val_15 3 7'
-'82','val_82 3 7'
-'403','val_403 3 7'
-'166','val_166 3 7'
-'417','val_417 3 7'
-'430','val_430 3 7'
-'252','val_252 3 7'
-'292','val_292 3 7'
-'219','val_219 3 7'
-'287','val_287 3 7'
-'153','val_153 3 7'
-'193','val_193 3 7'
-'338','val_338 3 7'
-'446','val_446 3 7'
-'459','val_459 3 7'
-'394','val_394 3 7'
-'237','val_237 3 7'
-'482','val_482 3 7'
-'174','val_174 3 7'
-'413','val_413 3 7'
-'494','val_494 3 7'
-'207','val_207 3 7'
-'199','val_199 3 7'
-'466','val_466 3 7'
-'208','val_208 3 7'
-'174','val_174 3 7'
-'399','val_399 3 7'
-'396','val_396 3 7'
-'247','val_247 3 7'
-'417','val_417 3 7'
-'489','val_489 3 7'
-'162','val_162 3 7'
-'377','val_377 3 7'
-'397','val_397 3 7'
-'309','val_309 3 7'
-'365','val_365 3 7'
-'266','val_266 3 7'
-'439','val_439 3 7'
-'342','val_342 3 7'
-'367','val_367 3 7'
-'325','val_325 3 7'
-'167','val_167 3 7'
-'195','val_195 3 7'
-'475','val_475 3 7'
-'17','val_17 3 7'
-'113','val_113 3 7'
-'155','val_155 3 7'
-'203','val_203 3 7'
-'339','val_339 3 7'
-'0','val_0 3 7'
-'455','val_455 3 7'
-'128','val_128 3 7'
-'311','val_311 3 7'
-'316','val_316 3 7'
-'57','val_57 3 7'
-'302','val_302 3 7'
-'205','val_205 3 7'
-'149','val_149 3 7'
-'438','val_438 3 7'
-'345','val_345 3 7'
-'129','val_129 3 7'
-'170','val_170 3 7'
-'20','val_20 3 7'
-'489','val_489 3 7'
-'157','val_157 3 7'
-'378','val_378 3 7'
-'221','val_221 3 7'
-'92','val_92 3 7'
-'111','val_111 3 7'
-'47','val_47 3 7'
-'72','val_72 3 7'
-'4','val_4 3 7'
-'280','val_280 3 7'
-'35','val_35 3 7'
-'427','val_427 3 7'
-'277','val_277 3 7'
-'208','val_208 3 7'
-'356','val_356 3 7'
-'399','val_399 3 7'
-'169','val_169 3 7'
-'382','val_382 3 7'
-'498','val_498 3 7'
-'125','val_125 3 7'
-'386','val_386 3 7'
-'437','val_437 3 7'
-'469','val_469 3 7'
-'192','val_192 3 7'
-'286','val_286 3 7'
-'187','val_187 3 7'
-'176','val_176 3 7'
-'54','val_54 3 7'
-'459','val_459 3 7'
-'51','val_51 3 7'
-'138','val_138 3 7'
-'103','val_103 3 7'
-'239','val_239 3 7'
-'213','val_213 3 7'
-'216','val_216 3 7'
-'430','val_430 3 7'
-'278','val_278 3 7'
-'176','val_176 3 7'
-'289','val_289 3 7'
-'221','val_221 3 7'
-'65','val_65 3 7'
-'318','val_318 3 7'
-'332','val_332 3 7'
-'311','val_311 3 7'
-'275','val_275 3 7'
-'137','val_137 3 7'
-'241','val_241 3 7'
-'83','val_83 3 7'
-'333','val_333 3 7'
-'180','val_180 3 7'
-'284','val_284 3 7'
-'12','val_12 3 7'
-'230','val_230 3 7'
-'181','val_181 3 7'
-'67','val_67 3 7'
-'260','val_260 3 7'
-'404','val_404 3 7'
-'384','val_384 3 7'
-'489','val_489 3 7'
-'353','val_353 3 7'
-'373','val_373 3 7'
-'272','val_272 3 7'
-'138','val_138 3 7'
-'217','val_217 3 7'
-'84','val_84 3 7'
-'348','val_348 3 7'
-'466','val_466 3 7'
-'58','val_58 3 7'
-'8','val_8 3 7'
-'411','val_411 3 7'
-'230','val_230 3 7'
-'208','val_208 3 7'
-'348','val_348 3 7'
-'24','val_24 3 7'
-'463','val_463 3 7'
-'431','val_431 3 7'
-'179','val_179 3 7'
-'172','val_172 3 7'
-'42','val_42 3 7'
-'129','val_129 3 7'
-'158','val_158 3 7'
-'119','val_119 3 7'
-'496','val_496 3 7'
-'0','val_0 3 7'
-'322','val_322 3 7'
-'197','val_197 3 7'
-'468','val_468 3 7'
-'393','val_393 3 7'
-'454','val_454 3 7'
-'100','val_100 3 7'
-'298','val_298 3 7'
-'199','val_199 3 7'
-'191','val_191 3 7'
-'418','val_418 3 7'
-'96','val_96 3 7'
-'26','val_26 3 7'
-'165','val_165 3 7'
-'327','val_327 3 7'
-'230','val_230 3 7'
-'205','val_205 3 7'
-'120','val_120 3 7'
-'131','val_131 3 7'
-'51','val_51 3 7'
-'404','val_404 3 7'
-'43','val_43 3 7'
-'436','val_436 3 7'
-'156','val_156 3 7'
-'469','val_469 3 7'
-'468','val_468 3 7'
-'308','val_308 3 7'
-'95','val_95 3 7'
-'196','val_196 3 7'
-'288','val_288 3 7'
-'481','val_481 3 7'
-'457','val_457 3 7'
-'98','val_98 3 7'
-'282','val_282 3 7'
-'197','val_197 3 7'
-'187','val_187 3 7'
-'318','val_318 3 7'
-'318','val_318 3 7'
-'409','val_409 3 7'
-'470','val_470 3 7'
-'137','val_137 3 7'
-'369','val_369 3 7'
-'316','val_316 3 7'
-'169','val_169 3 7'
-'413','val_413 3 7'
-'85','val_85 3 7'
-'77','val_77 3 7'
-'0','val_0 3 7'
-'490','val_490 3 7'
-'87','val_87 3 7'
-'364','val_364 3 7'
-'179','val_179 3 7'
-'118','val_118 3 7'
-'134','val_134 3 7'
-'395','val_395 3 7'
-'282','val_282 3 7'
-'138','val_138 3 7'
-'238','val_238 3 7'
-'419','val_419 3 7'
-'15','val_15 3 7'
-'118','val_118 3 7'
-'72','val_72 3 7'
-'90','val_90 3 7'
-'307','val_307 3 7'
-'19','val_19 3 7'
-'435','val_435 3 7'
-'10','val_10 3 7'
-'277','val_277 3 7'
-'273','val_273 3 7'
-'306','val_306 3 7'
-'224','val_224 3 7'
-'309','val_309 3 7'
-'389','val_389 3 7'
-'327','val_327 3 7'
-'242','val_242 3 7'
-'369','val_369 3 7'
-'392','val_392 3 7'
-'272','val_272 3 7'
-'331','val_331 3 7'
-'401','val_401 3 7'
-'242','val_242 3 7'
-'452','val_452 3 7'
-'177','val_177 3 7'
-'226','val_226 3 7'
-'5','val_5 3 7'
-'497','val_497 3 7'
-'402','val_402 3 7'
-'396','val_396 3 7'
-'317','val_317 3 7'
-'395','val_395 3 7'
-'58','val_58 3 7'
-'35','val_35 3 7'
-'336','val_336 3 7'
-'95','val_95 3 7'
-'11','val_11 3 7'
-'168','val_168 3 7'
-'34','val_34 3 7'
-'229','val_229 3 7'
-'233','val_233 3 7'
-'143','val_143 3 7'
-'472','val_472 3 7'
-'322','val_322 3 7'
-'498','val_498 3 7'
-'160','val_160 3 7'
-'195','val_195 3 7'
-'42','val_42 3 7'
-'321','val_321 3 7'
-'430','val_430 3 7'
-'119','val_119 3 7'
-'489','val_489 3 7'
-'458','val_458 3 7'
-'78','val_78 3 7'
-'76','val_76 3 7'
-'41','val_41 3 7'
-'223','val_223 3 7'
-'492','val_492 3 7'
-'149','val_149 3 7'
-'449','val_449 3 7'
-'218','val_218 3 7'
-'228','val_228 3 7'
-'138','val_138 3 7'
-'453','val_453 3 7'
-'30','val_30 3 7'
-'209','val_209 3 7'
-'64','val_64 3 7'
-'468','val_468 3 7'
-'76','val_76 3 7'
-'74','val_74 3 7'
-'342','val_342 3 7'
-'69','val_69 3 7'
-'230','val_230 3 7'
-'33','val_33 3 7'
-'368','val_368 3 7'
-'103','val_103 3 7'
-'296','val_296 3 7'
-'113','val_113 3 7'
-'216','val_216 3 7'
-'367','val_367 3 7'
-'344','val_344 3 7'
-'167','val_167 3 7'
-'274','val_274 3 7'
-'219','val_219 3 7'
-'239','val_239 3 7'
-'485','val_485 3 7'
-'116','val_116 3 7'
-'223','val_223 3 7'
-'256','val_256 3 7'
-'263','val_263 3 7'
-'70','val_70 3 7'
-'487','val_487 3 7'
-'480','val_480 3 7'
-'401','val_401 3 7'
-'288','val_288 3 7'
-'191','val_191 3 7'
-'5','val_5 3 7'
-'244','val_244 3 7'
-'438','val_438 3 7'
-'128','val_128 3 7'
-'467','val_467 3 7'
-'432','val_432 3 7'
-'202','val_202 3 7'
-'316','val_316 3 7'
-'229','val_229 3 7'
-'469','val_469 3 7'
-'463','val_463 3 7'
-'280','val_280 3 7'
-'2','val_2 3 7'
-'35','val_35 3 7'
-'283','val_283 3 7'
-'331','val_331 3 7'
-'235','val_235 3 7'
-'80','val_80 3 7'
-'44','val_44 3 7'
-'193','val_193 3 7'
-'321','val_321 3 7'
-'335','val_335 3 7'
-'104','val_104 3 7'
-'466','val_466 3 7'
-'366','val_366 3 7'
-'175','val_175 3 7'
-'403','val_403 3 7'
-'483','val_483 3 7'
-'53','val_53 3 7'
-'105','val_105 3 7'
-'257','val_257 3 7'
-'406','val_406 3 7'
-'409','val_409 3 7'
-'190','val_190 3 7'
-'406','val_406 3 7'
-'401','val_401 3 7'
-'114','val_114 3 7'
-'258','val_258 3 7'
-'90','val_90 3 7'
-'203','val_203 3 7'
-'262','val_262 3 7'
-'348','val_348 3 7'
-'424','val_424 3 7'
-'12','val_12 3 7'
-'396','val_396 3 7'
-'201','val_201 3 7'
-'217','val_217 3 7'
-'164','val_164 3 7'
-'431','val_431 3 7'
-'454','val_454 3 7'
-'478','val_478 3 7'
-'298','val_298 3 7'
-'125','val_125 3 7'
-'431','val_431 3 7'
-'164','val_164 3 7'
-'424','val_424 3 7'
-'187','val_187 3 7'
-'382','val_382 3 7'
-'5','val_5 3 7'
-'70','val_70 3 7'
-'397','val_397 3 7'
-'480','val_480 3 7'
-'291','val_291 3 7'
-'24','val_24 3 7'
-'351','val_351 3 7'
-'255','val_255 3 7'
-'104','val_104 3 7'
-'70','val_70 3 7'
-'163','val_163 3 7'
-'438','val_438 3 7'
-'119','val_119 3 7'
-'414','val_414 3 7'
-'200','val_200 3 7'
-'491','val_491 3 7'
-'237','val_237 3 7'
-'439','val_439 3 7'
-'360','val_360 3 7'
-'248','val_248 3 7'
-'479','val_479 3 7'
-'305','val_305 3 7'
-'417','val_417 3 7'
-'199','val_199 3 7'
-'444','val_444 3 7'
-'120','val_120 3 7'
-'429','val_429 3 7'
-'169','val_169 3 7'
-'443','val_443 3 7'
-'323','val_323 3 7'
-'325','val_325 3 7'
-'277','val_277 3 7'
-'230','val_230 3 7'
-'478','val_478 3 7'
-'178','val_178 3 7'
-'468','val_468 3 7'
-'310','val_310 3 7'
-'317','val_317 3 7'
-'333','val_333 3 7'
-'493','val_493 3 7'
-'460','val_460 3 7'
-'207','val_207 3 7'
-'249','val_249 3 7'
-'265','val_265 3 7'
-'480','val_480 3 7'
-'83','val_83 3 7'
-'136','val_136 3 7'
-'353','val_353 3 7'
-'172','val_172 3 7'
-'214','val_214 3 7'
-'462','val_462 3 7'
-'233','val_233 3 7'
-'406','val_406 3 7'
-'133','val_133 3 7'
-'175','val_175 3 7'
-'189','val_189 3 7'
-'454','val_454 3 7'
-'375','val_375 3 7'
-'401','val_401 3 7'
-'421','val_421 3 7'
-'407','val_407 3 7'
-'384','val_384 3 7'
-'256','val_256 3 7'
-'26','val_26 3 7'
-'134','val_134 3 7'
-'67','val_67 3 7'
-'384','val_384 3 7'
-'379','val_379 3 7'
-'18','val_18 3 7'
-'462','val_462 3 7'
-'492','val_492 3 7'
-'100','val_100 3 7'
-'298','val_298 3 7'
-'9','val_9 3 7'
-'341','val_341 3 7'
-'498','val_498 3 7'
-'146','val_146 3 7'
-'458','val_458 3 7'
-'362','val_362 3 7'
-'186','val_186 3 7'
-'285','val_285 3 7'
-'348','val_348 3 7'
-'167','val_167 3 7'
-'18','val_18 3 7'
-'273','val_273 3 7'
-'183','val_183 3 7'
-'281','val_281 3 7'
-'344','val_344 3 7'
-'97','val_97 3 7'
-'469','val_469 3 7'
-'315','val_315 3 7'
-'84','val_84 3 7'
-'28','val_28 3 7'
-'37','val_37 3 7'
-'448','val_448 3 7'
-'152','val_152 3 7'
-'348','val_348 3 7'
-'307','val_307 3 7'
-'194','val_194 3 7'
-'414','val_414 3 7'
-'477','val_477 3 7'
-'222','val_222 3 7'
-'126','val_126 3 7'
-'90','val_90 3 7'
-'169','val_169 3 7'
-'403','val_403 3 7'
-'400','val_400 3 7'
-'200','val_200 3 7'
-'97','val_97 3 7'
-500 rows selected
->>>
->>>
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input39.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input39.q.out b/ql/src/test/results/beelinepositive/input39.q.out
deleted file mode 100644
index 7ba00a8..0000000
--- a/ql/src/test/results/beelinepositive/input39.q.out
+++ /dev/null
@@ -1,161 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input39.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input39.q
->>>
->>>
->>>
->>> create table t1(key string, value string) partitioned by (ds string);
-No rows affected
->>> create table t2(key string, value string) partitioned by (ds string);
-No rows affected
->>>
->>> insert overwrite table t1 partition (ds='1')
-select key, value from src;
-'key','value'
-No rows selected
->>>
->>> insert overwrite table t1 partition (ds='2')
-select key, value from src;
-'key','value'
-No rows selected
->>>
->>> insert overwrite table t2 partition (ds='1')
-select key, value from src;
-'key','value'
-No rows selected
->>>
->>> set hive.test.mode=true;
-No rows affected
->>> set hive.mapred.mode=strict;
-No rows affected
->>> set mapred.job.tracker=does.notexist.com:666;
-No rows affected
->>> set hive.exec.mode.local.auto=true;
-No rows affected
->>>
->>> explain
-select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1';
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-' (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME t1)) (TOK_TABREF (TOK_TABNAME t2)) (= (. (TOK_TABLE_OR_COL t1) key) (. (TOK_TABLE_OR_COL t2) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL t1) ds) '1') (= (. (TOK_TABLE_OR_COL t2) ds) '1')))))'
-''
-'STAGE DEPENDENCIES:'
-' Stage-1 is a root stage'
-' Stage-2 depends on stages: Stage-1'
-' Stage-0 is a root stage'
-''
-'STAGE PLANS:'
-' Stage: Stage-1'
-' Map Reduce'
-' Alias -> Map Operator Tree:'
-' t1 '
-' TableScan'
-' alias: t1'
-' Filter Operator'
-' predicate:'
-' expr: (((hash(rand(460476415)) & 2147483647) % 32) = 0)'
-' type: boolean'
-' Reduce Output Operator'
-' key expressions:'
-' expr: key'
-' type: string'
-' sort order: +'
-' Map-reduce partition columns:'
-' expr: key'
-' type: string'
-' tag: 0'
-' value expressions:'
-' expr: ds'
-' type: string'
-' t2 '
-' TableScan'
-' alias: t2'
-' Filter Operator'
-' predicate:'
-' expr: (((hash(rand(460476415)) & 2147483647) % 32) = 0)'
-' type: boolean'
-' Reduce Output Operator'
-' key expressions:'
-' expr: key'
-' type: string'
-' sort order: +'
-' Map-reduce partition columns:'
-' expr: key'
-' type: string'
-' tag: 1'
-' value expressions:'
-' expr: ds'
-' type: string'
-' Reduce Operator Tree:'
-' Join Operator'
-' condition map:'
-' Inner Join 0 to 1'
-' condition expressions:'
-' 0 {VALUE._col2}'
-' 1 {VALUE._col2}'
-' handleSkewJoin: false'
-' outputColumnNames: _col2, _col7'
-' Select Operator'
-' Group By Operator'
-' aggregations:'
-' expr: count(1)'
-' bucketGroup: false'
-' mode: hash'
-' outputColumnNames: _col0'
-' 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}!! '
-' Reduce Output Operator'
-' sort order: '
-' tag: -1'
-' value expressions:'
-' expr: _col0'
-' type: bigint'
-' Reduce Operator Tree:'
-' Group By Operator'
-' aggregations:'
-' expr: count(VALUE._col0)'
-' bucketGroup: false'
-' mode: mergepartial'
-' outputColumnNames: _col0'
-' Select Operator'
-' expressions:'
-' expr: _col0'
-' type: bigint'
-' outputColumnNames: _col0'
-' File Output Operator'
-' compressed: false'
-' GlobalTableId: 0'
-' table:'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-''
-' Stage: Stage-0'
-' Fetch Operator'
-' limit: -1'
-''
-''
-107 rows selected
->>>
->>> select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1';
-'_c0'
-'18'
-1 row selected
->>>
->>> set hive.test.mode=false;
-No rows affected
->>> set mapred.job.tracker;
-'set'
-'mapred.job.tracker=does.notexist.com:666'
-1 row selected
->>>
->>>
->>>
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input3_limit.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input3_limit.q.out b/ql/src/test/results/beelinepositive/input3_limit.q.out
deleted file mode 100644
index 13c1992..0000000
--- a/ql/src/test/results/beelinepositive/input3_limit.q.out
+++ /dev/null
@@ -1,144 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input3_limit.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input3_limit.q
->>>
->>> CREATE TABLE T1(key STRING, value STRING) STORED AS TEXTFILE;
-No rows affected
->>> LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE T1;
-No rows affected
->>> LOAD DATA LOCAL INPATH '../data/files/kv2.txt' INTO TABLE T1;
-No rows affected
->>>
->>>
->>> CREATE TABLE T2(key STRING, value STRING);
-No rows affected
->>>
->>> EXPLAIN
-INSERT OVERWRITE TABLE T2 SELECT * FROM (SELECT * FROM T1 DISTRIBUTE BY key SORT BY key, value) T LIMIT 20;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-' (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME T1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL key)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value))))) T)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME T2))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 20)))'
-''
-'STAGE DEPENDENCIES:'
-' Stage-1 is a root stage'
-' Stage-2 depends on stages: Stage-1'
-' Stage-0 depends on stages: Stage-2'
-' Stage-3 depends on stages: Stage-0'
-''
-'STAGE PLANS:'
-' Stage: Stage-1'
-' Map Reduce'
-' Alias -> Map Operator Tree:'
-' t:t1 '
-' TableScan'
-' alias: t1'
-' Select Operator'
-' expressions:'
-' expr: key'
-' type: string'
-' expr: value'
-' type: string'
-' outputColumnNames: _col0, _col1'
-' Reduce Output Operator'
-' key expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' type: string'
-' sort order: ++'
-' Map-reduce partition columns:'
-' expr: _col0'
-' type: string'
-' tag: -1'
-' value expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' type: string'
-' Reduce Operator Tree:'
-' Extract'
-' Select Operator'
-' expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' type: string'
-' outputColumnNames: _col0, _col1'
-' 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}!! '
-' Reduce Output Operator'
-' sort order: '
-' tag: -1'
-' value expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' type: string'
-' Reduce Operator Tree:'
-' Extract'
-' Limit'
-' 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: input3_limit.t2'
-''
-' Stage: Stage-0'
-' Move Operator'
-' tables:'
-' 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: input3_limit.t2'
-''
-' Stage: Stage-3'
-' Stats-Aggr Operator'
-''
-''
-94 rows selected
->>>
->>> INSERT OVERWRITE TABLE T2 SELECT * FROM (SELECT * FROM T1 DISTRIBUTE BY key SORT BY key, value) T LIMIT 20;
-'key','value'
-No rows selected
->>>
->>> SELECT * FROM T2 SORT BY key, value;
-'key','value'
-'0','val_0'
-'0','val_0'
-'0','val_0'
-'0','val_1'
-'0','val_1'
-'1','val_2'
-'10','val_10'
-'10','val_11'
-'100','val_100'
-'100','val_100'
-'100','val_101'
-'100','val_101'
-'101','val_102'
-'102','val_103'
-'103','val_103'
-'103','val_103'
-'104','val_104'
-'104','val_104'
-'104','val_105'
-'104','val_105'
-20 rows selected
->>>
->>>
->>>
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input4.q.out b/ql/src/test/results/beelinepositive/input4.q.out
deleted file mode 100644
index dcbfd96..0000000
--- a/ql/src/test/results/beelinepositive/input4.q.out
+++ /dev/null
@@ -1,548 +0,0 @@
-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