hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chao Sun" <chao....@cloudera.com>
Subject Review Request 29111: HIVE-9041 - Generate better plan for queries containing both union and multi-insert [Spark Branch]
Date Tue, 16 Dec 2014 19:02:33 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/29111/
-----------------------------------------------------------

Review request for hive and Xuefu Zhang.


Bugs: HIVE-9041
    https://issues.apache.org/jira/browse/HIVE-9041


Repository: hive-git


Description
-------

This JIRA removes UnionWork from Spark plan.

UnionWork right now is just a dummy work - in execution, it is translated to IdentityTran,
which does nothing.
The actually union operation is implemented with rdd.union, which happens when a BaseWork
has multiple parent BaseWorks. For instance:

     MW_1    MW_2
        \    /
         \  /
         RW_1
         
In this case, MW_1 and MW_2 both translates to RDD_1 and RDD_2, and then we create another
RDD_3 which is the
result of rdd.union(RDD_1, RDD_2). We then create RDD_4 for RW_1, whose parent is RDD_3.

*Changes on GenSparkWork*

To remove the UnionWork, most changes are in GenSparkWork. I got rid of a chunk of code that
creates UnionWork and link the work with parent works. But, I still kept `currentUnionOperators`
and `workWithUnionOperators`, since they are needed for removing union operators later.

I also changed how `followingWork` is handled. This happens when we have the following operator
tree:

         TS_0      TS_1
           \       /
            \     /
             UNION_2
              /
             RS_3
            /
           FS_4
           
(You can see that I ignored quite a few operators here. They are not required to illustrate
the problem)

In this plan, we will reach `RS_3` via two different paths: `TS_0` and `TS_1`.
The first time we get to `RS_3`, say via `TS_0`, we would break `RS_3` with its child, and
create a work
for the path `TS_0 -> UNION_2 -> RS_3`. Let's say the work is `MW_1`.

We then proceed to `FS_4`, create another ReduceWork `RW_2` for it, and link `RW_2` with `MW_1`.
We then will visit to `RS_3` for the second time, from `TS_1`, and create another work for
the path
`TS_1 -> UNION_2 -> RS_3`, say `MW_3`.

But, the problem is that `RS_3` is already disconnected with `FS_4`. In order to link `MW_3`
with `RW_2`,
we need to save that information somewhere.

This is why we need `leafOpToChildWorkInfo`. It is actually changed from `leafOpToFollowingWork`.
But, I found that we also need to have the edge property between `RS_3` and its child saved,
in order to connect.

I also encountered a case where two BaseWorks may be connected twice. I've explained that
in the comments for the source code.

*Changes on SparkPlanGenerator*

Without UnionWork, SparkPlanGenerator can be a bit cleaner. The changes on this class are
mostly refactoring.
I got rid of some redundant code in `generate(SparkWork)` method, and combined `generate(MapWork)`
and `generate(ReduceWork)` into one.


Diffs
-----

  ql/src/java/org/apache/hadoop/hive/ql/exec/spark/IdentityTran.java eb758e09888d7864acc9d88c7186ae2de48bc8f7

  ql/src/java/org/apache/hadoop/hive/ql/exec/spark/SparkPlanGenerator.java 438efabb062112da8fefc1bed9d8bd90ade26c67

  ql/src/java/org/apache/hadoop/hive/ql/optimizer/spark/SparkReduceSinkMapJoinProc.java 78cbc6d2eebef5b8edc10fe693a1b580a6ee389c

  ql/src/java/org/apache/hadoop/hive/ql/parse/spark/GenSparkProcContext.java ad6b09be83a33c0cd97ab9c3bc7d02adb928f1f3

  ql/src/java/org/apache/hadoop/hive/ql/parse/spark/GenSparkUtils.java 654ba333969cacaafddec38c3c3f45ccb4b81d4a

  ql/src/java/org/apache/hadoop/hive/ql/parse/spark/GenSparkWork.java 137df65d2bb2de20bca06e47b9e1386ddf511c68

  ql/src/test/results/clientpositive/spark/auto_join27.q.out fb48351bea5df3a19c14c755eb3a3fbb7f503e61

  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_10.q.out 8472df914b8f5bdcb7974fc6689313d33975a4ad

  ql/src/test/results/clientpositive/spark/column_access_stats.q.out 72b2bd7e9b48033ca9cb1bd96facad42f12b6450

  ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 1757d16a736741f90c5d84b7a0cc0c168cb7d3ad

  ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 04f481d4a304fdc8a86e8cfd305899084bab2e8d

  ql/src/test/results/clientpositive/spark/join34.q.out 9a58a228002a2b704541dfed1c713b3880e71f35

  ql/src/test/results/clientpositive/spark/join35.q.out 851a98128dca74f0008c20faf717d3cc974150e0

  ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out 92693e69a08d1ab2ea0c019f2b7f0634316d1eaf

  ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out 060745dcc80d69b5d17101c2641c228b949c2fb8

  ql/src/test/results/clientpositive/spark/multi_insert.q.out 0a38beab815fb50fbb991d6228f48bb02b009998

  ql/src/test/results/clientpositive/spark/multi_insert_move_tasks_share_dependencies.q.out
