I’d like the adapter to be able to do this. Maybe it can accept push down of filters and projects, and have some policy for how to add those filters and projects to the URI generated for the REST call.
So yes, it’s possible, but it’s not implemented. Julian > On Oct 27, 2016, at 10:38 AM, ravi katkar <[email protected]> wrote: > > 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 >> >>
