Hi highly suspect that that the outer joins are not correct because they don't call the related sparkR primitives.