You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shao Feng Shi (Jira)" <ji...@apache.org> on 2020/05/27 10:14:00 UTC
[jira] [Closed] (KYLIN-1053) Non-Dict Non-String dimensions is not
handled correctly in ordering
[ https://issues.apache.org/jira/browse/KYLIN-1053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shao Feng Shi closed KYLIN-1053.
--------------------------------
> 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
> Priority: Major
>
> 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
(v8.3.4#803005)