hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject [04/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:17 GMT
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


Mime
View raw message