Hi Dmitry,

You can try to create additional table with only row ID and field for join.
So, you will be able to make joins, but you will need to retrieve detailed
data from external store manually.

To speed up external store lookups, you can create one more cache with
eviction policy backed with external store.

Also, you can configure cache interceptor to automatically substitute
values from external store on basic get\put operations. However, this will
not work for Scan and SQL queries.

On Thu, Apr 6, 2017 at 7:55 PM, Dmitri Bronnikov <[email protected]
> wrote:

> Thanks, Andrey, I know it doesn't just work out of the box, but what's the
> best way to add something like that? It's a fairly common feature, Oracle
> has external tables, Presto has a plug-in mechanism that allows, among
> other
> things, to pushdown predicates to the external table driver.
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/External-data-sources-tp11766p11786.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Best regards,
Andrey V. Mashenkov

Reply via email to