Re: Filterable table

2019-08-12 Thread Michael Mior
7a15ccc23eb9defd8e/core/src/main/java/org/apache/calcite/schema/ProjectableFilterableTable.java#L36 > > > > Best, > > Danny Chan > > 在 2019年8月12日 +0800 AM7:55,Lekshmi ,写道: > > > Hi Danny Chan, > > > Thank you so much for responding to my email. Can we use, Translatable > > >

Re: Filterable table

2019-08-11 Thread Danny Chan
在 2019年8月12日 +0800 AM7:55,Lekshmi ,写道: > > > Hi Danny Chan, > > > Thank you so much for responding to my email. Can we use, Translatable > > > table instead of Filterable table? which is more efficient? Usecase that > > if > > > need to write a Project push down (P

Re: Filterable table

2019-08-11 Thread Albert
/calcite/schema/ProjectableFilterableTable.java#L36 > > Best, > Danny Chan > 在 2019年8月12日 +0800 AM7:55,Lekshmi ,写道: > > Hi Danny Chan, > > Thank you so much for responding to my email. Can we use, Translatable > > table instead of Filterable table? which is more efficient?

Re: Filterable table

2019-08-11 Thread Danny Chan
在 2019年8月12日 +0800 AM7:55,Lekshmi ,写道: > Hi Danny Chan, > Thank you so much for responding to my email. Can we use, Translatable > table instead of Filterable table? which is more efficient? Usecase that if > need to write a Project push down (Push down Project fields into table sc

Re: Filterable table

2019-08-11 Thread Lekshmi
Hi Danny Chan, Thank you so much for responding to my email. Can we use, Translatable table instead of Filterable table? which is more efficient? Usecase that if need to write a Project push down (Push down Project fields into table scan then do Filtering) and Filter push down? Or Filterable

Re: Filterable table

2019-08-09 Thread Danny Chan
Hi, Lekshmi ~ The FilterableTable can be scanned with a list of filter expression, that means the filter conditions above the project + scan can be pushed directly into the table scan[1][2], which is more efficient. Here is a CsvFilterableTable example [3]. [1] 

Filterable table

2019-08-08 Thread Lekshmi
Hi, Can anyone explain to me what is the advantage of Filterable Table? How can we efficiently make use of that in a Federated system? Thanks and Regards Lekshmi B.G Email: lekshmib...@gmail.com