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
