We are using Drill 1.6 version and trying to use Cartesian or an inequality join in drill. But drill 1.6 is not supporting and throwing exception. Can i know when is it to be supported ?
This was also covered in the drill user mail list.
Currently Drill can support these joins as a beta feature in Drill 1.6, but apparently it may consume a lot of memory.
Try this and see if it works for your use case
alter system set `planner.enable_nljoin_for_scalar_only` = false;
Retrieving data ...