I think that is an incorrectly worded exception message. It really means if the query is not using a RegionFunctionContext. How are you executing the query in the function? I'll send you an example.
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 >
