hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject [09/51] [partial] hive git commit: HIVE-15790: Remove unused beeline golden files (Gunther Hagleitner, reviewed by Sergey Shelukhin)
Date Fri, 03 Feb 2017 21:50:22 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/infer_const_type.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/infer_const_type.q.out b/ql/src/test/results/beelinepositive/infer_const_type.q.out
deleted file mode 100644
index dcbd86d..0000000
--- a/ql/src/test/results/beelinepositive/infer_const_type.q.out
+++ /dev/null
@@ -1,284 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/infer_const_type.q.raw". Enter "record" with no arguments to stop it.
->>>  !run !!{qFileDirectory}!!/infer_const_type.q
->>>  DROP TABLE infertypes;
-No rows affected 
->>>  CREATE TABLE infertypes(ti TINYINT, si SMALLINT, i INT, bi BIGINT, fl FLOAT, db DOUBLE, str STRING);
-No rows affected 
->>>  
->>>  LOAD DATA LOCAL INPATH '../data/files/infer_const_type.txt' OVERWRITE INTO TABLE infertypes;
-No rows affected 
->>>  
->>>  SELECT * FROM infertypes;
-'ti','si','i','bi','fl','db','str'
-'127','32767','12345','-12345','906.0','-307.0','1234'
-'126','32767','12345','-12345','906.0','-307.0','1234'
-'126','32767','12345','-12345','906.0','-307.0','1.57'
-3 rows selected 
->>>  
->>>  EXPLAIN SELECT * FROM infertypes WHERE 
-ti  = '127' AND 
-si  = 32767 AND 
-i   = '12345' AND 
-bi  = '-12345' AND 
-fl  = '0906' AND 
-db  = '-307' AND 
-str = 1234;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME infertypes))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (AND (AND (AND (AND (AND (AND (= (TOK_TABLE_OR_COL ti) '127') (= (TOK_TABLE_OR_COL si) 32767)) (= (TOK_TABLE_OR_COL i) '12345')) (= (TOK_TABLE_OR_COL bi) '-12345')) (= (TOK_TABLE_OR_COL fl) '0906')) (= (TOK_TABLE_OR_COL db) '-307')) (= (TOK_TABLE_OR_COL str) 1234)))))'
-''
-'STAGE DEPENDENCIES:'
-'  Stage-1 is a root stage'
-'  Stage-0 is a root stage'
-''
-'STAGE PLANS:'
-'  Stage: Stage-1'
-'    Map Reduce'
-'      Alias -> Map Operator Tree:'
-'        infertypes '
-'          TableScan'
-'            alias: infertypes'
-'            Filter Operator'
-'              predicate:'
-'                  expr: (((((((ti = 127) and (si = 32767)) and (i = 12345)) and (bi = -12345)) and (fl = 906.0)) and (db = -307.0)) and (str = 1234.0))'
-'                  type: boolean'
-'              Select Operator'
-'                expressions:'
-'                      expr: ti'
-'                      type: tinyint'
-'                      expr: si'
-'                      type: smallint'
-'                      expr: i'
-'                      type: int'
-'                      expr: bi'
-'                      type: bigint'
-'                      expr: fl'
-'                      type: float'
-'                      expr: db'
-'                      type: double'
-'                      expr: str'
-'                      type: string'
-'                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6'
-'                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'
-''
-''
-47 rows selected 
->>>  
->>>  SELECT * FROM infertypes WHERE 
-ti  = '127' AND 
-si  = 32767 AND 
-i   = '12345' AND 
-bi  = '-12345' AND 
-fl  = '0906' AND 
-db  = '-307' AND 
-str = 1234;
-'ti','si','i','bi','fl','db','str'
-'127','32767','12345','-12345','906.0','-307.0','1234'
-1 row selected 
->>>  
->>>  -- all should return false as all numbers exceeed the largest number
->>>  -- which could be represented by the corresponding type
->>>  -- and string_col = long_const should return false
->>>  EXPLAIN SELECT * FROM infertypes WHERE 
-ti  = '128' OR 
-si  = 32768 OR 
-i   = '2147483648' OR 
-bi  = '9223372036854775808' OR 
-fl  = 'float' OR 
-db  = 'double';
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME infertypes))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (OR (OR (OR (OR (OR (= (TOK_TABLE_OR_COL ti) '128') (= (TOK_TABLE_OR_COL si) 32768)) (= (TOK_TABLE_OR_COL i) '2147483648')) (= (TOK_TABLE_OR_COL bi) '9223372036854775808')) (= (TOK_TABLE_OR_COL fl) 'float')) (= (TOK_TABLE_OR_COL db) 'double')))))'
-''
-'STAGE DEPENDENCIES:'
-'  Stage-1 is a root stage'
-'  Stage-0 is a root stage'
-''
-'STAGE PLANS:'
-'  Stage: Stage-1'
-'    Map Reduce'
-'      Alias -> Map Operator Tree:'
-'        infertypes '
-'          TableScan'
-'            alias: infertypes'
-'            Filter Operator'
-'              predicate:'
-'                  expr: (((((false or false) or false) or false) or false) or false)'
-'                  type: boolean'
-'              Select Operator'
-'                expressions:'
-'                      expr: ti'
-'                      type: tinyint'
-'                      expr: si'
-'                      type: smallint'
-'                      expr: i'
-'                      type: int'
-'                      expr: bi'
-'                      type: bigint'
-'                      expr: fl'
-'                      type: float'
-'                      expr: db'
-'                      type: double'
-'                      expr: str'
-'                      type: string'
-'                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6'
-'                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'
-''
-''
-47 rows selected 
->>>  
->>>  SELECT * FROM infertypes WHERE 
-ti  = '128' OR 
-si  = 32768 OR 
-i   = '2147483648' OR 
-bi  = '9223372036854775808' OR 
-fl  = 'float' OR 
-db  = 'double';
-'ti','si','i','bi','fl','db','str'
-No rows selected 
->>>  
->>>  -- for the query like: int_col = double, should return false
->>>  EXPLAIN SELECT * FROM infertypes WHERE 
-ti  = '127.0' OR 
-si  = 327.0 OR 
-i   = '-100.0';
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME infertypes))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (OR (OR (= (TOK_TABLE_OR_COL ti) '127.0') (= (TOK_TABLE_OR_COL si) 327.0)) (= (TOK_TABLE_OR_COL i) '-100.0')))))'
-''
-'STAGE DEPENDENCIES:'
-'  Stage-1 is a root stage'
-'  Stage-0 is a root stage'
-''
-'STAGE PLANS:'
-'  Stage: Stage-1'
-'    Map Reduce'
-'      Alias -> Map Operator Tree:'
-'        infertypes '
-'          TableScan'
-'            alias: infertypes'
-'            Filter Operator'
-'              predicate:'
-'                  expr: ((false or false) or false)'
-'                  type: boolean'
-'              Select Operator'
-'                expressions:'
-'                      expr: ti'
-'                      type: tinyint'
-'                      expr: si'
-'                      type: smallint'
-'                      expr: i'
-'                      type: int'
-'                      expr: bi'
-'                      type: bigint'
-'                      expr: fl'
-'                      type: float'
-'                      expr: db'
-'                      type: double'
-'                      expr: str'
-'                      type: string'
-'                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6'
-'                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'
-''
-''
-47 rows selected 
->>>  
->>>  SELECT * FROM infertypes WHERE 
-ti  = '127.0' OR 
-si  = 327.0 OR 
-i   = '-100.0';
-'ti','si','i','bi','fl','db','str'
-No rows selected 
->>>  
->>>  EXPLAIN SELECT * FROM infertypes WHERE 
-ti < '127.0' AND 
-i > '100.0' AND 
-str = 1.57;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME infertypes))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (AND (AND (< (TOK_TABLE_OR_COL ti) '127.0') (> (TOK_TABLE_OR_COL i) '100.0')) (= (TOK_TABLE_OR_COL str) 1.57)))))'
-''
-'STAGE DEPENDENCIES:'
-'  Stage-1 is a root stage'
-'  Stage-0 is a root stage'
-''
-'STAGE PLANS:'
-'  Stage: Stage-1'
-'    Map Reduce'
-'      Alias -> Map Operator Tree:'
-'        infertypes '
-'          TableScan'
-'            alias: infertypes'
-'            Filter Operator'
-'              predicate:'
-'                  expr: (((ti < 127.0) and (i > 100.0)) and (str = 1.57))'
-'                  type: boolean'
-'              Select Operator'
-'                expressions:'
-'                      expr: ti'
-'                      type: tinyint'
-'                      expr: si'
-'                      type: smallint'
-'                      expr: i'
-'                      type: int'
-'                      expr: bi'
-'                      type: bigint'
-'                      expr: fl'
-'                      type: float'
-'                      expr: db'
-'                      type: double'
-'                      expr: str'
-'                      type: string'
-'                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6'
-'                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'
-''
-''
-47 rows selected 
->>>  
->>>  SELECT * FROM infertypes WHERE 
-ti < '127.0' AND 
-i > '100.0' AND 
-str = 1.57;
-'ti','si','i','bi','fl','db','str'
-'126','32767','12345','-12345','906.0','-307.0','1.57'
-1 row selected 
->>>  
->>>  DROP TABLE infertypes;
-No rows affected 
->>>  !record

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

