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

Reply via email to