You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "Marc Wu (Jira)" <ji...@apache.org> on 2019/11/18 07:56:00 UTC

[jira] [Created] (KYLIN-4260) When using server side PreparedStatement cache, the query result are not match on TopN scenario

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)