Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # dev >> Re: Review Request: HIVE-2206: add a new optimizer for query correlation discovery and optimization


+
Yin Huai 2013-01-16, 03:19
+
Ashutosh Chauhan 2013-01-13, 01:00
Copy link to this message
-
Re: Review Request: HIVE-2206: add a new optimizer for query correlation discovery and optimization

-----------------------------------------------------------
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 correlated MapReduce jobs into one jobs. Open a new request since I have been working 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/OperatorType.java 7c4c413
  ql/src/java/org/apache/hadoop/hive/ql/exec/BaseReduceSinkOperator.java PRE-CREATION
  ql/src/java/org/apache/hadoop/hive/ql/exec/CorrelationCompositeOperator.java PRE-CREATION
  ql/src/java/org/apache/hadoop/hive/ql/exec/CorrelationLocalSimulativeReduceSinkOperator.java PRE-CREATION
  ql/src/java/org/apache/hadoop/hive/ql/exec/CorrelationReducerDispatchOperator.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 919a140
  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 09f8139
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/Optimizer.java d1555e2
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/CommonJoinResolver.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-CREATION
  ql/src/java/org/apache/hadoop/hive/ql/plan/CorrelationCompositeDesc.java PRE-CREATION
  ql/src/java/org/apache/hadoop/hive/ql/plan/CorrelationLocalSimulativeReduceSinkDesc.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-CREATION
  ql/src/test/results/clientpositive/correlationoptimizer2.q.out PRE-CREATION
  ql/src/test/results/clientpositive/correlationoptimizer3.q.out PRE-CREATION
  ql/src/test/results/clientpositive/correlationoptimizer4.q.out PRE-CREATION
  ql/src/test/results/clientpositive/correlationoptimizer5.q.out PRE-CREATION
  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