http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/inoutdriver.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/inoutdriver.q.out b/ql/src/test/results/beelinepositive/inoutdriver.q.out
deleted file mode 100644
index be1e832..0000000
--- a/ql/src/test/results/beelinepositive/inoutdriver.q.out
+++ /dev/null
@@ -1,11 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/inoutdriver.q.raw". Enter "record" with no arguments to stop it.
->>>  !run !!{qFileDirectory}!!/inoutdriver.q
->>>  create table test (a int) stored as inputformat 'org.apache.hadoop.hive.ql.io.RCFileInputFormat' outputformat 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat' inputdriver 'RCFileInDriver' outputdriver 'RCFileOutDriver';
-No rows affected 
->>>  desc extended test;
-'col_name','data_type','comment'
-'a','int',''
-'','',''
-'Detailed Table Information','Table(tableName:test, dbName:inoutdriver, owner:!!{user.name}!!, createTime:!!UNIXTIME!!, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null)], location:!!{hive.metastore.warehouse.dir}!!/inoutdriver.db/test, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{})), partitionKeys:[], parameters:{transient_lastDdlTime=!!UNIXTIME!!}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)',''
-3 rows selected 
->>>  !record

http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input.q.out b/ql/src/test/results/beelinepositive/input.q.out
deleted file mode 100644
index d8961b1..0000000
--- a/ql/src/test/results/beelinepositive/input.q.out
+++ /dev/null
@@ -1,534 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input.q.raw". Enter "record" with no arguments to stop it.
->>>  !run !!{qFileDirectory}!!/input.q
->>>  EXPLAIN 
-SELECT x.* FROM SRC x;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME SRC) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME x))))))'
-''
-'STAGE DEPENDENCIES:'
-'  Stage-0 is a root stage'
-''
-'STAGE PLANS:'
-'  Stage: Stage-0'
-'    Fetch Operator'
-'      limit: -1'
-'      Processor Tree:'
-'        TableScan'
-'          alias: x'
-'          Select Operator'
-'            expressions:'
-'                  expr: key'
-'                  type: string'
-'                  expr: value'
-'                  type: string'
-'            outputColumnNames: _col0, _col1'
-'            ListSink'
-''
-''
-23 rows selected 
->>>  
->>>  SELECT x.* FROM SRC x;
-'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/input0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input0.q.out b/ql/src/test/results/beelinepositive/input0.q.out
deleted file mode 100644
index ea2ce2a..0000000
--- a/ql/src/test/results/beelinepositive/input0.q.out
+++ /dev/null
@@ -1,535 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input0.q.raw". Enter "record" with no arguments to stop it.
->>>  !run !!{qFileDirectory}!!/input0.q
->>>  EXPLAIN 
-SELECT * FROM src;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))'
-''
-'STAGE DEPENDENCIES:'
-'  Stage-0 is a root stage'
-''
-'STAGE PLANS:'
-'  Stage: Stage-0'
-'    Fetch Operator'
-'      limit: -1'
-'      Processor Tree:'
-'        TableScan'
-'          alias: src'
-'          Select Operator'
-'            expressions:'
-'                  expr: key'
-'                  type: string'
-'                  expr: value'
-'                  type: string'
-'            outputColumnNames: _col0, _col1'
-'            ListSink'
-''
-''
-23 rows selected 
->>>  
->>>  SELECT * FROM src;
-'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/input1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input1.q.out b/ql/src/test/results/beelinepositive/input1.q.out
deleted file mode 100644
index e85d87a..0000000
--- a/ql/src/test/results/beelinepositive/input1.q.out
+++ /dev/null
@@ -1,37 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input1.q.raw". Enter "record" with no arguments to stop it.
->>>  !run !!{qFileDirectory}!!/input1.q
->>>  CREATE TABLE TEST1(A INT, B DOUBLE) STORED AS TEXTFILE;
-No rows affected 
->>>  
->>>  EXPLAIN 
-DESCRIBE TEST1;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_DESCTABLE (TOK_TABTYPE TEST1))'
-''
-'STAGE DEPENDENCIES:'
-'  Stage-0 is a root stage'
-'  Stage-1 is a root stage'
-''
-'STAGE PLANS:'
-'  Stage: Stage-0'
-'      Describe Table Operator:'
-'        Describe Table'
-'          table: TEST1'
-''
-'  Stage: Stage-1'
-'    Fetch Operator'
-'      limit: -1'
-''
-''
-18 rows selected 
->>>  
->>>  DESCRIBE TEST1;
-'col_name','data_type','comment'
-'a','int',''
-'b','double',''
-2 rows selected 
->>>  
->>>  
->>>  
->>>  !record

