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:17 UTC
[04/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/input42.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input42.q.out b/ql/src/test/results/beelinepositive/input42.q.out
deleted file mode 100644
index 380cd6c..0000000
--- a/ql/src/test/results/beelinepositive/input42.q.out
+++ /dev/null
@@ -1,2036 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input42.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input42.q
->>> explain extended
-select * from srcpart a where a.ds='2008-04-08' order by a.key, a.hr;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08')) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) hr)))))'
-''
-'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:'
-' a '
-' TableScan'
-' alias: a'
-' GatherStats: false'
-' Select Operator'
-' expressions:'
-' expr: key'
-' type: string'
-' expr: value'
-' type: string'
-' expr: ds'
-' type: string'
-' expr: hr'
-' type: string'
-' outputColumnNames: _col0, _col1, _col2, _col3'
-' Reduce Output Operator'
-' key expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col3'
-' type: string'
-' sort order: ++'
-' tag: -1'
-' value expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' type: string'
-' expr: _col2'
-' type: string'
-' expr: _col3'
-' type: string'
-' Needs Tagging: false'
-' Path -> Alias:'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=11 [a]'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=12 [a]'
-' Path -> Partition:'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=11 '
-' Partition'
-' base file name: hr=11'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' partition values:'
-' ds 2008-04-08'
-' hr 11'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=11'
-' name input42.srcpart'
-' numFiles 1'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 5812'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' '
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart'
-' name input42.srcpart'
-' numFiles 4'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 23248'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' name: input42.srcpart'
-' name: input42.srcpart'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=12 '
-' Partition'
-' base file name: hr=12'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' partition values:'
-' ds 2008-04-08'
-' hr 12'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=12'
-' name input42.srcpart'
-' numFiles 1'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 5812'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' '
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart'
-' name input42.srcpart'
-' numFiles 4'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 23248'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' name: input42.srcpart'
-' name: input42.srcpart'
-' Reduce Operator Tree:'
-' Extract'
-' File Output Operator'
-' compressed: false'
-' GlobalTableId: 0'
-' directory: file:!!{hive.exec.scratchdir}!!'
-' NumFilesPerFileSink: 1'
-' Stats Publishing Key Prefix: file:!!{hive.exec.scratchdir}!!'
-' table:'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' properties:'
-' columns _col0,_col1,_col2,_col3'
-' columns.types string:string:string:string'
-' escape.delim \'
-' serialization.format 1'
-' TotalFiles: 1'
-' GatherStats: false'
-' MultiFileSpray: false'
-''
-' Stage: Stage-0'
-' Fetch Operator'
-' limit: -1'
-''
-''
-175 rows selected
->>>
->>> select * from srcpart a where a.ds='2008-04-08' order by a.key, a.hr;
-'key','value','ds','hr'
-'0','val_0','2008-04-08','11'
-'0','val_0','2008-04-08','11'
-'0','val_0','2008-04-08','11'
-'0','val_0','2008-04-08','12'
-'0','val_0','2008-04-08','12'
-'0','val_0','2008-04-08','12'
-'10','val_10','2008-04-08','11'
-'10','val_10','2008-04-08','12'
-'100','val_100','2008-04-08','11'
-'100','val_100','2008-04-08','11'
-'100','val_100','2008-04-08','12'
-'100','val_100','2008-04-08','12'
-'103','val_103','2008-04-08','11'
-'103','val_103','2008-04-08','11'
-'103','val_103','2008-04-08','12'
-'103','val_103','2008-04-08','12'
-'104','val_104','2008-04-08','11'
-'104','val_104','2008-04-08','11'
-'104','val_104','2008-04-08','12'
-'104','val_104','2008-04-08','12'
-'105','val_105','2008-04-08','11'
-'105','val_105','2008-04-08','12'
-'11','val_11','2008-04-08','11'
-'11','val_11','2008-04-08','12'
-'111','val_111','2008-04-08','11'
-'111','val_111','2008-04-08','12'
-'113','val_113','2008-04-08','11'
-'113','val_113','2008-04-08','11'
-'113','val_113','2008-04-08','12'
-'113','val_113','2008-04-08','12'
-'114','val_114','2008-04-08','11'
-'114','val_114','2008-04-08','12'
-'116','val_116','2008-04-08','11'
-'116','val_116','2008-04-08','12'
-'118','val_118','2008-04-08','11'
-'118','val_118','2008-04-08','11'
-'118','val_118','2008-04-08','12'
-'118','val_118','2008-04-08','12'
-'119','val_119','2008-04-08','11'
-'119','val_119','2008-04-08','11'
-'119','val_119','2008-04-08','11'
-'119','val_119','2008-04-08','12'
-'119','val_119','2008-04-08','12'
-'119','val_119','2008-04-08','12'
-'12','val_12','2008-04-08','11'
-'12','val_12','2008-04-08','11'
-'12','val_12','2008-04-08','12'
-'12','val_12','2008-04-08','12'
-'120','val_120','2008-04-08','11'
-'120','val_120','2008-04-08','11'
-'120','val_120','2008-04-08','12'
-'120','val_120','2008-04-08','12'
-'125','val_125','2008-04-08','11'
-'125','val_125','2008-04-08','11'
-'125','val_125','2008-04-08','12'
-'125','val_125','2008-04-08','12'
-'126','val_126','2008-04-08','11'
-'126','val_126','2008-04-08','12'
-'128','val_128','2008-04-08','11'
-'128','val_128','2008-04-08','11'
-'128','val_128','2008-04-08','11'
-'128','val_128','2008-04-08','12'
-'128','val_128','2008-04-08','12'
-'128','val_128','2008-04-08','12'
-'129','val_129','2008-04-08','11'
-'129','val_129','2008-04-08','11'
-'129','val_129','2008-04-08','12'
-'129','val_129','2008-04-08','12'
-'131','val_131','2008-04-08','11'
-'131','val_131','2008-04-08','12'
-'133','val_133','2008-04-08','11'
-'133','val_133','2008-04-08','12'
-'134','val_134','2008-04-08','11'
-'134','val_134','2008-04-08','11'
-'134','val_134','2008-04-08','12'
-'134','val_134','2008-04-08','12'
-'136','val_136','2008-04-08','11'
-'136','val_136','2008-04-08','12'
-'137','val_137','2008-04-08','11'
-'137','val_137','2008-04-08','11'
-'137','val_137','2008-04-08','12'
-'137','val_137','2008-04-08','12'
-'138','val_138','2008-04-08','11'
-'138','val_138','2008-04-08','11'
-'138','val_138','2008-04-08','11'
-'138','val_138','2008-04-08','11'
-'138','val_138','2008-04-08','12'
-'138','val_138','2008-04-08','12'
-'138','val_138','2008-04-08','12'
-'138','val_138','2008-04-08','12'
-'143','val_143','2008-04-08','11'
-'143','val_143','2008-04-08','12'
-'145','val_145','2008-04-08','11'
-'145','val_145','2008-04-08','12'
-'146','val_146','2008-04-08','11'
-'146','val_146','2008-04-08','11'
-'146','val_146','2008-04-08','12'
-'146','val_146','2008-04-08','12'
-'149','val_149','2008-04-08','11'
-'149','val_149','2008-04-08','11'
-'149','val_149','2008-04-08','12'
-'149','val_149','2008-04-08','12'
-'15','val_15','2008-04-08','11'
-'15','val_15','2008-04-08','11'
-'15','val_15','2008-04-08','12'
-'15','val_15','2008-04-08','12'
-'150','val_150','2008-04-08','11'
-'150','val_150','2008-04-08','12'
-'152','val_152','2008-04-08','11'
-'152','val_152','2008-04-08','11'
-'152','val_152','2008-04-08','12'
-'152','val_152','2008-04-08','12'
-'153','val_153','2008-04-08','11'
-'153','val_153','2008-04-08','12'
-'155','val_155','2008-04-08','11'
-'155','val_155','2008-04-08','12'
-'156','val_156','2008-04-08','11'
-'156','val_156','2008-04-08','12'
-'157','val_157','2008-04-08','11'
-'157','val_157','2008-04-08','12'
-'158','val_158','2008-04-08','11'
-'158','val_158','2008-04-08','12'
-'160','val_160','2008-04-08','11'
-'160','val_160','2008-04-08','12'
-'162','val_162','2008-04-08','11'
-'162','val_162','2008-04-08','12'
-'163','val_163','2008-04-08','11'
-'163','val_163','2008-04-08','12'
-'164','val_164','2008-04-08','11'
-'164','val_164','2008-04-08','11'
-'164','val_164','2008-04-08','12'
-'164','val_164','2008-04-08','12'
-'165','val_165','2008-04-08','11'
-'165','val_165','2008-04-08','11'
-'165','val_165','2008-04-08','12'
-'165','val_165','2008-04-08','12'
-'166','val_166','2008-04-08','11'
-'166','val_166','2008-04-08','12'
-'167','val_167','2008-04-08','11'
-'167','val_167','2008-04-08','11'
-'167','val_167','2008-04-08','11'
-'167','val_167','2008-04-08','12'
-'167','val_167','2008-04-08','12'
-'167','val_167','2008-04-08','12'
-'168','val_168','2008-04-08','11'
-'168','val_168','2008-04-08','12'
-'169','val_169','2008-04-08','11'
-'169','val_169','2008-04-08','11'
-'169','val_169','2008-04-08','11'
-'169','val_169','2008-04-08','11'
-'169','val_169','2008-04-08','12'
-'169','val_169','2008-04-08','12'
-'169','val_169','2008-04-08','12'
-'169','val_169','2008-04-08','12'
-'17','val_17','2008-04-08','11'
-'17','val_17','2008-04-08','12'
-'170','val_170','2008-04-08','11'
-'170','val_170','2008-04-08','12'
-'172','val_172','2008-04-08','11'
-'172','val_172','2008-04-08','11'
-'172','val_172','2008-04-08','12'
-'172','val_172','2008-04-08','12'
-'174','val_174','2008-04-08','11'
-'174','val_174','2008-04-08','11'
-'174','val_174','2008-04-08','12'
-'174','val_174','2008-04-08','12'
-'175','val_175','2008-04-08','11'
-'175','val_175','2008-04-08','11'
-'175','val_175','2008-04-08','12'
-'175','val_175','2008-04-08','12'
-'176','val_176','2008-04-08','11'
-'176','val_176','2008-04-08','11'
-'176','val_176','2008-04-08','12'
-'176','val_176','2008-04-08','12'
-'177','val_177','2008-04-08','11'
-'177','val_177','2008-04-08','12'
-'178','val_178','2008-04-08','11'
-'178','val_178','2008-04-08','12'
-'179','val_179','2008-04-08','11'
-'179','val_179','2008-04-08','11'
-'179','val_179','2008-04-08','12'
-'179','val_179','2008-04-08','12'
-'18','val_18','2008-04-08','11'
-'18','val_18','2008-04-08','11'
-'18','val_18','2008-04-08','12'
-'18','val_18','2008-04-08','12'
-'180','val_180','2008-04-08','11'
-'180','val_180','2008-04-08','12'
-'181','val_181','2008-04-08','11'
-'181','val_181','2008-04-08','12'
-'183','val_183','2008-04-08','11'
-'183','val_183','2008-04-08','12'
-'186','val_186','2008-04-08','11'
-'186','val_186','2008-04-08','12'
-'187','val_187','2008-04-08','11'
-'187','val_187','2008-04-08','11'
-'187','val_187','2008-04-08','11'
-'187','val_187','2008-04-08','12'
-'187','val_187','2008-04-08','12'
-'187','val_187','2008-04-08','12'
-'189','val_189','2008-04-08','11'
-'189','val_189','2008-04-08','12'
-'19','val_19','2008-04-08','11'
-'19','val_19','2008-04-08','12'
-'190','val_190','2008-04-08','11'
-'190','val_190','2008-04-08','12'
-'191','val_191','2008-04-08','11'
-'191','val_191','2008-04-08','11'
-'191','val_191','2008-04-08','12'
-'191','val_191','2008-04-08','12'
-'192','val_192','2008-04-08','11'
-'192','val_192','2008-04-08','12'
-'193','val_193','2008-04-08','11'
-'193','val_193','2008-04-08','11'
-'193','val_193','2008-04-08','11'
-'193','val_193','2008-04-08','12'
-'193','val_193','2008-04-08','12'
-'193','val_193','2008-04-08','12'
-'194','val_194','2008-04-08','11'
-'194','val_194','2008-04-08','12'
-'195','val_195','2008-04-08','11'
-'195','val_195','2008-04-08','11'
-'195','val_195','2008-04-08','12'
-'195','val_195','2008-04-08','12'
-'196','val_196','2008-04-08','11'
-'196','val_196','2008-04-08','12'
-'197','val_197','2008-04-08','11'
-'197','val_197','2008-04-08','11'
-'197','val_197','2008-04-08','12'
-'197','val_197','2008-04-08','12'
-'199','val_199','2008-04-08','11'
-'199','val_199','2008-04-08','11'
-'199','val_199','2008-04-08','11'
-'199','val_199','2008-04-08','12'
-'199','val_199','2008-04-08','12'
-'199','val_199','2008-04-08','12'
-'2','val_2','2008-04-08','11'
-'2','val_2','2008-04-08','12'
-'20','val_20','2008-04-08','11'
-'20','val_20','2008-04-08','12'
-'200','val_200','2008-04-08','11'
-'200','val_200','2008-04-08','11'
-'200','val_200','2008-04-08','12'
-'200','val_200','2008-04-08','12'
-'201','val_201','2008-04-08','11'
-'201','val_201','2008-04-08','12'
-'202','val_202','2008-04-08','11'
-'202','val_202','2008-04-08','12'
-'203','val_203','2008-04-08','11'
-'203','val_203','2008-04-08','11'
-'203','val_203','2008-04-08','12'
-'203','val_203','2008-04-08','12'
-'205','val_205','2008-04-08','11'
-'205','val_205','2008-04-08','11'
-'205','val_205','2008-04-08','12'
-'205','val_205','2008-04-08','12'
-'207','val_207','2008-04-08','11'
-'207','val_207','2008-04-08','11'
-'207','val_207','2008-04-08','12'
-'207','val_207','2008-04-08','12'
-'208','val_208','2008-04-08','11'
-'208','val_208','2008-04-08','11'
-'208','val_208','2008-04-08','11'
-'208','val_208','2008-04-08','12'
-'208','val_208','2008-04-08','12'
-'208','val_208','2008-04-08','12'
-'209','val_209','2008-04-08','11'
-'209','val_209','2008-04-08','11'
-'209','val_209','2008-04-08','12'
-'209','val_209','2008-04-08','12'
-'213','val_213','2008-04-08','11'
-'213','val_213','2008-04-08','11'
-'213','val_213','2008-04-08','12'
-'213','val_213','2008-04-08','12'
-'214','val_214','2008-04-08','11'
-'214','val_214','2008-04-08','12'
-'216','val_216','2008-04-08','11'
-'216','val_216','2008-04-08','11'
-'216','val_216','2008-04-08','12'
-'216','val_216','2008-04-08','12'
-'217','val_217','2008-04-08','11'
-'217','val_217','2008-04-08','11'
-'217','val_217','2008-04-08','12'
-'217','val_217','2008-04-08','12'
-'218','val_218','2008-04-08','11'
-'218','val_218','2008-04-08','12'
-'219','val_219','2008-04-08','11'
-'219','val_219','2008-04-08','11'
-'219','val_219','2008-04-08','12'
-'219','val_219','2008-04-08','12'
-'221','val_221','2008-04-08','11'
-'221','val_221','2008-04-08','11'
-'221','val_221','2008-04-08','12'
-'221','val_221','2008-04-08','12'
-'222','val_222','2008-04-08','11'
-'222','val_222','2008-04-08','12'
-'223','val_223','2008-04-08','11'
-'223','val_223','2008-04-08','11'
-'223','val_223','2008-04-08','12'
-'223','val_223','2008-04-08','12'
-'224','val_224','2008-04-08','11'
-'224','val_224','2008-04-08','11'
-'224','val_224','2008-04-08','12'
-'224','val_224','2008-04-08','12'
-'226','val_226','2008-04-08','11'
-'226','val_226','2008-04-08','12'
-'228','val_228','2008-04-08','11'
-'228','val_228','2008-04-08','12'
-'229','val_229','2008-04-08','11'
-'229','val_229','2008-04-08','11'
-'229','val_229','2008-04-08','12'
-'229','val_229','2008-04-08','12'
-'230','val_230','2008-04-08','11'
-'230','val_230','2008-04-08','11'
-'230','val_230','2008-04-08','11'
-'230','val_230','2008-04-08','11'
-'230','val_230','2008-04-08','11'
-'230','val_230','2008-04-08','12'
-'230','val_230','2008-04-08','12'
-'230','val_230','2008-04-08','12'
-'230','val_230','2008-04-08','12'
-'230','val_230','2008-04-08','12'
-'233','val_233','2008-04-08','11'
-'233','val_233','2008-04-08','11'
-'233','val_233','2008-04-08','12'
-'233','val_233','2008-04-08','12'
-'235','val_235','2008-04-08','11'
-'235','val_235','2008-04-08','12'
-'237','val_237','2008-04-08','11'
-'237','val_237','2008-04-08','11'
-'237','val_237','2008-04-08','12'
-'237','val_237','2008-04-08','12'
-'238','val_238','2008-04-08','11'
-'238','val_238','2008-04-08','11'
-'238','val_238','2008-04-08','12'
-'238','val_238','2008-04-08','12'
-'239','val_239','2008-04-08','11'
-'239','val_239','2008-04-08','11'
-'239','val_239','2008-04-08','12'
-'239','val_239','2008-04-08','12'
-'24','val_24','2008-04-08','11'
-'24','val_24','2008-04-08','11'
-'24','val_24','2008-04-08','12'
-'24','val_24','2008-04-08','12'
-'241','val_241','2008-04-08','11'
-'241','val_241','2008-04-08','12'
-'242','val_242','2008-04-08','11'
-'242','val_242','2008-04-08','11'
-'242','val_242','2008-04-08','12'
-'242','val_242','2008-04-08','12'
-'244','val_244','2008-04-08','11'
-'244','val_244','2008-04-08','12'
-'247','val_247','2008-04-08','11'
-'247','val_247','2008-04-08','12'
-'248','val_248','2008-04-08','11'
-'248','val_248','2008-04-08','12'
-'249','val_249','2008-04-08','11'
-'249','val_249','2008-04-08','12'
-'252','val_252','2008-04-08','11'
-'252','val_252','2008-04-08','12'
-'255','val_255','2008-04-08','11'
-'255','val_255','2008-04-08','11'
-'255','val_255','2008-04-08','12'
-'255','val_255','2008-04-08','12'
-'256','val_256','2008-04-08','11'
-'256','val_256','2008-04-08','11'
-'256','val_256','2008-04-08','12'
-'256','val_256','2008-04-08','12'
-'257','val_257','2008-04-08','11'
-'257','val_257','2008-04-08','12'
-'258','val_258','2008-04-08','11'
-'258','val_258','2008-04-08','12'
-'26','val_26','2008-04-08','11'
-'26','val_26','2008-04-08','11'
-'26','val_26','2008-04-08','12'
-'26','val_26','2008-04-08','12'
-'260','val_260','2008-04-08','11'
-'260','val_260','2008-04-08','12'
-'262','val_262','2008-04-08','11'
-'262','val_262','2008-04-08','12'
-'263','val_263','2008-04-08','11'
-'263','val_263','2008-04-08','12'
-'265','val_265','2008-04-08','11'
-'265','val_265','2008-04-08','11'
-'265','val_265','2008-04-08','12'
-'265','val_265','2008-04-08','12'
-'266','val_266','2008-04-08','11'
-'266','val_266','2008-04-08','12'
-'27','val_27','2008-04-08','11'
-'27','val_27','2008-04-08','12'
-'272','val_272','2008-04-08','11'
-'272','val_272','2008-04-08','11'
-'272','val_272','2008-04-08','12'
-'272','val_272','2008-04-08','12'
-'273','val_273','2008-04-08','11'
-'273','val_273','2008-04-08','11'
-'273','val_273','2008-04-08','11'
-'273','val_273','2008-04-08','12'
-'273','val_273','2008-04-08','12'
-'273','val_273','2008-04-08','12'
-'274','val_274','2008-04-08','11'
-'274','val_274','2008-04-08','12'
-'275','val_275','2008-04-08','11'
-'275','val_275','2008-04-08','12'
-'277','val_277','2008-04-08','11'
-'277','val_277','2008-04-08','11'
-'277','val_277','2008-04-08','11'
-'277','val_277','2008-04-08','11'
-'277','val_277','2008-04-08','12'
-'277','val_277','2008-04-08','12'
-'277','val_277','2008-04-08','12'
-'277','val_277','2008-04-08','12'
-'278','val_278','2008-04-08','11'
-'278','val_278','2008-04-08','11'
-'278','val_278','2008-04-08','12'
-'278','val_278','2008-04-08','12'
-'28','val_28','2008-04-08','11'
-'28','val_28','2008-04-08','12'
-'280','val_280','2008-04-08','11'
-'280','val_280','2008-04-08','11'
-'280','val_280','2008-04-08','12'
-'280','val_280','2008-04-08','12'
-'281','val_281','2008-04-08','11'
-'281','val_281','2008-04-08','11'
-'281','val_281','2008-04-08','12'
-'281','val_281','2008-04-08','12'
-'282','val_282','2008-04-08','11'
-'282','val_282','2008-04-08','11'
-'282','val_282','2008-04-08','12'
-'282','val_282','2008-04-08','12'
-'283','val_283','2008-04-08','11'
-'283','val_283','2008-04-08','12'
-'284','val_284','2008-04-08','11'
-'284','val_284','2008-04-08','12'
-'285','val_285','2008-04-08','11'
-'285','val_285','2008-04-08','12'
-'286','val_286','2008-04-08','11'
-'286','val_286','2008-04-08','12'
-'287','val_287','2008-04-08','11'
-'287','val_287','2008-04-08','12'
-'288','val_288','2008-04-08','11'
-'288','val_288','2008-04-08','11'
-'288','val_288','2008-04-08','12'
-'288','val_288','2008-04-08','12'
-'289','val_289','2008-04-08','11'
-'289','val_289','2008-04-08','12'
-'291','val_291','2008-04-08','11'
-'291','val_291','2008-04-08','12'
-'292','val_292','2008-04-08','11'
-'292','val_292','2008-04-08','12'
-'296','val_296','2008-04-08','11'
-'296','val_296','2008-04-08','12'
-'298','val_298','2008-04-08','11'
-'298','val_298','2008-04-08','11'
-'298','val_298','2008-04-08','11'
-'298','val_298','2008-04-08','12'
-'298','val_298','2008-04-08','12'
-'298','val_298','2008-04-08','12'
-'30','val_30','2008-04-08','11'
-'30','val_30','2008-04-08','12'
-'302','val_302','2008-04-08','11'
-'302','val_302','2008-04-08','12'
-'305','val_305','2008-04-08','11'
-'305','val_305','2008-04-08','12'
-'306','val_306','2008-04-08','11'
-'306','val_306','2008-04-08','12'
-'307','val_307','2008-04-08','11'
-'307','val_307','2008-04-08','11'
-'307','val_307','2008-04-08','12'
-'307','val_307','2008-04-08','12'
-'308','val_308','2008-04-08','11'
-'308','val_308','2008-04-08','12'
-'309','val_309','2008-04-08','11'
-'309','val_309','2008-04-08','11'
-'309','val_309','2008-04-08','12'
-'309','val_309','2008-04-08','12'
-'310','val_310','2008-04-08','11'
-'310','val_310','2008-04-08','12'
-'311','val_311','2008-04-08','11'
-'311','val_311','2008-04-08','11'
-'311','val_311','2008-04-08','11'
-'311','val_311','2008-04-08','12'
-'311','val_311','2008-04-08','12'
-'311','val_311','2008-04-08','12'
-'315','val_315','2008-04-08','11'
-'315','val_315','2008-04-08','12'
-'316','val_316','2008-04-08','11'
-'316','val_316','2008-04-08','11'
-'316','val_316','2008-04-08','11'
-'316','val_316','2008-04-08','12'
-'316','val_316','2008-04-08','12'
-'316','val_316','2008-04-08','12'
-'317','val_317','2008-04-08','11'
-'317','val_317','2008-04-08','11'
-'317','val_317','2008-04-08','12'
-'317','val_317','2008-04-08','12'
-'318','val_318','2008-04-08','11'
-'318','val_318','2008-04-08','11'
-'318','val_318','2008-04-08','11'
-'318','val_318','2008-04-08','12'
-'318','val_318','2008-04-08','12'
-'318','val_318','2008-04-08','12'
-'321','val_321','2008-04-08','11'
-'321','val_321','2008-04-08','11'
-'321','val_321','2008-04-08','12'
-'321','val_321','2008-04-08','12'
-'322','val_322','2008-04-08','11'
-'322','val_322','2008-04-08','11'
-'322','val_322','2008-04-08','12'
-'322','val_322','2008-04-08','12'
-'323','val_323','2008-04-08','11'
-'323','val_323','2008-04-08','12'
-'325','val_325','2008-04-08','11'
-'325','val_325','2008-04-08','11'
-'325','val_325','2008-04-08','12'
-'325','val_325','2008-04-08','12'
-'327','val_327','2008-04-08','11'
-'327','val_327','2008-04-08','11'
-'327','val_327','2008-04-08','11'
-'327','val_327','2008-04-08','12'
-'327','val_327','2008-04-08','12'
-'327','val_327','2008-04-08','12'
-'33','val_33','2008-04-08','11'
-'33','val_33','2008-04-08','12'
-'331','val_331','2008-04-08','11'
-'331','val_331','2008-04-08','11'
-'331','val_331','2008-04-08','12'
-'331','val_331','2008-04-08','12'
-'332','val_332','2008-04-08','11'
-'332','val_332','2008-04-08','12'
-'333','val_333','2008-04-08','11'
-'333','val_333','2008-04-08','11'
-'333','val_333','2008-04-08','12'
-'333','val_333','2008-04-08','12'
-'335','val_335','2008-04-08','11'
-'335','val_335','2008-04-08','12'
-'336','val_336','2008-04-08','11'
-'336','val_336','2008-04-08','12'
-'338','val_338','2008-04-08','11'
-'338','val_338','2008-04-08','12'
-'339','val_339','2008-04-08','11'
-'339','val_339','2008-04-08','12'
-'34','val_34','2008-04-08','11'
-'34','val_34','2008-04-08','12'
-'341','val_341','2008-04-08','11'
-'341','val_341','2008-04-08','12'
-'342','val_342','2008-04-08','11'
-'342','val_342','2008-04-08','11'
-'342','val_342','2008-04-08','12'
-'342','val_342','2008-04-08','12'
-'344','val_344','2008-04-08','11'
-'344','val_344','2008-04-08','11'
-'344','val_344','2008-04-08','12'
-'344','val_344','2008-04-08','12'
-'345','val_345','2008-04-08','11'
-'345','val_345','2008-04-08','12'
-'348','val_348','2008-04-08','11'
-'348','val_348','2008-04-08','11'
-'348','val_348','2008-04-08','11'
-'348','val_348','2008-04-08','11'
-'348','val_348','2008-04-08','11'
-'348','val_348','2008-04-08','12'
-'348','val_348','2008-04-08','12'
-'348','val_348','2008-04-08','12'
-'348','val_348','2008-04-08','12'
-'348','val_348','2008-04-08','12'
-'35','val_35','2008-04-08','11'
-'35','val_35','2008-04-08','11'
-'35','val_35','2008-04-08','11'
-'35','val_35','2008-04-08','12'
-'35','val_35','2008-04-08','12'
-'35','val_35','2008-04-08','12'
-'351','val_351','2008-04-08','11'
-'351','val_351','2008-04-08','12'
-'353','val_353','2008-04-08','11'
-'353','val_353','2008-04-08','11'
-'353','val_353','2008-04-08','12'
-'353','val_353','2008-04-08','12'
-'356','val_356','2008-04-08','11'
-'356','val_356','2008-04-08','12'
-'360','val_360','2008-04-08','11'
-'360','val_360','2008-04-08','12'
-'362','val_362','2008-04-08','11'
-'362','val_362','2008-04-08','12'
-'364','val_364','2008-04-08','11'
-'364','val_364','2008-04-08','12'
-'365','val_365','2008-04-08','11'
-'365','val_365','2008-04-08','12'
-'366','val_366','2008-04-08','11'
-'366','val_366','2008-04-08','12'
-'367','val_367','2008-04-08','11'
-'367','val_367','2008-04-08','11'
-'367','val_367','2008-04-08','12'
-'367','val_367','2008-04-08','12'
-'368','val_368','2008-04-08','11'
-'368','val_368','2008-04-08','12'
-'369','val_369','2008-04-08','11'
-'369','val_369','2008-04-08','11'
-'369','val_369','2008-04-08','11'
-'369','val_369','2008-04-08','12'
-'369','val_369','2008-04-08','12'
-'369','val_369','2008-04-08','12'
-'37','val_37','2008-04-08','11'
-'37','val_37','2008-04-08','11'
-'37','val_37','2008-04-08','12'
-'37','val_37','2008-04-08','12'
-'373','val_373','2008-04-08','11'
-'373','val_373','2008-04-08','12'
-'374','val_374','2008-04-08','11'
-'374','val_374','2008-04-08','12'
-'375','val_375','2008-04-08','11'
-'375','val_375','2008-04-08','12'
-'377','val_377','2008-04-08','11'
-'377','val_377','2008-04-08','12'
-'378','val_378','2008-04-08','11'
-'378','val_378','2008-04-08','12'
-'379','val_379','2008-04-08','11'
-'379','val_379','2008-04-08','12'
-'382','val_382','2008-04-08','11'
-'382','val_382','2008-04-08','11'
-'382','val_382','2008-04-08','12'
-'382','val_382','2008-04-08','12'
-'384','val_384','2008-04-08','11'
-'384','val_384','2008-04-08','11'
-'384','val_384','2008-04-08','11'
-'384','val_384','2008-04-08','12'
-'384','val_384','2008-04-08','12'
-'384','val_384','2008-04-08','12'
-'386','val_386','2008-04-08','11'
-'386','val_386','2008-04-08','12'
-'389','val_389','2008-04-08','11'
-'389','val_389','2008-04-08','12'
-'392','val_392','2008-04-08','11'
-'392','val_392','2008-04-08','12'
-'393','val_393','2008-04-08','11'
-'393','val_393','2008-04-08','12'
-'394','val_394','2008-04-08','11'
-'394','val_394','2008-04-08','12'
-'395','val_395','2008-04-08','11'
-'395','val_395','2008-04-08','11'
-'395','val_395','2008-04-08','12'
-'395','val_395','2008-04-08','12'
-'396','val_396','2008-04-08','11'
-'396','val_396','2008-04-08','11'
-'396','val_396','2008-04-08','11'
-'396','val_396','2008-04-08','12'
-'396','val_396','2008-04-08','12'
-'396','val_396','2008-04-08','12'
-'397','val_397','2008-04-08','11'
-'397','val_397','2008-04-08','11'
-'397','val_397','2008-04-08','12'
-'397','val_397','2008-04-08','12'
-'399','val_399','2008-04-08','11'
-'399','val_399','2008-04-08','11'
-'399','val_399','2008-04-08','12'
-'399','val_399','2008-04-08','12'
-'4','val_4','2008-04-08','11'
-'4','val_4','2008-04-08','12'
-'400','val_400','2008-04-08','11'
-'400','val_400','2008-04-08','12'
-'401','val_401','2008-04-08','11'
-'401','val_401','2008-04-08','11'
-'401','val_401','2008-04-08','11'
-'401','val_401','2008-04-08','11'
-'401','val_401','2008-04-08','11'
-'401','val_401','2008-04-08','12'
-'401','val_401','2008-04-08','12'
-'401','val_401','2008-04-08','12'
-'401','val_401','2008-04-08','12'
-'401','val_401','2008-04-08','12'
-'402','val_402','2008-04-08','11'
-'402','val_402','2008-04-08','12'
-'403','val_403','2008-04-08','11'
-'403','val_403','2008-04-08','11'
-'403','val_403','2008-04-08','11'
-'403','val_403','2008-04-08','12'
-'403','val_403','2008-04-08','12'
-'403','val_403','2008-04-08','12'
-'404','val_404','2008-04-08','11'
-'404','val_404','2008-04-08','11'
-'404','val_404','2008-04-08','12'
-'404','val_404','2008-04-08','12'
-'406','val_406','2008-04-08','11'
-'406','val_406','2008-04-08','11'
-'406','val_406','2008-04-08','11'
-'406','val_406','2008-04-08','11'
-'406','val_406','2008-04-08','12'
-'406','val_406','2008-04-08','12'
-'406','val_406','2008-04-08','12'
-'406','val_406','2008-04-08','12'
-'407','val_407','2008-04-08','11'
-'407','val_407','2008-04-08','12'
-'409','val_409','2008-04-08','11'
-'409','val_409','2008-04-08','11'
-'409','val_409','2008-04-08','11'
-'409','val_409','2008-04-08','12'
-'409','val_409','2008-04-08','12'
-'409','val_409','2008-04-08','12'
-'41','val_41','2008-04-08','11'
-'41','val_41','2008-04-08','12'
-'411','val_411','2008-04-08','11'
-'411','val_411','2008-04-08','12'
-'413','val_413','2008-04-08','11'
-'413','val_413','2008-04-08','11'
-'413','val_413','2008-04-08','12'
-'413','val_413','2008-04-08','12'
-'414','val_414','2008-04-08','11'
-'414','val_414','2008-04-08','11'
-'414','val_414','2008-04-08','12'
-'414','val_414','2008-04-08','12'
-'417','val_417','2008-04-08','11'
-'417','val_417','2008-04-08','11'
-'417','val_417','2008-04-08','11'
-'417','val_417','2008-04-08','12'
-'417','val_417','2008-04-08','12'
-'417','val_417','2008-04-08','12'
-'418','val_418','2008-04-08','11'
-'418','val_418','2008-04-08','12'
-'419','val_419','2008-04-08','11'
-'419','val_419','2008-04-08','12'
-'42','val_42','2008-04-08','11'
-'42','val_42','2008-04-08','11'
-'42','val_42','2008-04-08','12'
-'42','val_42','2008-04-08','12'
-'421','val_421','2008-04-08','11'
-'421','val_421','2008-04-08','12'
-'424','val_424','2008-04-08','11'
-'424','val_424','2008-04-08','11'
-'424','val_424','2008-04-08','12'
-'424','val_424','2008-04-08','12'
-'427','val_427','2008-04-08','11'
-'427','val_427','2008-04-08','12'
-'429','val_429','2008-04-08','11'
-'429','val_429','2008-04-08','11'
-'429','val_429','2008-04-08','12'
-'429','val_429','2008-04-08','12'
-'43','val_43','2008-04-08','11'
-'43','val_43','2008-04-08','12'
-'430','val_430','2008-04-08','11'
-'430','val_430','2008-04-08','11'
-'430','val_430','2008-04-08','11'
-'430','val_430','2008-04-08','12'
-'430','val_430','2008-04-08','12'
-'430','val_430','2008-04-08','12'
-'431','val_431','2008-04-08','11'
-'431','val_431','2008-04-08','11'
-'431','val_431','2008-04-08','11'
-'431','val_431','2008-04-08','12'
-'431','val_431','2008-04-08','12'
-'431','val_431','2008-04-08','12'
-'432','val_432','2008-04-08','11'
-'432','val_432','2008-04-08','12'
-'435','val_435','2008-04-08','11'
-'435','val_435','2008-04-08','12'
-'436','val_436','2008-04-08','11'
-'436','val_436','2008-04-08','12'
-'437','val_437','2008-04-08','11'
-'437','val_437','2008-04-08','12'
-'438','val_438','2008-04-08','11'
-'438','val_438','2008-04-08','11'
-'438','val_438','2008-04-08','11'
-'438','val_438','2008-04-08','12'
-'438','val_438','2008-04-08','12'
-'438','val_438','2008-04-08','12'
-'439','val_439','2008-04-08','11'
-'439','val_439','2008-04-08','11'
-'439','val_439','2008-04-08','12'
-'439','val_439','2008-04-08','12'
-'44','val_44','2008-04-08','11'
-'44','val_44','2008-04-08','12'
-'443','val_443','2008-04-08','11'
-'443','val_443','2008-04-08','12'
-'444','val_444','2008-04-08','11'
-'444','val_444','2008-04-08','12'
-'446','val_446','2008-04-08','11'
-'446','val_446','2008-04-08','12'
-'448','val_448','2008-04-08','11'
-'448','val_448','2008-04-08','12'
-'449','val_449','2008-04-08','11'
-'449','val_449','2008-04-08','12'
-'452','val_452','2008-04-08','11'
-'452','val_452','2008-04-08','12'
-'453','val_453','2008-04-08','11'
-'453','val_453','2008-04-08','12'
-'454','val_454','2008-04-08','11'
-'454','val_454','2008-04-08','11'
-'454','val_454','2008-04-08','11'
-'454','val_454','2008-04-08','12'
-'454','val_454','2008-04-08','12'
-'454','val_454','2008-04-08','12'
-'455','val_455','2008-04-08','11'
-'455','val_455','2008-04-08','12'
-'457','val_457','2008-04-08','11'
-'457','val_457','2008-04-08','12'
-'458','val_458','2008-04-08','11'
-'458','val_458','2008-04-08','11'
-'458','val_458','2008-04-08','12'
-'458','val_458','2008-04-08','12'
-'459','val_459','2008-04-08','11'
-'459','val_459','2008-04-08','11'
-'459','val_459','2008-04-08','12'
-'459','val_459','2008-04-08','12'
-'460','val_460','2008-04-08','11'
-'460','val_460','2008-04-08','12'
-'462','val_462','2008-04-08','11'
-'462','val_462','2008-04-08','11'
-'462','val_462','2008-04-08','12'
-'462','val_462','2008-04-08','12'
-'463','val_463','2008-04-08','11'
-'463','val_463','2008-04-08','11'
-'463','val_463','2008-04-08','12'
-'463','val_463','2008-04-08','12'
-'466','val_466','2008-04-08','11'
-'466','val_466','2008-04-08','11'
-'466','val_466','2008-04-08','11'
-'466','val_466','2008-04-08','12'
-'466','val_466','2008-04-08','12'
-'466','val_466','2008-04-08','12'
-'467','val_467','2008-04-08','11'
-'467','val_467','2008-04-08','12'
-'468','val_468','2008-04-08','11'
-'468','val_468','2008-04-08','11'
-'468','val_468','2008-04-08','11'
-'468','val_468','2008-04-08','11'
-'468','val_468','2008-04-08','12'
-'468','val_468','2008-04-08','12'
-'468','val_468','2008-04-08','12'
-'468','val_468','2008-04-08','12'
-'469','val_469','2008-04-08','11'
-'469','val_469','2008-04-08','11'
-'469','val_469','2008-04-08','11'
-'469','val_469','2008-04-08','11'
-'469','val_469','2008-04-08','11'
-'469','val_469','2008-04-08','12'
-'469','val_469','2008-04-08','12'
-'469','val_469','2008-04-08','12'
-'469','val_469','2008-04-08','12'
-'469','val_469','2008-04-08','12'
-'47','val_47','2008-04-08','11'
-'47','val_47','2008-04-08','12'
-'470','val_470','2008-04-08','11'
-'470','val_470','2008-04-08','12'
-'472','val_472','2008-04-08','11'
-'472','val_472','2008-04-08','12'
-'475','val_475','2008-04-08','11'
-'475','val_475','2008-04-08','12'
-'477','val_477','2008-04-08','11'
-'477','val_477','2008-04-08','12'
-'478','val_478','2008-04-08','11'
-'478','val_478','2008-04-08','11'
-'478','val_478','2008-04-08','12'
-'478','val_478','2008-04-08','12'
-'479','val_479','2008-04-08','11'
-'479','val_479','2008-04-08','12'
-'480','val_480','2008-04-08','11'
-'480','val_480','2008-04-08','11'
-'480','val_480','2008-04-08','11'
-'480','val_480','2008-04-08','12'
-'480','val_480','2008-04-08','12'
-'480','val_480','2008-04-08','12'
-'481','val_481','2008-04-08','11'
-'481','val_481','2008-04-08','12'
-'482','val_482','2008-04-08','11'
-'482','val_482','2008-04-08','12'
-'483','val_483','2008-04-08','11'
-'483','val_483','2008-04-08','12'
-'484','val_484','2008-04-08','11'
-'484','val_484','2008-04-08','12'
-'485','val_485','2008-04-08','11'
-'485','val_485','2008-04-08','12'
-'487','val_487','2008-04-08','11'
-'487','val_487','2008-04-08','12'
-'489','val_489','2008-04-08','11'
-'489','val_489','2008-04-08','11'
-'489','val_489','2008-04-08','11'
-'489','val_489','2008-04-08','11'
-'489','val_489','2008-04-08','12'
-'489','val_489','2008-04-08','12'
-'489','val_489','2008-04-08','12'
-'489','val_489','2008-04-08','12'
-'490','val_490','2008-04-08','11'
-'490','val_490','2008-04-08','12'
-'491','val_491','2008-04-08','11'
-'491','val_491','2008-04-08','12'
-'492','val_492','2008-04-08','11'
-'492','val_492','2008-04-08','11'
-'492','val_492','2008-04-08','12'
-'492','val_492','2008-04-08','12'
-'493','val_493','2008-04-08','11'
-'493','val_493','2008-04-08','12'
-'494','val_494','2008-04-08','11'
-'494','val_494','2008-04-08','12'
-'495','val_495','2008-04-08','11'
-'495','val_495','2008-04-08','12'
-'496','val_496','2008-04-08','11'
-'496','val_496','2008-04-08','12'
-'497','val_497','2008-04-08','11'
-'497','val_497','2008-04-08','12'
-'498','val_498','2008-04-08','11'
-'498','val_498','2008-04-08','11'
-'498','val_498','2008-04-08','11'
-'498','val_498','2008-04-08','12'
-'498','val_498','2008-04-08','12'
-'498','val_498','2008-04-08','12'
-'5','val_5','2008-04-08','11'
-'5','val_5','2008-04-08','11'
-'5','val_5','2008-04-08','11'
-'5','val_5','2008-04-08','12'
-'5','val_5','2008-04-08','12'
-'5','val_5','2008-04-08','12'
-'51','val_51','2008-04-08','11'
-'51','val_51','2008-04-08','11'
-'51','val_51','2008-04-08','12'
-'51','val_51','2008-04-08','12'
-'53','val_53','2008-04-08','11'
-'53','val_53','2008-04-08','12'
-'54','val_54','2008-04-08','11'
-'54','val_54','2008-04-08','12'
-'57','val_57','2008-04-08','11'
-'57','val_57','2008-04-08','12'
-'58','val_58','2008-04-08','11'
-'58','val_58','2008-04-08','11'
-'58','val_58','2008-04-08','12'
-'58','val_58','2008-04-08','12'
-'64','val_64','2008-04-08','11'
-'64','val_64','2008-04-08','12'
-'65','val_65','2008-04-08','11'
-'65','val_65','2008-04-08','12'
-'66','val_66','2008-04-08','11'
-'66','val_66','2008-04-08','12'
-'67','val_67','2008-04-08','11'
-'67','val_67','2008-04-08','11'
-'67','val_67','2008-04-08','12'
-'67','val_67','2008-04-08','12'
-'69','val_69','2008-04-08','11'
-'69','val_69','2008-04-08','12'
-'70','val_70','2008-04-08','11'
-'70','val_70','2008-04-08','11'
-'70','val_70','2008-04-08','11'
-'70','val_70','2008-04-08','12'
-'70','val_70','2008-04-08','12'
-'70','val_70','2008-04-08','12'
-'72','val_72','2008-04-08','11'
-'72','val_72','2008-04-08','11'
-'72','val_72','2008-04-08','12'
-'72','val_72','2008-04-08','12'
-'74','val_74','2008-04-08','11'
-'74','val_74','2008-04-08','12'
-'76','val_76','2008-04-08','11'
-'76','val_76','2008-04-08','11'
-'76','val_76','2008-04-08','12'
-'76','val_76','2008-04-08','12'
-'77','val_77','2008-04-08','11'
-'77','val_77','2008-04-08','12'
-'78','val_78','2008-04-08','11'
-'78','val_78','2008-04-08','12'
-'8','val_8','2008-04-08','11'
-'8','val_8','2008-04-08','12'
-'80','val_80','2008-04-08','11'
-'80','val_80','2008-04-08','12'
-'82','val_82','2008-04-08','11'
-'82','val_82','2008-04-08','12'
-'83','val_83','2008-04-08','11'
-'83','val_83','2008-04-08','11'
-'83','val_83','2008-04-08','12'
-'83','val_83','2008-04-08','12'
-'84','val_84','2008-04-08','11'
-'84','val_84','2008-04-08','11'
-'84','val_84','2008-04-08','12'
-'84','val_84','2008-04-08','12'
-'85','val_85','2008-04-08','11'
-'85','val_85','2008-04-08','12'
-'86','val_86','2008-04-08','11'
-'86','val_86','2008-04-08','12'
-'87','val_87','2008-04-08','11'
-'87','val_87','2008-04-08','12'
-'9','val_9','2008-04-08','11'
-'9','val_9','2008-04-08','12'
-'90','val_90','2008-04-08','11'
-'90','val_90','2008-04-08','11'
-'90','val_90','2008-04-08','11'
-'90','val_90','2008-04-08','12'
-'90','val_90','2008-04-08','12'
-'90','val_90','2008-04-08','12'
-'92','val_92','2008-04-08','11'
-'92','val_92','2008-04-08','12'
-'95','val_95','2008-04-08','11'
-'95','val_95','2008-04-08','11'
-'95','val_95','2008-04-08','12'
-'95','val_95','2008-04-08','12'
-'96','val_96','2008-04-08','11'
-'96','val_96','2008-04-08','12'
-'97','val_97','2008-04-08','11'
-'97','val_97','2008-04-08','11'
-'97','val_97','2008-04-08','12'
-'97','val_97','2008-04-08','12'
-'98','val_98','2008-04-08','11'
-'98','val_98','2008-04-08','11'
-'98','val_98','2008-04-08','12'
-'98','val_98','2008-04-08','12'
-1,000 rows selected
->>>
->>>
->>> explain extended
-select * from srcpart a where a.ds='2008-04-08' and key < 200 order by a.key, a.hr;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08') (< (TOK_TABLE_OR_COL key) 200))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) hr)))))'
-''
-'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:'
-' a '
-' TableScan'
-' alias: a'
-' GatherStats: false'
-' Filter Operator'
-' isSamplingPred: false'
-' predicate:'
-' expr: (key < 200.0)'
-' type: boolean'
-' Select Operator'
-' expressions:'
-' expr: key'
-' type: string'
-' expr: value'
-' type: string'
-' expr: ds'
-' type: string'
-' expr: hr'
-' type: string'
-' outputColumnNames: _col0, _col1, _col2, _col3'
-' Reduce Output Operator'
-' key expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col3'
-' type: string'
-' sort order: ++'
-' tag: -1'
-' value expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' type: string'
-' expr: _col2'
-' type: string'
-' expr: _col3'
-' type: string'
-' Needs Tagging: false'
-' Path -> Alias:'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=11 [a]'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=12 [a]'
-' Path -> Partition:'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=11 '
-' Partition'
-' base file name: hr=11'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' partition values:'
-' ds 2008-04-08'
-' hr 11'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=11'
-' name input42.srcpart'
-' numFiles 1'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 5812'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' '
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart'
-' name input42.srcpart'
-' numFiles 4'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 23248'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' name: input42.srcpart'
-' name: input42.srcpart'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=12 '
-' Partition'
-' base file name: hr=12'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' partition values:'
-' ds 2008-04-08'
-' hr 12'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=12'
-' name input42.srcpart'
-' numFiles 1'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 5812'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' '
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart'
-' name input42.srcpart'
-' numFiles 4'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 23248'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' name: input42.srcpart'
-' name: input42.srcpart'
-' Reduce Operator Tree:'
-' Extract'
-' File Output Operator'
-' compressed: false'
-' GlobalTableId: 0'
-' directory: file:!!{hive.exec.scratchdir}!!'
-' NumFilesPerFileSink: 1'
-' Stats Publishing Key Prefix: file:!!{hive.exec.scratchdir}!!'
-' table:'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' properties:'
-' columns _col0,_col1,_col2,_col3'
-' columns.types string:string:string:string'
-' escape.delim \'
-' serialization.format 1'
-' TotalFiles: 1'
-' GatherStats: false'
-' MultiFileSpray: false'
-''
-' Stage: Stage-0'
-' Fetch Operator'
-' limit: -1'
-''
-''
-180 rows selected
->>>
->>> select * from srcpart a where a.ds='2008-04-08' and key < 200 order by a.key, a.hr;
-'key','value','ds','hr'
-'0','val_0','2008-04-08','11'
-'0','val_0','2008-04-08','11'
-'0','val_0','2008-04-08','11'
-'0','val_0','2008-04-08','12'
-'0','val_0','2008-04-08','12'
-'0','val_0','2008-04-08','12'
-'10','val_10','2008-04-08','11'
-'10','val_10','2008-04-08','12'
-'100','val_100','2008-04-08','11'
-'100','val_100','2008-04-08','11'
-'100','val_100','2008-04-08','12'
-'100','val_100','2008-04-08','12'
-'103','val_103','2008-04-08','11'
-'103','val_103','2008-04-08','11'
-'103','val_103','2008-04-08','12'
-'103','val_103','2008-04-08','12'
-'104','val_104','2008-04-08','11'
-'104','val_104','2008-04-08','11'
-'104','val_104','2008-04-08','12'
-'104','val_104','2008-04-08','12'
-'105','val_105','2008-04-08','11'
-'105','val_105','2008-04-08','12'
-'11','val_11','2008-04-08','11'
-'11','val_11','2008-04-08','12'
-'111','val_111','2008-04-08','11'
-'111','val_111','2008-04-08','12'
-'113','val_113','2008-04-08','11'
-'113','val_113','2008-04-08','11'
-'113','val_113','2008-04-08','12'
-'113','val_113','2008-04-08','12'
-'114','val_114','2008-04-08','11'
-'114','val_114','2008-04-08','12'
-'116','val_116','2008-04-08','11'
-'116','val_116','2008-04-08','12'
-'118','val_118','2008-04-08','11'
-'118','val_118','2008-04-08','11'
-'118','val_118','2008-04-08','12'
-'118','val_118','2008-04-08','12'
-'119','val_119','2008-04-08','11'
-'119','val_119','2008-04-08','11'
-'119','val_119','2008-04-08','11'
-'119','val_119','2008-04-08','12'
-'119','val_119','2008-04-08','12'
-'119','val_119','2008-04-08','12'
-'12','val_12','2008-04-08','11'
-'12','val_12','2008-04-08','11'
-'12','val_12','2008-04-08','12'
-'12','val_12','2008-04-08','12'
-'120','val_120','2008-04-08','11'
-'120','val_120','2008-04-08','11'
-'120','val_120','2008-04-08','12'
-'120','val_120','2008-04-08','12'
-'125','val_125','2008-04-08','11'
-'125','val_125','2008-04-08','11'
-'125','val_125','2008-04-08','12'
-'125','val_125','2008-04-08','12'
-'126','val_126','2008-04-08','11'
-'126','val_126','2008-04-08','12'
-'128','val_128','2008-04-08','11'
-'128','val_128','2008-04-08','11'
-'128','val_128','2008-04-08','11'
-'128','val_128','2008-04-08','12'
-'128','val_128','2008-04-08','12'
-'128','val_128','2008-04-08','12'
-'129','val_129','2008-04-08','11'
-'129','val_129','2008-04-08','11'
-'129','val_129','2008-04-08','12'
-'129','val_129','2008-04-08','12'
-'131','val_131','2008-04-08','11'
-'131','val_131','2008-04-08','12'
-'133','val_133','2008-04-08','11'
-'133','val_133','2008-04-08','12'
-'134','val_134','2008-04-08','11'
-'134','val_134','2008-04-08','11'
-'134','val_134','2008-04-08','12'
-'134','val_134','2008-04-08','12'
-'136','val_136','2008-04-08','11'
-'136','val_136','2008-04-08','12'
-'137','val_137','2008-04-08','11'
-'137','val_137','2008-04-08','11'
-'137','val_137','2008-04-08','12'
-'137','val_137','2008-04-08','12'
-'138','val_138','2008-04-08','11'
-'138','val_138','2008-04-08','11'
-'138','val_138','2008-04-08','11'
-'138','val_138','2008-04-08','11'
-'138','val_138','2008-04-08','12'
-'138','val_138','2008-04-08','12'
-'138','val_138','2008-04-08','12'
-'138','val_138','2008-04-08','12'
-'143','val_143','2008-04-08','11'
-'143','val_143','2008-04-08','12'
-'145','val_145','2008-04-08','11'
-'145','val_145','2008-04-08','12'
-'146','val_146','2008-04-08','11'
-'146','val_146','2008-04-08','11'
-'146','val_146','2008-04-08','12'
-'146','val_146','2008-04-08','12'
-'149','val_149','2008-04-08','11'
-'149','val_149','2008-04-08','11'
-'149','val_149','2008-04-08','12'
-'149','val_149','2008-04-08','12'
-'15','val_15','2008-04-08','11'
-'15','val_15','2008-04-08','11'
-'15','val_15','2008-04-08','12'
-'15','val_15','2008-04-08','12'
-'150','val_150','2008-04-08','11'
-'150','val_150','2008-04-08','12'
-'152','val_152','2008-04-08','11'
-'152','val_152','2008-04-08','11'
-'152','val_152','2008-04-08','12'
-'152','val_152','2008-04-08','12'
-'153','val_153','2008-04-08','11'
-'153','val_153','2008-04-08','12'
-'155','val_155','2008-04-08','11'
-'155','val_155','2008-04-08','12'
-'156','val_156','2008-04-08','11'
-'156','val_156','2008-04-08','12'
-'157','val_157','2008-04-08','11'
-'157','val_157','2008-04-08','12'
-'158','val_158','2008-04-08','11'
-'158','val_158','2008-04-08','12'
-'160','val_160','2008-04-08','11'
-'160','val_160','2008-04-08','12'
-'162','val_162','2008-04-08','11'
-'162','val_162','2008-04-08','12'
-'163','val_163','2008-04-08','11'
-'163','val_163','2008-04-08','12'
-'164','val_164','2008-04-08','11'
-'164','val_164','2008-04-08','11'
-'164','val_164','2008-04-08','12'
-'164','val_164','2008-04-08','12'
-'165','val_165','2008-04-08','11'
-'165','val_165','2008-04-08','11'
-'165','val_165','2008-04-08','12'
-'165','val_165','2008-04-08','12'
-'166','val_166','2008-04-08','11'
-'166','val_166','2008-04-08','12'
-'167','val_167','2008-04-08','11'
-'167','val_167','2008-04-08','11'
-'167','val_167','2008-04-08','11'
-'167','val_167','2008-04-08','12'
-'167','val_167','2008-04-08','12'
-'167','val_167','2008-04-08','12'
-'168','val_168','2008-04-08','11'
-'168','val_168','2008-04-08','12'
-'169','val_169','2008-04-08','11'
-'169','val_169','2008-04-08','11'
-'169','val_169','2008-04-08','11'
-'169','val_169','2008-04-08','11'
-'169','val_169','2008-04-08','12'
-'169','val_169','2008-04-08','12'
-'169','val_169','2008-04-08','12'
-'169','val_169','2008-04-08','12'
-'17','val_17','2008-04-08','11'
-'17','val_17','2008-04-08','12'
-'170','val_170','2008-04-08','11'
-'170','val_170','2008-04-08','12'
-'172','val_172','2008-04-08','11'
-'172','val_172','2008-04-08','11'
-'172','val_172','2008-04-08','12'
-'172','val_172','2008-04-08','12'
-'174','val_174','2008-04-08','11'
-'174','val_174','2008-04-08','11'
-'174','val_174','2008-04-08','12'
-'174','val_174','2008-04-08','12'
-'175','val_175','2008-04-08','11'
-'175','val_175','2008-04-08','11'
-'175','val_175','2008-04-08','12'
-'175','val_175','2008-04-08','12'
-'176','val_176','2008-04-08','11'
-'176','val_176','2008-04-08','11'
-'176','val_176','2008-04-08','12'
-'176','val_176','2008-04-08','12'
-'177','val_177','2008-04-08','11'
-'177','val_177','2008-04-08','12'
-'178','val_178','2008-04-08','11'
-'178','val_178','2008-04-08','12'
-'179','val_179','2008-04-08','11'
-'179','val_179','2008-04-08','11'
-'179','val_179','2008-04-08','12'
-'179','val_179','2008-04-08','12'
-'18','val_18','2008-04-08','11'
-'18','val_18','2008-04-08','11'
-'18','val_18','2008-04-08','12'
-'18','val_18','2008-04-08','12'
-'180','val_180','2008-04-08','11'
-'180','val_180','2008-04-08','12'
-'181','val_181','2008-04-08','11'
-'181','val_181','2008-04-08','12'
-'183','val_183','2008-04-08','11'
-'183','val_183','2008-04-08','12'
-'186','val_186','2008-04-08','11'
-'186','val_186','2008-04-08','12'
-'187','val_187','2008-04-08','11'
-'187','val_187','2008-04-08','11'
-'187','val_187','2008-04-08','11'
-'187','val_187','2008-04-08','12'
-'187','val_187','2008-04-08','12'
-'187','val_187','2008-04-08','12'
-'189','val_189','2008-04-08','11'
-'189','val_189','2008-04-08','12'
-'19','val_19','2008-04-08','11'
-'19','val_19','2008-04-08','12'
-'190','val_190','2008-04-08','11'
-'190','val_190','2008-04-08','12'
-'191','val_191','2008-04-08','11'
-'191','val_191','2008-04-08','11'
-'191','val_191','2008-04-08','12'
-'191','val_191','2008-04-08','12'
-'192','val_192','2008-04-08','11'
-'192','val_192','2008-04-08','12'
-'193','val_193','2008-04-08','11'
-'193','val_193','2008-04-08','11'
-'193','val_193','2008-04-08','11'
-'193','val_193','2008-04-08','12'
-'193','val_193','2008-04-08','12'
-'193','val_193','2008-04-08','12'
-'194','val_194','2008-04-08','11'
-'194','val_194','2008-04-08','12'
-'195','val_195','2008-04-08','11'
-'195','val_195','2008-04-08','11'
-'195','val_195','2008-04-08','12'
-'195','val_195','2008-04-08','12'
-'196','val_196','2008-04-08','11'
-'196','val_196','2008-04-08','12'
-'197','val_197','2008-04-08','11'
-'197','val_197','2008-04-08','11'
-'197','val_197','2008-04-08','12'
-'197','val_197','2008-04-08','12'
-'199','val_199','2008-04-08','11'
-'199','val_199','2008-04-08','11'
-'199','val_199','2008-04-08','11'
-'199','val_199','2008-04-08','12'
-'199','val_199','2008-04-08','12'
-'199','val_199','2008-04-08','12'
-'2','val_2','2008-04-08','11'
-'2','val_2','2008-04-08','12'
-'20','val_20','2008-04-08','11'
-'20','val_20','2008-04-08','12'
-'24','val_24','2008-04-08','11'
-'24','val_24','2008-04-08','11'
-'24','val_24','2008-04-08','12'
-'24','val_24','2008-04-08','12'
-'26','val_26','2008-04-08','11'
-'26','val_26','2008-04-08','11'
-'26','val_26','2008-04-08','12'
-'26','val_26','2008-04-08','12'
-'27','val_27','2008-04-08','11'
-'27','val_27','2008-04-08','12'
-'28','val_28','2008-04-08','11'
-'28','val_28','2008-04-08','12'
-'30','val_30','2008-04-08','11'
-'30','val_30','2008-04-08','12'
-'33','val_33','2008-04-08','11'
-'33','val_33','2008-04-08','12'
-'34','val_34','2008-04-08','11'
-'34','val_34','2008-04-08','12'
-'35','val_35','2008-04-08','11'
-'35','val_35','2008-04-08','11'
-'35','val_35','2008-04-08','11'
-'35','val_35','2008-04-08','12'
-'35','val_35','2008-04-08','12'
-'35','val_35','2008-04-08','12'
-'37','val_37','2008-04-08','11'
-'37','val_37','2008-04-08','11'
-'37','val_37','2008-04-08','12'
-'37','val_37','2008-04-08','12'
-'4','val_4','2008-04-08','11'
-'4','val_4','2008-04-08','12'
-'41','val_41','2008-04-08','11'
-'41','val_41','2008-04-08','12'
-'42','val_42','2008-04-08','11'
-'42','val_42','2008-04-08','11'
-'42','val_42','2008-04-08','12'
-'42','val_42','2008-04-08','12'
-'43','val_43','2008-04-08','11'
-'43','val_43','2008-04-08','12'
-'44','val_44','2008-04-08','11'
-'44','val_44','2008-04-08','12'
-'47','val_47','2008-04-08','11'
-'47','val_47','2008-04-08','12'
-'5','val_5','2008-04-08','11'
-'5','val_5','2008-04-08','11'
-'5','val_5','2008-04-08','11'
-'5','val_5','2008-04-08','12'
-'5','val_5','2008-04-08','12'
-'5','val_5','2008-04-08','12'
-'51','val_51','2008-04-08','11'
-'51','val_51','2008-04-08','11'
-'51','val_51','2008-04-08','12'
-'51','val_51','2008-04-08','12'
-'53','val_53','2008-04-08','11'
-'53','val_53','2008-04-08','12'
-'54','val_54','2008-04-08','11'
-'54','val_54','2008-04-08','12'
-'57','val_57','2008-04-08','11'
-'57','val_57','2008-04-08','12'
-'58','val_58','2008-04-08','11'
-'58','val_58','2008-04-08','11'
-'58','val_58','2008-04-08','12'
-'58','val_58','2008-04-08','12'
-'64','val_64','2008-04-08','11'
-'64','val_64','2008-04-08','12'
-'65','val_65','2008-04-08','11'
-'65','val_65','2008-04-08','12'
-'66','val_66','2008-04-08','11'
-'66','val_66','2008-04-08','12'
-'67','val_67','2008-04-08','11'
-'67','val_67','2008-04-08','11'
-'67','val_67','2008-04-08','12'
-'67','val_67','2008-04-08','12'
-'69','val_69','2008-04-08','11'
-'69','val_69','2008-04-08','12'
-'70','val_70','2008-04-08','11'
-'70','val_70','2008-04-08','11'
-'70','val_70','2008-04-08','11'
-'70','val_70','2008-04-08','12'
-'70','val_70','2008-04-08','12'
-'70','val_70','2008-04-08','12'
-'72','val_72','2008-04-08','11'
-'72','val_72','2008-04-08','11'
-'72','val_72','2008-04-08','12'
-'72','val_72','2008-04-08','12'
-'74','val_74','2008-04-08','11'
-'74','val_74','2008-04-08','12'
-'76','val_76','2008-04-08','11'
-'76','val_76','2008-04-08','11'
-'76','val_76','2008-04-08','12'
-'76','val_76','2008-04-08','12'
-'77','val_77','2008-04-08','11'
-'77','val_77','2008-04-08','12'
-'78','val_78','2008-04-08','11'
-'78','val_78','2008-04-08','12'
-'8','val_8','2008-04-08','11'
-'8','val_8','2008-04-08','12'
-'80','val_80','2008-04-08','11'
-'80','val_80','2008-04-08','12'
-'82','val_82','2008-04-08','11'
-'82','val_82','2008-04-08','12'
-'83','val_83','2008-04-08','11'
-'83','val_83','2008-04-08','11'
-'83','val_83','2008-04-08','12'
-'83','val_83','2008-04-08','12'
-'84','val_84','2008-04-08','11'
-'84','val_84','2008-04-08','11'
-'84','val_84','2008-04-08','12'
-'84','val_84','2008-04-08','12'
-'85','val_85','2008-04-08','11'
-'85','val_85','2008-04-08','12'
-'86','val_86','2008-04-08','11'
-'86','val_86','2008-04-08','12'
-'87','val_87','2008-04-08','11'
-'87','val_87','2008-04-08','12'
-'9','val_9','2008-04-08','11'
-'9','val_9','2008-04-08','12'
-'90','val_90','2008-04-08','11'
-'90','val_90','2008-04-08','11'
-'90','val_90','2008-04-08','11'
-'90','val_90','2008-04-08','12'
-'90','val_90','2008-04-08','12'
-'90','val_90','2008-04-08','12'
-'92','val_92','2008-04-08','11'
-'92','val_92','2008-04-08','12'
-'95','val_95','2008-04-08','11'
-'95','val_95','2008-04-08','11'
-'95','val_95','2008-04-08','12'
-'95','val_95','2008-04-08','12'
-'96','val_96','2008-04-08','11'
-'96','val_96','2008-04-08','12'
-'97','val_97','2008-04-08','11'
-'97','val_97','2008-04-08','11'
-'97','val_97','2008-04-08','12'
-'97','val_97','2008-04-08','12'
-'98','val_98','2008-04-08','11'
-'98','val_98','2008-04-08','11'
-'98','val_98','2008-04-08','12'
-'98','val_98','2008-04-08','12'
-378 rows selected
->>>
->>>
->>> explain extended
-select * from srcpart a where a.ds='2008-04-08' and rand(100) < 0.1 order by a.key, a.hr;
-'Explain'
-'ABSTRACT SYNTAX TREE:'
-' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08') (< (TOK_FUNCTION rand 100) 0.1))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) hr)))))'
-''
-'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:'
-' a '
-' TableScan'
-' alias: a'
-' GatherStats: false'
-' Filter Operator'
-' isSamplingPred: false'
-' predicate:'
-' expr: (rand(100) < 0.1)'
-' type: boolean'
-' Select Operator'
-' expressions:'
-' expr: key'
-' type: string'
-' expr: value'
-' type: string'
-' expr: ds'
-' type: string'
-' expr: hr'
-' type: string'
-' outputColumnNames: _col0, _col1, _col2, _col3'
-' Reduce Output Operator'
-' key expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col3'
-' type: string'
-' sort order: ++'
-' tag: -1'
-' value expressions:'
-' expr: _col0'
-' type: string'
-' expr: _col1'
-' type: string'
-' expr: _col2'
-' type: string'
-' expr: _col3'
-' type: string'
-' Needs Tagging: false'
-' Path -> Alias:'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=11 [a]'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=12 [a]'
-' Path -> Partition:'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=11 '
-' Partition'
-' base file name: hr=11'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' partition values:'
-' ds 2008-04-08'
-' hr 11'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=11'
-' name input42.srcpart'
-' numFiles 1'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 5812'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' '
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart'
-' name input42.srcpart'
-' numFiles 4'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 23248'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' name: input42.srcpart'
-' name: input42.srcpart'
-' !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=12 '
-' Partition'
-' base file name: hr=12'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' partition values:'
-' ds 2008-04-08'
-' hr 12'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart/ds=2008-04-08/hr=12'
-' name input42.srcpart'
-' numFiles 1'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 5812'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' '
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' properties:'
-' bucket_count -1'
-' columns key,value'
-' columns.types string:string'
-' file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-' file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' location !!{hive.metastore.warehouse.dir}!!/input42.db/srcpart'
-' name input42.srcpart'
-' numFiles 4'
-' numPartitions 4'
-' numRows 0'
-' partition_columns ds/hr'
-' rawDataSize 0'
-' serialization.ddl struct srcpart { string key, string value}'
-' serialization.format 1'
-' serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' totalSize 23248'
-' transient_lastDdlTime !!UNIXTIME!!'
-' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-' name: input42.srcpart'
-' name: input42.srcpart'
-' Reduce Operator Tree:'
-' Extract'
-' File Output Operator'
-' compressed: false'
-' GlobalTableId: 0'
-' directory: file:!!{hive.exec.scratchdir}!!'
-' NumFilesPerFileSink: 1'
-' Stats Publishing Key Prefix: file:!!{hive.exec.scratchdir}!!'
-' table:'
-' input format: org.apache.hadoop.mapred.TextInputFormat'
-' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-' properties:'
-' columns _col0,_col1,_col2,_col3'
-' columns.types string:string:string:string'
-' escape.delim \'
-' serialization.format 1'
-' TotalFiles: 1'
-' GatherStats: false'
-' MultiFileSpray: false'
-''
-' Stage: Stage-0'
-' Fetch Operator'
-' limit: -1'
-''
-''
-180 rows selected
->>>
->>> select * from srcpart a where a.ds='2008-04-08' and rand(100) < 0.1 order by a.key, a.hr;
-'key','value','ds','hr'
-'113','val_113','2008-04-08','11'
-'118','val_118','2008-04-08','11'
-'12','val_12','2008-04-08','12'
-'125','val_125','2008-04-08','12'
-'128','val_128','2008-04-08','11'
-'143','val_143','2008-04-08','11'
-'143','val_143','2008-04-08','12'
-'145','val_145','2008-04-08','11'
-'149','val_149','2008-04-08','12'
-'15','val_15','2008-04-08','11'
-'15','val_15','2008-04-08','12'
-'160','val_160','2008-04-08','12'
-'164','val_164','2008-04-08','11'
-'165','val_165','2008-04-08','12'
-'166','val_166','2008-04-08','12'
-'170','val_170','2008-04-08','11'
-'176','val_176','2008-04-08','11'
-'176','val_176','2008-04-08','12'
-'181','val_181','2008-04-08','11'
-'191','val_191','2008-04-08','12'
-'195','val_195','2008-04-08','11'
-'197','val_197','2008-04-08','12'
-'199','val_199','2008-04-08','12'
-'203','val_203','2008-04-08','12'
-'216','val_216','2008-04-08','12'
-'218','val_218','2008-04-08','12'
-'223','val_223','2008-04-08','11'
-'224','val_224','2008-04-08','12'
-'237','val_237','2008-04-08','11'
-'239','val_239','2008-04-08','11'
-'242','val_242','2008-04-08','12'
-'256','val_256','2008-04-08','11'
-'256','val_256','2008-04-08','12'
-'278','val_278','2008-04-08','12'
-'288','val_288','2008-04-08','12'
-'292','val_292','2008-04-08','11'
-'298','val_298','2008-04-08','11'
-'316','val_316','2008-04-08','12'
-'325','val_325','2008-04-08','12'
-'332','val_332','2008-04-08','12'
-'34','val_34','2008-04-08','12'
-'341','val_341','2008-04-08','11'
-'348','val_348','2008-04-08','12'
-'368','val_368','2008-04-08','11'
-'369','val_369','2008-04-08','11'
-'37','val_37','2008-04-08','12'
-'394','val_394','2008-04-08','11'
-'4','val_4','2008-04-08','12'
-'400','val_400','2008-04-08','12'
-'401','val_401','2008-04-08','11'
-'402','val_402','2008-04-08','12'
-'404','val_404','2008-04-08','11'
-'406','val_406','2008-04-08','11'
-'414','val_414','2008-04-08','12'
-'417','val_417','2008-04-08','11'
-'42','val_42','2008-04-08','12'
-'424','val_424','2008-04-08','11'
-'424','val_424','2008-04-08','11'
-'424','val_424','2008-04-08','12'
-'444','val_444','2008-04-08','11'
-'444','val_444','2008-04-08','12'
-'446','val_446','2008-04-08','11'
-'453','val_453','2008-04-08','11'
-'454','val_454','2008-04-08','12'
-'455','val_455','2008-04-08','11'
-'455','val_455','2008-04-08','12'
-'466','val_466','2008-04-08','11'
-'470','val_470','2008-04-08','11'
-'472','val_472','2008-04-08','11'
-'478','val_478','2008-04-08','12'
-'483','val_483','2008-04-08','11'
-'485','val_485','2008-04-08','12'
-'487','val_487','2008-04-08','11'
-'489','val_489','2008-04-08','11'
-'489','val_489','2008-04-08','12'
-'489','val_489','2008-04-08','12'
-'489','val_489','2008-04-08','12'
-'491','val_491','2008-04-08','11'
-'492','val_492','2008-04-08','12'
-'497','val_497','2008-04-08','12'
-'53','val_53','2008-04-08','11'
-'64','val_64','2008-04-08','12'
-'65','val_65','2008-04-08','11'
-'69','val_69','2008-04-08','11'
-'70','val_70','2008-04-08','11'
-'72','val_72','2008-04-08','11'
-'76','val_76','2008-04-08','11'
-'76','val_76','2008-04-08','12'
-'78','val_78','2008-04-08','11'
-'85','val_85','2008-04-08','11'
-'92','val_92','2008-04-08','12'
-'97','val_97','2008-04-08','11'
-92 rows selected
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input43.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input43.q.out b/ql/src/test/results/beelinepositive/input43.q.out
deleted file mode 100644
index b1329ec..0000000
--- a/ql/src/test/results/beelinepositive/input43.q.out
+++ /dev/null
@@ -1,21 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input43.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input43.q
->>> drop table tst_src1;
-No rows affected
->>> create table tst_src1 like src1;
-No rows affected
->>> load data local inpath '../data/files/kv1.txt' into table tst_src1 ;
-No rows affected
->>> select count(1) from tst_src1;
-'_c0'
-'500'
-1 row selected
->>> load data local inpath '../data/files/kv1.txt' into table tst_src1 ;
-No rows affected
->>> select count(1) from tst_src1;
-'_c0'
-'1000'
-1 row selected
->>> drop table tst_src1;
-No rows affected
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input44.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input44.q.out b/ql/src/test/results/beelinepositive/input44.q.out
deleted file mode 100644
index 296e05f..0000000
--- a/ql/src/test/results/beelinepositive/input44.q.out
+++ /dev/null
@@ -1,14 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input44.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input44.q
->>> CREATE TABLE dest(key INT, value STRING) STORED AS TEXTFILE;
-No rows affected
->>>
->>> SET hive.output.file.extension=.txt;
-No rows affected
->>> INSERT OVERWRITE TABLE dest SELECT src.* FROM src;
-'_col0','_col1'
-No rows selected
->>>
->>> dfs -cat ../build/ql/test/data/warehouse/dest/*.txt;
-No rows affected
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input45.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input45.q.out b/ql/src/test/results/beelinepositive/input45.q.out
deleted file mode 100644
index 45db503..0000000
--- a/ql/src/test/results/beelinepositive/input45.q.out
+++ /dev/null
@@ -1,18 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input45.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input45.q
->>> SET hive.insert.into.multilevel.dirs=true;
-No rows affected
->>>
->>> SET hive.output.file.extension=.txt;
-No rows affected
->>>
->>> INSERT OVERWRITE DIRECTORY '../build/ql/test/data/x/y/z/' SELECT src.* FROM src;
-'key','value'
-No rows selected
->>>
->>> dfs -cat ../build/ql/test/data/x/y/z/*.txt;
-No rows affected
->>>
->>> dfs -rmr ../build/ql/test/data/x;
-No rows affected
->>> !record
http://git-wip-us.apache.org/repos/asf/hive/blob/3890ed65/ql/src/test/results/beelinepositive/input49.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/beelinepositive/input49.q.out b/ql/src/test/results/beelinepositive/input49.q.out
deleted file mode 100644
index 14ee573..0000000
--- a/ql/src/test/results/beelinepositive/input49.q.out
+++ /dev/null
@@ -1,14 +0,0 @@
-Saving all output to "!!{outputDirectory}!!/input49.q.raw". Enter "record" with no arguments to stop it.
->>> !run !!{qFileDirectory}!!/input49.q
->>> create table intable (b boolean, d double, f float, i int, l bigint, s string, t tinyint);
-No rows affected
->>> insert overwrite table intable select 0, 29098519.0, 1410.0, 996, 40408519555, "test_string", 12 from src limit 1;
-'_col0','_col1','_col2','_col3','_col4','_col5','_col6'
-No rows selected
->>> select * from intable where d in (29098519.0) and f in (1410.0) and i in (996) and l in (40408519555) and s in ('test_string') and t in (12);
-'b','d','f','i','l','s','t'
-'false','2.9098519E7','1410.0','996','40408519555','test_string','12'
-1 row selected
->>> drop table intable;
-No rows affected
->>> !record