Work has not started, and I don’t know of anyone who is planning to work on this. I have logged https://issues.apache.org/jira/browse/CALCITE-4918 <https://issues.apache.org/jira/browse/CALCITE-4918> and https://issues.apache.org/jira/browse/CALCITE-4919 <https://issues.apache.org/jira/browse/CALCITE-4919>. Let’s discuss there.
> On Nov 30, 2021, at 10:45 AM, Sandeep Nayak <[email protected]> > wrote: > > Hello, > > I am a newbie to Calcite and still trying to figure all the pieces of the > project. > > In looking for support in Calcite to parse Snowflake expressions I ran into > a question asked earlier this month on the dev mail list which is pretty > much exactly what I am trying to do. Simon asked the question pretty > concisely see > https://www.mail-archive.com/[email protected]/msg17417.html. > > I did not see a follow up after Julian's response on that thread and wanted > to ask if there was work in progress on the snowflake integration? > > I looked at the instructions Julian provided but given that I am new to > this project I could not quite follow the pieces so I figured I should ask > a few questions to get a better understanding. Apologies if these seem > obvious and if they are already covered, please point me to collateral for > the same > > (a) There is a Free Marker template for parser in core as well as babel > sub-project. How are these two related? > > (b) The field reference operator ':' in snowflake (storing json in a > variant column) differs from '->>' as used in PostgresDB for jsonb. My > thought is that such a reference operator probably should be in a database > specific extension like through a snowflake adapter. Is that thinking > accurate? > > (c) How are new data types plugged in? For example VARIANT is a specific > Snowflake implementation and probably should stay in a snowflake adapter. > Similar to (b). > > For (b) and (c) how can a newbie like me understand how new operators or > data-types get introduced into the parser? Which adapter or example should > I look at to get a better sense of how the above is done? > > Thanks in advance for your help. > > Sandeep