http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input10.q.out b/ql/src/test/results/beelinepositive/input10.q.out
deleted file mode 100644
index 07e2071..0000000
--- a/ql/src/test/results/beelinepositive/input10.q.out
+++ /dev/null
@@ -1,39 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input10.q.raw". Enter "record" with no arguments to stop it.
->>>  !run !!{qFileDirectory}!!/input10.q
->>>  CREATE TABLE TEST10(key INT, value STRING) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE;
-No rows affected 
->>>  
->>>  EXPLAIN 
-DESCRIBE TEST10;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_DESCTABLE (TOK_TABTYPE TEST10))'
-''
-'STAGE DEPENDENCIES:'
-'  Stage-0 is a root stage'
-'  Stage-1 is a root stage'
-''
-'STAGE PLANS:'
-'  Stage: Stage-0'
-'      Describe Table Operator:'
-'        Describe Table'
-'          table: TEST10'
-''
-'  Stage: Stage-1'
-'    Fetch Operator'
-'      limit: -1'
-''
-''
-18 rows selected 
->>>  
->>>  DESCRIBE TEST10;
-'col_name','data_type','comment'
-'key','int',''
-'value','string',''
-'ds','string',''
-'hr','string',''
-4 rows selected 
->>>  
->>>  
->>>  
->>>  !record

