Developing a new SqlDialect

2023-07-11 Thread Joeri van Ruth
Hi all, MonetDB is an open source columnar main-memory SQL database that has been around for quite a while. I am a MonetDB developer and I would like to add support for MonetDB's SQL dialect to Calcite and contribute it to the Calcite project. Looking at some of the existing Dialect classes I do

PR CALCITE-5681 Review Request

2023-07-11 Thread ghy_pku
Hi, community! I’ve submitted a PR for supporting authorization via GRANT and REVOKE DDL commands. JIRA case link: https://issues.apache.org/jira/browse/CALCITE-5816 Github PR link: https://github.com/apache/calcite/pull/3284 Can someone make a review? Thank you! Best Hongyu Guo

Re: Developing a new SqlDialect

2023-07-11 Thread Julian Hyde
I see those problems too. A major problem is that when you start a new dialect, there are no tests. And that’s because our dialect test does not execute queries, only compares generated SQL (and those SQL fragments need to be entered by hand). There’s a good reason that our dialect test does no

Re: Developing a new SqlDialect

2023-07-11 Thread Gavin Ray
I can't offer much in the way of advice for Dialect development, but anecdotally it took me maybe 3-4 weeks of reading the Calcite source code every day after work (mostly the tests) and whatever tutorial material I could find to start to wrap my head around the general API and program flow. (I wo

Jenkins build is back to normal : Calcite » Calcite-snapshots #530

2023-07-11 Thread Apache Jenkins Server
See