Re: EnumerableTableScan array/multiset handling

2024-05-30 Thread Julian Hyde
Thanks for doing these experiments, Christian, and documenting what you found. I think you’re running into the limitations of ReflectiveSchema. It works with POJOs (java classes with public fields) but hasn’t been tested for richer variations and therefore just doesn’t work. In many cases, it ca

Re: How to PARSER the SPARK SQL

2024-05-30 Thread Walaa Eldin Moustafa
Hi Yujia, You might take inspiration from Coral https://github.com/linkedin/coral. It is based on Calcite but uses the Hive parser (which is compatible with Spark SQL) to generate the SQL and Rel nodes. There is a PR that uses the native Spark parser as well https://github.com/linkedin/coral/pull/

Re: How to PARSER the SPARK SQL

2024-05-30 Thread Mihai Budiu
The SQL language has several sublanguages: the query language, the data definition language, and the data manipulation language. The core of Calcite is mostly about the query language, but there are Calcite components that deal with the other languages as well (e.g., server, babel). Both these

[jira] [Created] (CALCITE-6424) Enable RLIKE function in MySQL library

2024-05-30 Thread xiong duan (Jira)
xiong duan created CALCITE-6424: --- Summary: Enable RLIKE function in MySQL library Key: CALCITE-6424 URL: https://issues.apache.org/jira/browse/CALCITE-6424 Project: Calcite Issue Type: Improvem