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 don't expect the end result to be a lot of code but I'm a bit concerned that the process of getting there will be an endless treadmill of users finding yet another deviation and me fixing it. I'm hoping to ask you here for some guidance on how to develop a new dialect in a more systematic way and how to ensure it will not immediately fail when someone other than the developer tries to use it. For example, I know you have an extensive test suite, will I be able to use that to determine if my implementation is ready, and to pinpoint the things I still need to do? Are there particular parts of the rest of the code base I should first try to familiarize myself with to make the implementation go more smoothly? Also, what would you expect to be a reasonable time frame for this project considering I have good knowledge fo MonetDB but I'm new to Calcite? A week? A month? Any tips and pointers would be appreciated. Joeri
