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<mailto: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? [cid:image001.jpg@01D0692E.43009C70] Thanks! Xiaoyong
