Calcite aims to support standard SQL out of the box, not every vendor’s extension to it. But we will consider adding extensions if they can be selectively enabled. For example, https://issues.apache.org/jira/browse/CALCITE-1066 will allow you to say ‘fun=oracle’ and get extra Oracle-specific functions. We might do the same for other dialects.
“!=“ is a known issue: https://issues.apache.org/jira/browse/CALCITE-295. Can you please log a JIRA case for MINUS. For CONVERT and DATEDIFF you may be able to add user-defined functions. Also, I added them to the list for https://issues.apache.org/jira/browse/CALCITE-759. Can you please log a JIRA case for ‘&’. Julian > On Mar 3, 2016, at 7:33 AM, Sameh Samra <[email protected]> wrote: > > Hi *, > We use calcite parser to parse Oracle and MSSQL queries. > However, we found that SqlParser.parseQuery() cannot understand the following > key words in Oracle queries: MINUS and != > On the other hand in MSSQL, it cannot parse queries that has CONVERT and > DATEDIFF functions and bit operation (&). > > Could you please tell us how we can overcome this problem? > > Best regards, > Sameh Samra > > novomind Egypt LLC > _____________________________ > > 7 Abou Rafea Street, Moustafa Kamel, Alexandria, Egypt > > Phone +20 3 5447541 - 104 > email [email protected]<mailto:[email protected]> * Skype > sameh.samra_nmeg >
