You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/05/12 07:56:59 UTC

[17/25] drill git commit: add Aman's info about broadcast

add Aman's info about broadcast


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/029d411f
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/029d411f
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/029d411f

Branch: refs/heads/gh-pages
Commit: 029d411fc0e39e33c5bebfb06714b3d203fb48be
Parents: 598be28
Author: Kristine Hahn <kh...@maprtech.com>
Authored: Sat May 9 12:39:32 2015 -0700
Committer: Kristine Hahn <kh...@maprtech.com>
Committed: Sat May 9 12:39:32 2015 -0700

----------------------------------------------------------------------
 .../010-configuration-options-introduction.md                      | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/029d411f/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md b/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md
index 8443036..c26dd6b 100644
--- a/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md
+++ b/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md
@@ -34,7 +34,7 @@ The sys.options table lists the following options that you can set at the sessio
 | planner.broadcast_factor                       | 1          |                                                                                                                                                                                                                                                                                                                                                                  |
 | planner.broadcast_threshold                    | 10000000   | The maximum number of records allowed to be broadcast as part of a query. After one million records, Drill reshuffles data rather than doing a broadcast to one side of the join. Range: 0-2147483647                                                                                                                                                            |
 | planner.disable_exchanges                      | FALSE      | Toggles the state of hashing to a random exchange.                                                                                                                                                                                                                                                                                                               |
-| planner.enable_broadcast_join                  | TRUE       | Changes the state of aggregation and join operators. Do not disable.                                                                                                                                                                                                                                                                                             |
+| planner.enable_broadcast_join                  | TRUE       | Changes the state of aggregation and join operators. The broadcast join can be used for hash join, merge join and nested loop join. Broadcast join is very useful in situations where a large (fact) table is being joined to relatively smaller (dimension) tables. Do not disable.                                                                             |
 | planner.enable_constant_folding                | TRUE       |                                                                                                                                                                                                                                                                                                                                                                  |
 | planner.enable_demux_exchange                  | FALSE      | Toggles the state of hashing to a demulitplexed exchange.                                                                                                                                                                                                                                                                                                        |
 | planner.enable_hash_single_key                 | TRUE       |                                                                                                                                                                                                                                                                                                                                                                  |