[jira] [Created] (KYLIN-1053) Non-Dict Non-String dimensions is not handled correctly in ordering

["hongbin ma (JIRA)" <ji...@apache.org>]

hongbin ma created KYLIN-1053:
---------------------------------

             Summary: Non-Dict Non-String dimensions is not handled correctly in ordering
                 Key: KYLIN-1053
                 URL: https://issues.apache.org/jira/browse/KYLIN-1053
             Project: Kylin
          Issue Type: Bug
            Reporter: hongbin ma
            Assignee: hongbin ma


from: _@databuryat.com
======================



I found something:

I executed a query on one partition with a filter on one integer dimension(without dictionary) with two values (70, 200) and got the following in the logs:
http://i.imgur.com/b3zthZ3.png

You see the scan range and 0 rows in the result set.

I tried the same scan in hbase shell and got 0 rows:
scan 'KYLIN_JH6RCA65S7', {STARTROW => "\x00\x00\x00\x00\x00\x00\x01 2015-09-2670\x09\x09\x09\x09", STOPROW => "\x00\x00\x00\x00\x00\x00\x01 2015-09-26200\x09\x09\x09\x00"}

then I swapped the start & stop row:
scan 'KYLIN_JH6RCA65S7', {STARTROW => "\x00\x00\x00\x00\x00\x00\x01 2015-09-26200\x09\x09\x09", STOPROW => "\x00\x00\x00\x00\x00\x00\x01 2015-09-2670\x09\x09\x09\x09\x00"}
and got 659 rows.

And just to confirm I changed the order of the stop & start row in HBaseKeyRange and got the results:
http://i.imgur.com/mT0qI4I.png



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)