Emits a Difference, which the engine has no relation function for, as a full outer join (PLAN §8.8, §11.7):
x
x_1
x_2
emitJoinRelation
x_valueDifference: x | $x.x_1->coalesce(0) - $x.x_2->coalesce(0)
select
The difference must be valid for its input schemas.
Emits a Difference, which the engine has no relation function for, as a full outer join (PLAN §8.8, §11.7):
xtox_1orx_2;emitJoinRelation);x_valueDifference: x | $x.x_1->coalesce(0) - $x.x_2->coalesce(0), so an empty value counts as 0;selectgives the columns the schema's order and drops the temporary keys.The difference must be valid for its input schemas.