Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9FF5EEC8B for ; Wed, 16 Jan 2013 19:01:03 +0000 (UTC) Received: (qmail 2305 invoked by uid 500); 16 Jan 2013 19:01:03 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 2179 invoked by uid 500); 16 Jan 2013 19:01:03 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 2162 invoked by uid 99); 16 Jan 2013 19:01:03 -0000 Received: from reviews-vm.apache.org (HELO reviews.apache.org) (140.211.11.40) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jan 2013 19:01:03 +0000 Received: from reviews.apache.org (localhost [127.0.0.1]) by reviews.apache.org (Postfix) with ESMTP id 8DD811C62E1; Wed, 16 Jan 2013 19:00:50 +0000 (UTC) Content-Type: multipart/alternative; boundary="===============8592844177677918033==" MIME-Version: 1.0 Subject: Re: Review Request: HIVE-2206: add a new optimizer for query correlation discovery and optimization From: "Yin Huai" To: "Yin Huai" , "Ashutosh Chauhan" , "hive" , "Carl Steinbach" Date: Wed, 16 Jan 2013 19:00:49 -0000 Message-ID: <20130116190049.29538.27709@reviews.apache.org> X-ReviewBoard-URL: https://reviews.apache.org Auto-Submitted: auto-generated Sender: "Yin Huai" X-ReviewGroup: hive X-ReviewRequest-URL: https://reviews.apache.org/r/7126/ X-Sender: "Yin Huai" References: <20121119195117.3328.65766@reviews.apache.org> In-Reply-To: <20121119195117.3328.65766@reviews.apache.org> Reply-To: "Yin Huai" --===============8592844177677918033== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/7126/ ----------------------------------------------------------- (Updated Jan. 16, 2013, 7 p.m.) Review request for hive. Description ------- This optimizer exploits intra-query correlations and merges multiple correl= ated MapReduce jobs into one jobs. Open a new request since I have been wor= king on hive-git. This addresses bug HIVE-2206. https://issues.apache.org/jira/browse/HIVE-2206 Diffs (updated) ----- common/src/java/org/apache/hadoop/hive/conf/HiveConf.java 15fce1e = conf/hive-default.xml.template cdc1afd = ql/if/queryplan.thrift 4427929 = ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/Operato= rType.java 7c4c413 = ql/src/java/org/apache/hadoop/hive/ql/exec/BaseReduceSinkOperator.java PR= E-CREATION = ql/src/java/org/apache/hadoop/hive/ql/exec/CorrelationCompositeOperator.j= ava PRE-CREATION = ql/src/java/org/apache/hadoop/hive/ql/exec/CorrelationLocalSimulativeRedu= ceSinkOperator.java PRE-CREATION = ql/src/java/org/apache/hadoop/hive/ql/exec/CorrelationReducerDispatchOper= ator.java PRE-CREATION = ql/src/java/org/apache/hadoop/hive/ql/exec/ExecReducer.java 18a9bd2 = ql/src/java/org/apache/hadoop/hive/ql/exec/GroupByOperator.java 7f9ad24 = ql/src/java/org/apache/hadoop/hive/ql/exec/Operator.java 68302f8 = ql/src/java/org/apache/hadoop/hive/ql/exec/OperatorFactory.java 69fff0e = ql/src/java/org/apache/hadoop/hive/ql/exec/ReduceSinkOperator.java 919a14= 0 = ql/src/java/org/apache/hadoop/hive/ql/exec/TableScanOperator.java 18b5540 = ql/src/java/org/apache/hadoop/hive/ql/optimizer/CorrelationOptimizer.java= PRE-CREATION = ql/src/java/org/apache/hadoop/hive/ql/optimizer/CorrelationOptimizerUtils= .java PRE-CREATION = ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMapRedUtils.java 09f81= 39 = ql/src/java/org/apache/hadoop/hive/ql/optimizer/Optimizer.java d1555e2 = ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/CommonJoinResolv= er.java 2f5140a = ql/src/java/org/apache/hadoop/hive/ql/parse/ParseContext.java cb43d84 = ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 3df029f = ql/src/java/org/apache/hadoop/hive/ql/plan/BaseReduceSinkDesc.java PRE-CR= EATION = ql/src/java/org/apache/hadoop/hive/ql/plan/CorrelationCompositeDesc.java = PRE-CREATION = ql/src/java/org/apache/hadoop/hive/ql/plan/CorrelationLocalSimulativeRedu= ceSinkDesc.java PRE-CREATION = ql/src/java/org/apache/hadoop/hive/ql/plan/CorrelationReducerDispatchDesc= .java PRE-CREATION = ql/src/java/org/apache/hadoop/hive/ql/plan/MapredWork.java 9ac7d8c = ql/src/java/org/apache/hadoop/hive/ql/plan/ReduceSinkDesc.java b33d616 = ql/src/java/org/apache/hadoop/hive/ql/plan/TableScanDesc.java 9cbb2e6 = ql/src/test/org/apache/hadoop/hive/ql/exec/TestExecDriver.java 6f8bc47 = ql/src/test/queries/clientpositive/correlationoptimizer1.q PRE-CREATION = ql/src/test/queries/clientpositive/correlationoptimizer2.q PRE-CREATION = ql/src/test/queries/clientpositive/correlationoptimizer3.q PRE-CREATION = ql/src/test/queries/clientpositive/correlationoptimizer4.q PRE-CREATION = ql/src/test/queries/clientpositive/correlationoptimizer5.q PRE-CREATION = ql/src/test/results/clientpositive/correlationoptimizer1.q.out PRE-CREATI= ON = ql/src/test/results/clientpositive/correlationoptimizer2.q.out PRE-CREATI= ON = ql/src/test/results/clientpositive/correlationoptimizer3.q.out PRE-CREATI= ON = ql/src/test/results/clientpositive/correlationoptimizer4.q.out PRE-CREATI= ON = ql/src/test/results/clientpositive/correlationoptimizer5.q.out PRE-CREATI= ON = ql/src/test/results/compiler/plan/groupby1.q.xml f38ae1f = ql/src/test/results/compiler/plan/groupby2.q.xml 72bd2ff = ql/src/test/results/compiler/plan/groupby3.q.xml e62439a = ql/src/test/results/compiler/plan/groupby5.q.xml 632d88e = Diff: https://reviews.apache.org/r/7126/diff/ Testing ------- All tests pass. Thanks, Yin Huai --===============8592844177677918033==--