The Babel parser contains the stuff that some people want to be able to parse (because it's in some other engine) but Calcite doesn't want to implement.
On Wed, May 22, 2024 at 8:16 PM JinxTheKid <logansmith...@gmail.com> wrote: > > Hi all, > > I'm exploring extensions to Calcites parser and saw that the Babel parser > impl has some nice things I want to work with, namely support for > Spark-style LEFT_SEMI_JOINs syntax. Using this parser works for me, but I > noticed that when using SqlToRelConverter, converting LEFT_SEMI_JOIN is not > implemented. This seems strange to me, since there is both a > JoinType.LEFT_SEMI_JOIN, and a RelJoinType.SEMI. I'm aware that I could > always write the query using a different syntax (EXISTS, or IN), but was > curious if there is a "Calcite way" of achieving my desired behavior before > writing my own logic. Is there a way to convert queries with > LEFT_SEMI_JOINs into a RelNode, and is this gap intentional? > > Thanks, > Logan
