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)
