Avatica results mapping

2020-06-03 Thread Jon Pither
Hi, I have a data-type I'm mapping as SqlTypeName/OTHER - in this case java.util.UUID. When I return this field from an enumerator via an adapter it works OK - the UUID is passed through into the JDBC result set. Over the wire though, Avatica throws an error " Remote driver error:

Adapter usage of RexImpTable

2020-05-18 Thread Jon Pither
Hi, Is it possible for an adapter to leverage RexImpTable to handle calculations? >From RexImpTable I can get an Implementor for a given operation in a RexCall, but then the implement method that would generate an expression, takes a RexToLixTranslator. The RexToLixTranslator has a private

Re: Building a Calcite Adapter

2020-05-01 Thread Jon Pither
to get a similar rule firing for us - but no joy (I also couldn't find an example query plan of JdbcCalc in action). On Fri, 1 May 2020 at 17:39, Jon Pither wrote: > Hi, > > Thanks for bearing with. > > I'm stuck as to when EnumerableCalc fires vs Project. > > We added a Proj

Re: Building a Calcite Adapter

2020-05-01 Thread Jon Pither
the above query works. Regards, Jon. On Fri, 1 May 2020 at 11:09, Jon Pither wrote: > Thanks. Another Q: > > In Crux we store documents, and values within those documents can be > Clojure.lang.Keywords. I'm still deciding how to handle them with Calcite - > one option being simply

Re: Building a Calcite Adapter

2020-05-01 Thread Jon Pither
s we offer a function, i.e.: SELECT NAME FROM PERSON WHERE GENDER = KEYWORD('female'), the keywords then get passed down to our underlying query engine. Jon. On Thu, 30 Apr 2020 at 18:30, Julian Hyde wrote: > > > > On Apr 30, 2020, at 8:56 AM, Jon Pither wrote: > > > > We went

Re: Building a Calcite Adapter

2020-04-30 Thread Jon Pither
/TIMESTAMP. To get this to work though, our enumerator has to convert our dates into millis, for Calcite to then convert them back into java.util.Dates.. Feel like I missing something obvious to skip this conversion? On Mon, 27 Apr 2020 at 16:53, Jon Pither wrote: > Hi, > > Another ro

Re: Building a Calcite Adapter

2020-04-27 Thread Jon Pither
/executeDdl How could we make use of SqlSetOption? Do we need to extend the parser or is there a simpler way? Regards, Jon. On Mon, 27 Apr 2020 at 13:30, Jon Pither wrote: > Hi Stamatis & Calcite team, > > Thanks for your response. We've made some good progress since - following >

Re: Building a Calcite Adapter

2020-04-27 Thread Jon Pither
ll know already. > Apart from that the project has many volunteers willing to help so if you > have more questions don't hesitate to send them to this list. > > Best, > Stamatis > > [1] > > https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/ada

Building a Calcite Adapter

2020-04-07 Thread Jon Pither
Hi Calcite Devs, Firstly, thank you to all of you for building this fantastic tool. I'm currently experimenting with using Calcite on top of our document database Crux (opencrux.com) offering bitemporal features using a Datalog query language. You can see our efforts here, written in Clojure!