[
https://issues.apache.org/jira/browse/KYLIN-5499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17709254#comment-17709254
]
longfeiJiang edited comment on KYLIN-5499 at 4/6/23 7:42 AM:
-------------------------------------------------------------
*Root Cause*
The model of the SQL hit is the partition column format as follows _yyyy-MM-dd_
!image-2023-04-06-15-35-35-934.png!
The data type of the F_LOSS.SYSTEM_RUN_DATE field in the hive table is TimeStamp
!image-2023-04-06-15-36-18-911.png!
Convert the start/end range of the first Segment of the model into the format
string of the model time partition column _ 1657497600000 -> "2022-07-11"_
!image-2023-04-06-15-39-54-901.png!
And in transformValue2RexLiteral method，change input to RexLiteral
Since the type of the partition column field is TimeStamp, it will enter the
corresponding branch.
!image-2023-04-06-15-41-10-625.png!
In new TimestampString(value) , regular matching fails, report error .
!image-2023-04-06-15-42-14-808.png!
was (Author: JIRAUSER298472):
*Root Cause*
The model of the SQL hit is the partition column format as follows _yyyy-MM-dd_
> Error is reported when query with the time partition column filter.
> -------------------------------------------------------------------
>
> Key: KYLIN-5499
> URL: https://issues.apache.org/jira/browse/KYLIN-5499
> Project: Kylin
> Issue Type: Bug
> Reporter: longfeiJiang
> Assignee: longfeiJiang
> Priority: Major
> Attachments: image-2023-04-06-15-35-35-934.png,
> image-2023-04-06-15-36-18-911.png, image-2023-04-06-15-39-54-901.png,
> image-2023-04-06-15-41-10-625.png, image-2023-04-06-15-42-14-808.png
>
>
> Set the column whose data type is timestamp in the source table to the
> yyyy-MM-dd format when setting the partition column, and configure not to
> check the format of the partition column in building job, an error is
> reported when query with the time partition column filter.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
