RE: Re: CoreFilters.FILTER_REDUCE_EXPRESSIONS issue

2024-05-22 Thread jeffreywinter
> You say that >… > isn't valid SQL. What's wrong with it? It looks valid and correct to > me. Right, this was phrased poorly. I assume this is valid ANSI SQL, but it is not for the versions of Oracle and SQL Server I’m currently working with. To this point I haven’t run into any issues with

[jira] [Created] (CALCITE-6415) Invalid unparse for TIMESTAMP with HiveSqlDialect

2024-05-22 Thread xiong duan (Jira)
xiong duan created CALCITE-6415: --- Summary: Invalid unparse for TIMESTAMP with HiveSqlDialect Key: CALCITE-6415 URL: https://issues.apache.org/jira/browse/CALCITE-6415 Project: Calcite Issue Typ

[Question] Left Semi Join and SqlToRelConverter

2024-05-22 Thread JinxTheKid
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

[jira] [Created] (CALCITE-6416) Remove unnecessary SUBSTRING rewrite in SparkSqlDialect

2024-05-22 Thread xiong duan (Jira)
xiong duan created CALCITE-6416: --- Summary: Remove unnecessary SUBSTRING rewrite in SparkSqlDialect Key: CALCITE-6416 URL: https://issues.apache.org/jira/browse/CALCITE-6416 Project: Calcite Iss