Regarding the last one: If ?tr is not joined between the last two clauses then the final clause has to do a range scan for all :transaction/datetime
entities.
Any ideas on the hairy or-join query I am trying to do above? @whilo cc @konrad.kuehne
This is the or-join issue: https://github.com/lambdaforge/datalog-parser/issues/7
I have stumbled on this before as well, but didn't have time to dive into it.
So or-join
is corresponding to left or right joins in SQL, depending how you use it, while an inner join happens when you use ?tr
and an outer join (cartesian product) happens when you replace it by _
or some other disjoint variables.
But your or-join
only has one branch, right?
This is the one I am working on. The one below was just sharing my enjoyment for datalog š @whilo
Also above this one was another attempt to do an or join with an or pull kind of
This still has only one branch (the and
one).
I may have others where there is more.
Like I have one dataset and I want to effectively enrich it with whatever else I can find.
@whilo with the and
Iām not sure I fully undertsnad the or-join. It was basically there because I want to join the two which you can see with ?e2