Github user parthchandra commented on the issue:
https://github.com/apache/drill/pull/1224
@vvysotskyi The lateral join implementation committed in DRILL-6323
supports cross join for all conditions. The main difficulty in cross join is
the management of the memory needed to produce a cartesian product (M x N). In
cross apply though, the cross join is only computed on one row in the left side
at a time (1 x N), since the left and right sides are correlated. This allows
cross apply to operate with a very small amount of memory.
---
