Hello Ihor, I am not clear on the mentioned goal of this JIRA. Can you please clarify on this using some examples. "But main goal of this task is to allow explicit cross joins in queries when option is enabled and at the same time disallow other ways to execute cross joins (for example, list tables via comma in FROM section of query without condition) while option is enabled. " At-least from what I understand regarding the support of cross joins, is to enable the cross join whenever a comma separated syntax without conditions are also enabled. Currently cross join is not supported at all.
It's support should be similar to that of comma separated query syntax without conditions. Thanks, -Hanu On Thu, Sep 27, 2018 at 10:14 AM Ihor Huzenko <[email protected]> wrote: > Dear Drillers, > > I'm trying to implement support for CROSS JOIN syntax in Apache Drill. > But after long investigation I finally run out of ideas and don't see > proper way > how this could be implemented without changes to Calcite. I'm new to Drill > and > Calcite and I would appreciate any help. Please, take a look at my comment > under the issue https://issues.apache.org/jira/browse/DRILL-786. > > Thank you in advance, Igor Guzenko >
