-
1. Re: Combining multiple 'in' criteria can prevent pushing criteria to Oracle
shawkins Apr 25, 2014 1:45 PM (in response to mike_higgins)Generally what is happening is that the rewriter is undoing your split, but then the pushdown logic has not been implemented to split the values back out again. This was left as a todo if I recall, can you open an issue to allow the pushdown to occur?
-
2. Re: Combining multiple 'in' criteria can prevent pushing criteria to Oracle
rareddy Apr 25, 2014 1:56 PM (in response to mike_higgins)Another suggestion is, a new feature in 8.6 I believe is called data ship join, where you can create a temporary table in source and add all your data into it, then issue a join based call to filter out. Currently this is only supported for relational sources like Oracle. For that you need to enable "EnableDependentJoins" property on translator override properties (https://docs.jboss.org/author/display/TEIID/JDBC+Translator)
But I can not find an example in docs how to create a temporary table and issue queries. May be Steve knows.
Ramesh..
-
3. Re: Combining multiple 'in' criteria can prevent pushing criteria to Oracle
shawkins Apr 25, 2014 7:35 PM (in response to rareddy)Ramesh, that is a somewhat different scenario. If you are using dependent join pushdown, the temporary tables are managed by Teiid - there is no user interaction needed.
To turn this situation into a dependent join (regardless of whether it is fully pushed), you would first create a Teiid temporary table and load it with the in values then perform a join against the temporary table.
-
4. Re: Combining multiple 'in' criteria can prevent pushing criteria to Oracle
rareddy Apr 25, 2014 2:19 PM (in response to shawkins)thanks, I see the difference in the usecases now. Temp table is defined here Temp Tables - Teiid 8.8 (draft) - Project Documentation Editor in the "Foreign temporary tables" section.
-
5. Re: Combining multiple 'in' criteria can prevent pushing criteria to Oracle
mike_higgins Apr 25, 2014 2:57 PM (in response to rareddy)Thanks for the replies, I opened [TEIID-2936].
-
6. Re: Combining multiple 'in' criteria can prevent pushing criteria to Oracle
shawkins Apr 28, 2014 10:35 AM (in response to mike_higgins)Thanks Mike. This will be addressed in 8.8. The first alpha should be out next week.
Steve