Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 69613200C10 for ; Fri, 3 Feb 2017 22:50:19 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 64AA1160B71; Fri, 3 Feb 2017 21:50:19 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 16F8B160B3F for ; Fri, 3 Feb 2017 22:50:16 +0100 (CET) Received: (qmail 27669 invoked by uid 500); 3 Feb 2017 21:50:15 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 27461 invoked by uid 99); 3 Feb 2017 21:50:15 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Feb 2017 21:50:15 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id F0815E0A6B; Fri, 3 Feb 2017 21:50:14 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: gunther@apache.org To: commits@hive.apache.org Date: Fri, 03 Feb 2017 21:50:17 -0000 Message-Id: <702e9767cc684e2cb6bdad4cc17e1a85@git.apache.org> In-Reply-To: References: X-Mailer: ASF-Git Admin Mailer Subject: [04/51] [partial] hive git commit: HIVE-15790: Remove unused beeline golden files (Gunther Hagleitner, reviewed by Sergey Shelukhin) archived-at: Fri, 03 Feb 2017 21:50:19 -0000 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