Closed Hccccong closed 4 years ago
Ticket: https://kyligence.zendesk.com/agent/tickets/3060
Issue description: 如下查询在设置了sum和TopN度量时不应该击中TopN度量 select SELLER_ID, sum(ITEM_COUNT) from KYLIN_SALES group by SELLER_ID
Version: KAP 2.5.6.1010
Reproduction step: 新建一个cube,设置如下度量
进行查询select SELLER_ID, sum(ITEM_COUNT) from KYLIN_SALES group by SELLER_ID,击中了TopN度量,导致查询速度变慢
2018-04-11 01:57:12,580 INFO [Query d46a54d1-27c9-4cfe-a8ce-dcac3a913daa-2984] topn.TopNMeasureType : Rewrite function FunctionDesc [expression=SUM, parameter=DEFAULT.KYLIN_SALES.ITEM_COUNT, returnType=bigint] to FunctionDesc [expression=TOP_N, parameter=DEFAULT.KYLIN_SALES.ITEM_COUNT,DEFAULT.KYLIN_SALES.SELLER_ID, returnType=topn(10,4)]
Expectation from Dev: Fix this issue
Escalation approved by: @binmahone
Ticket: https://kyligence.zendesk.com/agent/tickets/3060
Issue description: 如下查询在设置了sum和TopN度量时不应该击中TopN度量 select SELLER_ID, sum(ITEM_COUNT) from KYLIN_SALES group by SELLER_ID
Version: KAP 2.5.6.1010
Reproduction step: 新建一个cube,设置如下度量
进行查询select SELLER_ID, sum(ITEM_COUNT) from KYLIN_SALES group by SELLER_ID,击中了TopN度量,导致查询速度变慢
Expectation from Dev: Fix this issue
Escalation approved by: @binmahone