http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input11.q.out b/ql/src/test/results/beelinepositive/input11.q.out
deleted file mode 100644
index ac1dee8..0000000
--- a/ql/src/test/results/beelinepositive/input11.q.out
+++ /dev/null
@@ -1,206 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input11.q.raw". Enter "record" with no arguments to stop it.
->>>  !run !!{qFileDirectory}!!/input11.q
->>>  CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
-No rows affected 
->>>  
->>>  EXPLAIN 
-FROM src 
-INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100))))'
-''
-'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:'
-'        src '
-'          TableScan'
-'            alias: src'
-'            Filter Operator'
-'              predicate:'
-'                  expr: (key < 100.0)'
-'                  type: boolean'
-'              Select Operator'
-'                expressions:'
-'                      expr: key'
-'                      type: string'
-'                      expr: value'
-'                      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: input11.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: input11.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: input11.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: input11.dest1'
-''
-'  Stage: Stage-6'
-'    Move Operator'
-'      files:'
-'          hdfs directory: true'
-'          destination: pfile:!!{hive.exec.scratchdir}!!'
-''
-''
-102 rows selected 
->>>  
->>>  FROM src 
-INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100;
-'_col0','_col1'
-No rows selected 
->>>  
->>>  SELECT dest1.* FROM dest1;
-'key','value'
-'86','val_86'
-'27','val_27'
-'98','val_98'
-'66','val_66'
-'37','val_37'
-'15','val_15'
-'82','val_82'
-'17','val_17'
-'0','val_0'
-'57','val_57'
-'20','val_20'
-'92','val_92'
-'47','val_47'
-'72','val_72'
-'4','val_4'
-'35','val_35'
-'54','val_54'
-'51','val_51'
-'65','val_65'
-'83','val_83'
-'12','val_12'
-'67','val_67'
-'84','val_84'
-'58','val_58'
-'8','val_8'
-'24','val_24'
-'42','val_42'
-'0','val_0'
-'96','val_96'
-'26','val_26'
-'51','val_51'
-'43','val_43'
-'95','val_95'
-'98','val_98'
-'85','val_85'
-'77','val_77'
-'0','val_0'
-'87','val_87'
-'15','val_15'
-'72','val_72'
-'90','val_90'
-'19','val_19'
-'10','val_10'
-'5','val_5'
-'58','val_58'
-'35','val_35'
-'95','val_95'
-'11','val_11'
-'34','val_34'
-'42','val_42'
-'78','val_78'
-'76','val_76'
-'41','val_41'
-'30','val_30'
-'64','val_64'
-'76','val_76'
-'74','val_74'
-'69','val_69'
-'33','val_33'
-'70','val_70'
-'5','val_5'
-'2','val_2'
-'35','val_35'
-'80','val_80'
-'44','val_44'
-'53','val_53'
-'90','val_90'
-'12','val_12'
-'5','val_5'
-'70','val_70'
-'24','val_24'
-'70','val_70'
-'83','val_83'
-'26','val_26'
-'67','val_67'
-'18','val_18'
-'9','val_9'
-'18','val_18'
-'97','val_97'
-'84','val_84'
-'28','val_28'
-'37','val_37'
-'90','val_90'
-'97','val_97'
-84 rows selected 
->>>  !record

