Thanks Xiaoyong Zhu and Prasanth Jayachandran, I've added this information to the wiki in EXPLAIN Syntax <https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=27362037#LanguageManualExplain-EXPLAINSyntax> after the example stage plans.
-- Lefty On Fri, Mar 27, 2015 at 8:07 PM, Xiaoyong Zhu <xiaoy...@microsoft.com> wrote: > Thanks for the clarification! > > > > Xiaoyong > > > > *From:* Prasanth Jayachandran [mailto:pjayachand...@hortonworks.com] > *Sent:* Saturday, March 28, 2015 1:02 AM > *To:* user@hive.apache.org; user@hive.apache.org > *Subject:* Re: Sort order in Hive plan? > > > > Hi > > > > In the image that you had posted. There are 4 plus signs which means > sorting happens on all four columns in key expression. Number of plus signs > indicate the number of columns in key expressions that are used for > sorting. Also minus sign indicate that sorting happens in descending order. > > > Thanks > Prasanth > > > > > > On Fri, Mar 27, 2015 at 6:43 AM -0700, "Xiaoyong Zhu" < > xiaoy...@microsoft.com> wrote: > > Hi experts > > > > When I am viewing the Hive plans, I notice that in Reduce Output > Operators, there is a “property” named “sort order” and it’s value is “+++” > – may I know what’s the meaning of the three plus signs? Sometime I also > see one plus sign… > > Is there any document talking about this? Or where could I refer to the > code? > > > > Thanks! > > > > Xiaoyong > > >
