Wes, Attached is an example that loads colocated partitioned regions with customers and orders and uses a function to execute a join query against them.
It has a readme that describes how to run it. Let me know if you have any issues. Thanks, Barry Oglesby GemFire Advanced Customer Engineering (ACE) For immediate support please contact Pivotal Support at http://support.pivotal.io/ On Tue, Nov 17, 2015 at 2:32 PM, Real Wes Williams <[email protected]> wrote: > > Hi team, > > Executing a join query inside a function is returning an error for a > reason that it should not. The error message says that a join won't work > unless it’s inside a function. But I AM inside a function! Need some > guidance. I'm not even doing anything with the second region. It's just > defined. How can I get a proper join to work if both are partitioned? > > [error 2015/11/17 16:46:10.627 EST server1 <**Function Execution** Processor1> > tid=0x45] Function search-inventory-function: > java.lang.UnsupportedOperationException: A query on a Partitioned > Region ( Instruments ) may not reference any other region if query is NOT > executed within a Function > > *SELECT p.instrumentId FROM /Prices p, /Instruments;* > > Both are partitioned. Both are colocated on instrumentId. The query is > being executed inside of a function.onRegion(…). > > How can I get a proper join to work if both are partitioned? I thought > this was supported. > > Thanks, > Wes >
geode_clean_11-17-2015.tgz
Description: GNU Zip compressed data
