[ https://issues.apache.org/jira/browse/HIVE-2903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13239041#comment-13239041 ]
Ashutosh Chauhan commented on HIVE-2903: ---------------------------------------- @Navis, The way you have fixed it, it will work only if data is written from hive into hbase and then queries are run from hive client against hbase. What if data was written in hbase through hbase client and then queried from hive client, this bug will still be there, isn't it? This also makes me wonder that this problem is not limited to hive, but for hbase in general. If you are writing data through hbase client and then do range scans, you will have same bug. There must be some solution in hbase space for this. > Numeric binary type keys are not compared properly > -------------------------------------------------- > > Key: HIVE-2903 > URL: https://issues.apache.org/jira/browse/HIVE-2903 > Project: Hive > Issue Type: Bug > Components: HBase Handler > Reporter: Navis > Assignee: Navis > Attachments: HIVE-2903.D2481.1.patch > > > In current binary format for numbers, minus values are always greater than > plus values, for example. > {code} > System.our.println(Bytes.compareTo(Bytes.toBytes(-100), Bytes.toBytes(100))); > // 255 > {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira