Marc Wu created KYLIN-4260:
------------------------------
Summary: When using server side PreparedStatement cache, the query
result are not match on TopN scenario
Key: KYLIN-4260
URL: https://issues.apache.org/jira/browse/KYLIN-4260
Project: Kylin
Issue Type: Bug
Components: Query Engine
Affects Versions: v2.6.4, v3.0.0-alpha2
Reporter: Marc Wu
Assignee: Marc Wu
Fix For: v3.0.0, v2.6.5
Attachments: image-2019-11-18-15-55-00-312.png,
image-2019-11-18-15-55-11-906.png
Hi Kylin team,
I found an issue while server side PreparedStatement enabled. The second time
query and after's result will be different from the first when query TopN, and
the result is not right.
Part of Cube info:
Dimensions
TRANS_ID
PART_DT
SELLER_ID
BUYER_ID
Measures:
SUM(PRICE)
MAX(PRICE)
TOPN(PRICE) Group By:KYLIN_SALES.SELLER_ID,KYLIN_SALES.BUYER_ID
The First query result:
!image-2019-11-18-15-55-00-312.png!
The Second and after:
!image-2019-11-18-15-55-11-906.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)