[KYLIN-5172] Incorrect work of the week function

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v4.0.1
• Fix Version/s: v4.1.0
• Component/s: Query Engine
• Environment: https://hub.docker.com/r/apachekylin/apache-kylin-standalone
• Assignee: Unassigned
• Reporter: Kondakov Artem
• Created: 01/Apr/22 07:29
• Updated: 31/Aug/22 12:17

Description

 

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

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 

 

Result is 

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