> Can someone confirm it? I can confirm that the current join implementation will potentially reorder input. The larger the input the more likely the chance of reordering.
> I think that ordering is only guaranteed if it has been sorted. Close enough probably. I think there is an implicit order (the order of the defined by the files in the dataset and the rows in those files, or the original order when the input is in memory) that will be respected if there are no joins or aggregates. On Tue, Apr 16, 2024 at 8:19 AM Aldrin <octalene....@pm.me> wrote: > I think that ordering is only guaranteed if it has been sorted. > > Sent from Proton Mail <https://proton.me/mail/home> for iOS > > > On Tue, Apr 16, 2024 at 08:12, Jacek Pliszka <jacek.plis...@gmail.com > <On+Tue,+Apr+16,+2024+at+08:12,+Jacek+Pliszka+%3C%3Ca+href=>> wrote: > > Hi! > > I just hit a very strange behaviour. > > I am joining two tables with "left outer" join. > > Naively I would expect that the output rows will match the order of the > left table. > > But sometimes the order of rows is different ... > > Can someone confirm it? > > I would expect this would be mentioned in the docs. > > I am using 12.0.1 due to Python 3.7 dependency. > > Best Regards, > > Jacek Pliszka > > > >
