Thanks Julian for pointing to web adapter. is there any possibility to translate the where clause of sql to uri parameter ( its a filter parameter for that rest resource ) so that i can reduce the payload and less processing at calcite engine.
refering https://github.com/HenryOlson/optiq-web/blob/master/src/test/resources/wiki.json model e:g select * from Cities where rank < 10; can translate the uri request to https://github.com/HenryOlson/optiq-web/blob/master/src/test/resources/wiki.json?rank<10 and assuming the uri has filter capabilities. i am thinking of this as we are have fat pay load if we do no apply filters dynamically via where clause, this could lead to performance issue. thanks, Ravi Katkar On Thu, Oct 27, 2016 at 9:01 PM, Julian Hyde <[email protected]> wrote: > We “web adapter”[1] is a work in progress that would do this. The dev > branch might work for you. Feel free to extend it for your use case. > > Julian > > [1] https://issues.apache.org/jira/browse/CALCITE-884 < > https://issues.apache.org/jira/browse/CALCITE-884> > > > On Oct 27, 2016, at 6:50 AM, ravi katkar <[email protected]> > wrote: > > > > Hi List, > > > > we have rest services as a data source, we want to create a rest service > > adapter which can provide sql capabilities where on my sql can translate > to > > respective rest service call. > > > > i have gone through the CSV adapter example. > > > > can list provide me more insight on adapter development. > > > > Thanks, > > Ravi Katkar > >