639f4bd729587ce21b509bd8e3595107c0cf71bc 
  ql/src/test/results/clientpositive/spark/multi_join_union.q.out d8dc110c3562e5c1e925553df86fba8ceda55b4a

  ql/src/test/results/clientpositive/spark/skewjoin_union_remove_1.q.out db92598ecaba27bd95c8134c1e887cb35e5049ae

  ql/src/test/results/clientpositive/spark/skewjoin_union_remove_2.q.out bbe60a72833aae4530336565dfdfb187c86bd9b9

  ql/src/test/results/clientpositive/spark/skewjoinopt1.q.out c3d550b09779fa1488fbd558ca7d74e1f54fe7e3

  ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out 4bb908ad72bc6a6fb1d3ef86a398bcf6b8191377

  ql/src/test/results/clientpositive/spark/skewjoinopt11.q.out bb1111a9f10d59621eb2347c25487ed5fd367506

  ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 468139cfb9da1d80ac56dfdc841ea25efebd7662

  ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out b3dcb0abd61e9bad100d81e8734275484a86c768

  ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out e62e886bda9e15d593b11dc3a9818b53bf716ca4

  ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 771b16ec1b44a386bbeca8013b95d6e2e56cb1e2

  ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out f59f1e48e9d6d410c0b227a142c8ea5e28b3a50e

  ql/src/test/results/clientpositive/spark/skewjoinopt19.q.out bac15f62eec9a83f4fda38d4f2d836752971a22c

  ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out f6a47de50f86ee03eba2edd92d67ecda09ecaef2

  ql/src/test/results/clientpositive/spark/skewjoinopt20.q.out 4150c23d09bf6942eafe2061acc537e41ceb4a79

  ql/src/test/results/clientpositive/spark/skewjoinopt3.q.out 5640384a8f27932c8427dfb18af48351399d617c

  ql/src/test/results/clientpositive/spark/skewjoinopt4.q.out 353e1b8e7d6fa7cdd797f4fec9dff6a68df74267

  ql/src/test/results/clientpositive/spark/skewjoinopt5.q.out 4fe594c41bdf51aa2b844100518eb6ed20659cf5

  ql/src/test/results/clientpositive/spark/skewjoinopt6.q.out fc1e81ca8c901320d09444ad4e6f41a9c1aa5d8f

  ql/src/test/results/clientpositive/spark/skewjoinopt7.q.out f76ebbd214f190fb34ff532de827af1819e78769

  ql/src/test/results/clientpositive/spark/skewjoinopt8.q.out 466d70e167334400401e345a6239eca25c0077db

  ql/src/test/results/clientpositive/spark/skewjoinopt9.q.out bc0b1f74428d63c14738f9615f99771b9283abc3

  ql/src/test/results/clientpositive/spark/stats1.q.out ba22d9a8732023c3e28b7498bd68f3632a5b7404

  ql/src/test/results/clientpositive/spark/temp_table.q.out feb7711c59e6c226ac7c66c45858106b362c1f99

  ql/src/test/results/clientpositive/spark/union.q.out 7d8d452824aeefbefec0797927084842281ac340

  ql/src/test/results/clientpositive/spark/union10.q.out 40a43c6c61f2dea939e4e0966aff7f372074a9b8

  ql/src/test/results/clientpositive/spark/union11.q.out 068f7dc28e178117f24606a5841a46fc874162f0

  ql/src/test/results/clientpositive/spark/union13.q.out 27de88bec6401e591c1c6ef195dd4f522190268e

  ql/src/test/results/clientpositive/spark/union14.q.out 47f4ac1b7ecaec156a76e7691b8ffff77b9252a7

  ql/src/test/results/clientpositive/spark/union15.q.out 487fe534edbf0be13071f53837fe2bcceaf0295b

  ql/src/test/results/clientpositive/spark/union16.q.out c35ed10915ec8439e9b955ba99b21985e6b2dd41

  ql/src/test/results/clientpositive/spark/union18.q.out d2bcd704df3f5c12f53ee6d141ffa6417178d48e

  ql/src/test/results/clientpositive/spark/union19.q.out 13fb395bc15a23ed06a9cfa24ab5893a00b4d7f3

  ql/src/test/results/clientpositive/spark/union2.q.out da8d154bb21089b3d4ab7a671a3f5310fab167c3

  ql/src/test/results/clientpositive/spark/union23.q.out 606153aa66129c4677c0e8226c5ae3e6999e6328

  ql/src/test/results/clientpositive/spark/union25.q.out c439b1ae722b26c3e6659ad82840bc23d221e496

  ql/src/test/results/clientpositive/spark/union28.q.out b478a779d0d76cff7a3cd6397e2c39a5efeb57a4

  ql/src/test/results/clientpositive/spark/union29.q.out da224560cc65fcfdf0135381477a0c1a2017f471

  ql/src/test/results/clientpositive/spark/union3.q.out 8240654b75ab52120744d14876855cf97a860cc0

  ql/src/test/results/clientpositive/spark/union30.q.out c4eeb8d358246031b6699a766a8f604d0836feb3

  ql/src/test/results/clientpositive/spark/union33.q.out b5a3f99645fcc542f69e95026412dde8e0e3979a

  ql/src/test/results/clientpositive/spark/union4.q.out 255df7608a2b96633ba0d99af787f49b539a3147

  ql/src/test/results/clientpositive/spark/union5.q.out 2d8a3c446709c24ebefd964d54e8d0ac8506ab5e

  ql/src/test/results/clientpositive/spark/union6.q.out eb1c75140c43d6794a662fb7f573eebb19cfd6cc

  ql/src/test/results/clientpositive/spark/union7.q.out 5fb37da43d6b90129c76d2c9cab467f5f5ba71f5

  ql/src/test/results/clientpositive/spark/union8.q.out 4e5cec5c5a2a890c2ae98d2dbd106cb5968a39b6

  ql/src/test/results/clientpositive/spark/union9.q.out db144777ef9fdbe9d696b196e6dd16ceb1b9201b

  ql/src/test/results/clientpositive/spark/union_ppr.q.out b90795387f7747f95697adf785bdc4b71e5e84f4

  ql/src/test/results/clientpositive/spark/union_remove_1.q.out be6e0e907bf5f3d3a3b7b52dcaa6a1a6fc4da1f6

  ql/src/test/results/clientpositive/spark/union_remove_10.q.out 98cad44600f0b711a1644fdc5e54ed94d4c59a3e

  ql/src/test/results/clientpositive/spark/union_remove_11.q.out 4accb54e696514749596917b3c3950b7a42c3a97

  ql/src/test/results/clientpositive/spark/union_remove_15.q.out e7b2cd9ca67a8472d3f4045c3e2c41a691c12358

  ql/src/test/results/clientpositive/spark/union_remove_16.q.out 88387284dd92b3c42a26340ce4ab93e0466d430e

  ql/src/test/results/clientpositive/spark/union_remove_17.q.out 823cbafae8d629c4dba235c27b81fdc6bab0da32

  ql/src/test/results/clientpositive/spark/union_remove_18.q.out 28f1b003c7c174814449a2f3d7c93797d793419d

  ql/src/test/results/clientpositive/spark/union_remove_19.q.out 301aad4bb8731936ebf548bc8f9ff776bd217c16

  ql/src/test/results/clientpositive/spark/union_remove_2.q.out 2b05b7be6e46835be703d6fec95b16795400948e

  ql/src/test/results/clientpositive/spark/union_remove_20.q.out c67f47bd011883906366ffa8e743533345c07310

  ql/src/test/results/clientpositive/spark/union_remove_21.q.out 6b119bad2bd236cdd4bcdb2ff6c3deac148c983e

  ql/src/test/results/clientpositive/spark/union_remove_24.q.out 5ed88b4a9d36d4a15be0b3ec0931511753798820

  ql/src/test/results/clientpositive/spark/union_remove_25.q.out 944508042007fb6541fc65c5840a40791054c217

  ql/src/test/results/clientpositive/spark/union_remove_3.q.out 09b8636184595d665696ed0f6b129012e0a32589

  ql/src/test/results/clientpositive/spark/union_remove_4.q.out 65d2aa14aae6877077d85d09580311fede1f97ce

  ql/src/test/results/clientpositive/spark/union_remove_5.q.out 41271b2b0d70ec7c92bde69942ec1d66880525a7

  ql/src/test/results/clientpositive/spark/union_remove_6.q.out d7cd40ba54714fd34297e3587961313815dc1f51

  ql/src/test/results/clientpositive/spark/union_remove_7.q.out b3be93218fe4d874e4604c4c73b8980de8c0baa4

  ql/src/test/results/clientpositive/spark/union_remove_8.q.out 8773535e628176706ecf91ecafb8da4d190c744a

  ql/src/test/results/clientpositive/spark/union_remove_9.q.out 8dc6dd840b3cfb08e22aa9c362454b393443b209