http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input11_limit.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input11_limit.q.out b/ql/src/test/results/beelinepositive/input11_limit.q.out
deleted file mode 100644
index 84b3556..0000000
--- a/ql/src/test/results/beelinepositive/input11_limit.q.out
+++ /dev/null
@@ -1,98 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input11_limit.q.raw". Enter "record" with no arguments to stop it.
->>>  !run !!{qFileDirectory}!!/input11_limit.q
->>>  CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
-No rows affected 
->>>  
->>>  EXPLAIN 
-FROM src 
-INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100 LIMIT 10;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100)) (TOK_LIMIT 10)))'
-''
-'STAGE DEPENDENCIES:'
-'  Stage-1 is a root stage'
-'  Stage-0 depends on stages: Stage-1'
-'  Stage-2 depends on stages: Stage-0'
-''
-'STAGE PLANS:'
-'  Stage: Stage-1'
-'    Map Reduce'
-'      Alias -> Map Operator Tree:'
-'        src '
-'          TableScan'
-'            alias: src'
-'            Filter Operator'
-'              predicate:'
-'                  expr: (key < 100.0)'
-'                  type: boolean'
-'              Select Operator'
-'                expressions:'
-'                      expr: key'
-'                      type: string'
-'                      expr: value'
-'                      type: string'
-'                outputColumnNames: _col0, _col1'
-'                Limit'
-'                  Reduce Output Operator'
-'                    sort order: '
-'                    tag: -1'
-'                    value expressions:'
-'                          expr: _col0'
-'                          type: string'
-'                          expr: _col1'
-'                          type: string'
-'      Reduce Operator Tree:'
-'        Extract'
-'          Limit'
-'            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: input11_limit.dest1'
-''
-'  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: input11_limit.dest1'
-''
-'  Stage: Stage-2'
-'    Stats-Aggr Operator'
-''
-''
-68 rows selected 
->>>  
->>>  FROM src 
-INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100 LIMIT 10;
-'_col0','_col1'
-No rows selected 
->>>  
->>>  SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC, dest1.value ASC;
-'key','value'
-'0','val_0'
-'15','val_15'
-'17','val_17'
-'27','val_27'
-'37','val_37'
-'57','val_57'
-'66','val_66'
-'82','val_82'
-'86','val_86'
-'98','val_98'
-10 rows selected 
->>>  !record


Mime
View raw message