[jira] [Created] (KYLIN-5172) Wrong

["Kondakov Artem (Jira)" <ji...@apache.org>]

Kondakov Artem created KYLIN-5172:
-------------------------------------

             Summary: Wrong 
                 Key: KYLIN-5172
                 URL: https://issues.apache.org/jira/browse/KYLIN-5172
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v4.0.1
         Environment: https://hub.docker.com/r/apachekylin/apache-kylin-standalone
            Reporter: Kondakov Artem
             Fix For: v4.0.2
         Attachments: image-2022-04-01-10-27-38-769.png

 

good afternoon.
I deployed a standard apache/kylin 4.0.1 docker container
Build the kylin_sales_cube cube from sample project.
Then i tried to run the following query
{code:java}
select  
    KYLIN_SALES.PART_DT as "DATE_PART_DT", 
    WEEK(KYLIN_SALES.PART_DT) as "WEEK", 
    YEAR(KYLIN_SALES.PART_DT) as "YEAR", 
    cast(KYLIN_SALES.PART_DT as timestamp) as "TS_PART_DT" 
from KYLIN4.KYLIN_SALES as KYLIN_SALES 
where (KYLIN_SALES.PART_DT between TIMESTAMP '2012-01-01 00:00:00' AND  TIMESTAMP '2012-02-01 12:46:00') order by DATE_PART_DT {code}
 

Result is 

!image-2022-04-01-10-27-38-769.png!

One of the values ​​is calculated incorrectly either week or year for the date 2012-01-01 00:00:00. I think the week is wrong

 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)