Looks good. Thanks for doing this. Minor point:
Rule 1: During QBJoinTree construction in Plan Gen, the parse Join Condition logic applies this rule. Rule 2: During JoinPPD (Join Predicate Pushdown) the get Qualified Alias logic applies this rule. FYI 'parseJoinCondition' and 'getQualifiedAlias' are methods in the SemanticAnalyzer and JoinPPD classes respectively. Writing these as separate words maybe confusing. You are better judge of how to represent this(quoted/bold etc.) regards, Harish. On Dec 9, 2013, at 1:52 AM, Lefty Leverenz <leftylever...@gmail.com> wrote: > The Outer Join Behavior > wikidoc<https://cwiki.apache.org/confluence/display/Hive/OuterJoinBehavior>is > done, with links from the Design > Docs <https://cwiki.apache.org/confluence/display/Hive/DesignDocs> page and > the Joins > doc<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins#LanguageManualJoins-JoinOptimization> > . > > Harish (or anyone else) would you please review the changes I made to > the definition > for "Null Supplying > table"<https://cwiki.apache.org/confluence/display/Hive/OuterJoinBehavior#OuterJoinBehavior-Definitions> > ? > > -- Lefty > > > On Mon, Dec 2, 2013 at 6:46 PM, Thejas Nair <the...@hortonworks.com> wrote: > >> :) >> >> >> On Mon, Dec 2, 2013 at 6:18 PM, Lefty Leverenz <leftylever...@gmail.com> >> wrote: >>> Easy as 3.14159.... (I can take a hint.) >>> >>> -- Lefty >>> >>> >>> On Mon, Dec 2, 2013 at 5:34 PM, Thejas Nair <the...@hortonworks.com> >> wrote: >>> >>>> FYI, Harish has a written a very nice doc describing predicate push >>>> down rules for join. I have attached it to the design doc page. It >>>> will be very useful for anyone looking at joins. >>>> >>>> >> https://cwiki.apache.org/confluence/download/attachments/27362075/OuterJoinBehavior.html >>>> >>>> (any help converting it to wiki format from html is welcome!). >>>> >>>> -- >>>> CONFIDENTIALITY NOTICE >>>> NOTICE: This message is intended for the use of the individual or >> entity to >>>> which it is addressed and may contain information that is confidential, >>>> privileged and exempt from disclosure under applicable law. If the >> reader >>>> of this message is not the intended recipient, you are hereby notified >> that >>>> any printing, copying, dissemination, distribution, disclosure or >>>> forwarding of this communication is strictly prohibited. If you have >>>> received this communication in error, please contact the sender >> immediately >>>> and delete it from your system. Thank You. >>>> >> >> -- >> CONFIDENTIALITY NOTICE >> NOTICE: This message is intended for the use of the individual or entity to >> which it is addressed and may contain information that is confidential, >> privileged and exempt from disclosure under applicable law. If the reader >> of this message is not the intended recipient, you are hereby notified that >> any printing, copying, dissemination, distribution, disclosure or >> forwarding of this communication is strictly prohibited. If you have >> received this communication in error, please contact the sender immediately >> and delete it from your system. Thank You. >> -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.