Here's a project to deal with this issue specifically. I'm not sure of it's status: https://github.com/conikeec/orderly
On Mon, Nov 5, 2012 at 4:01 PM, lars hofhansl <[email protected]> wrote: > Have a look at the lily library. It has code to encode Longs/Doubles into > bytes such that resulting bytes sort as expected based on the numbers. > > -- Lars > > > > ________________________________ > From: Jonathan Bishop <[email protected]> > To: "[email protected]" <[email protected]> > Sent: Monday, November 5, 2012 10:41 AM > Subject: Using doubles and longs as ordering row values > > Hi, > > In my application my row values are doubles. I would like my scans to > traverse the rows in order of increasing values. > > But if I simply use > > double d = .... > byte[] row = Bytes.toBytes(d); > > I will get an ordering which is based on the byte values of doubles, not on > the value of the doubles themselves. > > I see also that integer values have the same issue due to the first bit > being the sign bit. So negative values will come after positive values. > > Any suggestions? > > Thanks, > > Jon >
