Is there any alternatives for Cross join ? Apparently it is not supported yet in Drill
First, why do you really want to do this?
The reason I ask is that tools like Drill are for querying against a distributed data set and cross product joins (Cartesian Joins) in a distributed environment are not really well tolerated.
But Google is your friend.
I found this little tidbit from Ted and company about 2 yrs ago... on this topic:
Cartesian Product in Apache Drill
As mentioned in the link above, but here is a config parameter you can set to enable cross joins, but be careful on how it is used. Not sure on the latest Drill versions, but previously it did get very memory intensive on large datasets.
You can set on session or system level.
alter session set `planner.enable_nljoin_for_scalar_only` = false;
More context to the question may help to find better answers.
Retrieving data ...