SortMergeJoin only reports ordering of the join keys, not the output ordering of any child.
It seems reasonable to me that broadcast join should respect the output ordering of the children. Feel free to submit a PR to fix it, thanks! On Thu, Jun 28, 2018 at 10:07 PM 吴晓菊 <chrysan...@gmail.com> wrote: > Why we cannot use the output order of big table? > > > Chrysan Wu > Phone：+86 17717640807 > > > 2018-06-28 21:48 GMT+08:00 Marco Gaido <marcogaid...@gmail.com>: > >> The easy answer to this is that SortMergeJoin ensure an outputOrdering, >> while BroadcastHashJoin doesn't, ie. after running a BroadcastHashJoin you >> don't know which is going to be the order of the output since nothing >> enforces it. >> >> Hope this helps. >> Thanks. >> Marco >> >> 2018-06-28 15:46 GMT+02:00 吴晓菊 <chrysan...@gmail.com>: >> >>> >>> We see SortMergeJoinExec is implemented with >>> outputPartitioning&outputOrdering while BroadcastHashJoinExec is only >>> implemented with outputPartitioning. Why is the design? >>> >>> Chrysan Wu >>> Phone：+86 17717640807 >>> >>> >> >