Diff: https://reviews.apache.org/r/29111/diff/


Testing
-------

I tested this patch with all tests under ql/src/test/results/clientpositive/spark.
Some outputs changed:

ql/src/test/results/clientpositive/spark/auto_join27.q.out
ql/src/test/results/clientpositive/spark/auto_sortmerge_join_10.q.out
ql/src/test/results/clientpositive/spark/column_access_stats.q.out
ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out
ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out
ql/src/test/results/clientpositive/spark/join34.q.out
ql/src/test/results/clientpositive/spark/join35.q.out
ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out
ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out
ql/src/test/results/clientpositive/spark/multi_insert.q.out
ql/src/test/results/clientpositive/spark/multi_insert_move_tasks_share_dependencies.q.out
ql/src/test/results/clientpositive/spark/multi_join_union.q.out
ql/src/test/results/clientpositive/spark/skewjoin_union_remove_1.q.out
ql/src/test/results/clientpositive/spark/skewjoin_union_remove_2.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt1.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt11.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt19.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt20.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt3.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt4.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt5.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt6.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt7.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt8.q.out
ql/src/test/results/clientpositive/spark/skewjoinopt9.q.out
ql/src/test/results/clientpositive/spark/stats1.q.out
ql/src/test/results/clientpositive/spark/temp_table.q.out
ql/src/test/results/clientpositive/spark/union.q.out
ql/src/test/results/clientpositive/spark/union10.q.out
ql/src/test/results/clientpositive/spark/union11.q.out
ql/src/test/results/clientpositive/spark/union13.q.out
ql/src/test/results/clientpositive/spark/union14.q.out
ql/src/test/results/clientpositive/spark/union15.q.out
ql/src/test/results/clientpositive/spark/union16.q.out
ql/src/test/results/clientpositive/spark/union18.q.out
ql/src/test/results/clientpositive/spark/union19.q.out
ql/src/test/results/clientpositive/spark/union2.q.out
ql/src/test/results/clientpositive/spark/union23.q.out
ql/src/test/results/clientpositive/spark/union25.q.out
ql/src/test/results/clientpositive/spark/union28.q.out
ql/src/test/results/clientpositive/spark/union29.q.out
ql/src/test/results/clientpositive/spark/union3.q.out
ql/src/test/results/clientpositive/spark/union30.q.out
ql/src/test/results/clientpositive/spark/union33.q.out
ql/src/test/results/clientpositive/spark/union4.q.out
ql/src/test/results/clientpositive/spark/union5.q.out
ql/src/test/results/clientpositive/spark/union6.q.out
ql/src/test/results/clientpositive/spark/union7.q.out
ql/src/test/results/clientpositive/spark/union8.q.out
ql/src/test/results/clientpositive/spark/union9.q.out
ql/src/test/results/clientpositive/spark/union_ppr.q.out
ql/src/test/results/clientpositive/spark/union_remove_1.q.out
ql/src/test/results/clientpositive/spark/union_remove_10.q.out
ql/src/test/results/clientpositive/spark/union_remove_11.q.out
ql/src/test/results/clientpositive/spark/union_remove_15.q.out
ql/src/test/results/clientpositive/spark/union_remove_16.q.out
ql/src/test/results/clientpositive/spark/union_remove_17.q.out
ql/src/test/results/clientpositive/spark/union_remove_18.q.out
ql/src/test/results/clientpositive/spark/union_remove_19.q.out
ql/src/test/results/clientpositive/spark/union_remove_2.q.out
ql/src/test/results/clientpositive/spark/union_remove_20.q.out
ql/src/test/results/clientpositive/spark/union_remove_21.q.out
ql/src/test/results/clientpositive/spark/union_remove_24.q.out
ql/src/test/results/clientpositive/spark/union_remove_25.q.out
ql/src/test/results/clientpositive/spark/union_remove_3.q.out
ql/src/test/results/clientpositive/spark/union_remove_4.q.out
ql/src/test/results/clientpositive/spark/union_remove_5.q.out
ql/src/test/results/clientpositive/spark/union_remove_6.q.out
ql/src/test/results/clientpositive/spark/union_remove_7.q.out
ql/src/test/results/clientpositive/spark/union_remove_8.q.out
ql/src/test/results/clientpositive/spark/union_remove_9.q.out


Thanks,

Chao Sun


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message