You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Kondakov Artem (Jira)" <ji...@apache.org> on 2022/04/01 07:31:00 UTC
[jira] [Updated] (KYLIN-5172) Incorrect work of the week function
[ https://issues.apache.org/jira/browse/KYLIN-5172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kondakov Artem updated KYLIN-5172:
----------------------------------
Summary: Incorrect work of the week function (was: Wrong )
> Incorrect work of the week function
> -----------------------------------
>
> 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
> Priority: Major
> 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)