You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Our current API in both DataChain.merge() and internal DatasetQuery.join() support only inner and left outer join by setting inner flag to True or False.
We should add ability to do full outer join, as it's needed in some use cases like when comparing two chains.
Note that SQLite doesn't support full outer join out of the box, in earlier versions which we still support, so we will need to do some workaround with union all and two left joins.
The text was updated successfully, but these errors were encountered:
Our current API in both
DataChain.merge()
and internalDatasetQuery.join()
support only inner and left outer join by settinginner
flag toTrue
orFalse
.We should add ability to do full outer join, as it's needed in some use cases like when comparing two chains.
Note that SQLite doesn't support full outer join out of the box, in earlier versions which we still support, so we will need to do some workaround with union all and two left joins.
The text was updated successfully, but these errors were encountered: