PdxInstanceImpl is not comparable... Options are: - group by on inner non-pdx objects (most of the usecases what we have seen). - or not using pdx
-Anil. On Thu, Jan 28, 2016 at 4:33 PM, Jason Huynh <[email protected]> wrote: > What's probably happening is that the field is being extracted but into a > pdxinstanceimpl instead of the actual object that the pdx instance > represents. I think we've seen similar issues in the past but I can't > remember if there was a work around or if we fixed it... > > On Thu, Jan 28, 2016 at 4:07 PM, William Markito <[email protected]> > wrote: > > > Guys, quick ask for help here... Given the following object: > > > > public class Cell implements Comparable<Cell>, PdxSerializable { > > > > I'm now trying to perform a query with order by the field that has this > > object, but I'm getting the following exception: > > > > gfsh> query --query="select pickup_cell from /TaxiTrip group by > > pickup_cell" > > Result : false > > startCount : 0 > > endCount : 20 > > Message : com.gemstone.gemfire.pdx.internal.PdxInstanceImpl cannot be > > cast to java.lang.Comparable > > > > Am I missing something ? > > > > The other comment about OQL on GFSH is that it's not actually returning > > query results when the query project a single field... I'll open the > Jira. > > > > For example: > > > > gfsh>query --query="select pickup_cell from /TaxiTrip" > > Result : false > > startCount : 0 > > endCount : 20 > > > > NEXT_STEP_NAME : END > > > > gfsh>query --query="select pickup_cell, dropoff_cell from /TaxiTrip" > > Result : true > > startCount : 0 > > endCount : 20 > > Rows : 1000 > > > > pickup_cell | dropoff_cell > > ------------------ | ------------------ > > {"x":166,"y":-155} | {"x":164,"y":-156} > > {"x":167,"y":-154} | {"x":167,"y":-151} > > {"x":159,"y":-153} | {"x":168,"y":-151} > > {"x":157,"y":-173} | {"x":167,"y":-153} > > {"x":161,"y":-155} | {"x":162,"y":-153} > > {"x":161,"y":-155} | {"x":162,"y":-153} > > >
