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 <wmark...@pivotal.io>
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}
>
