[ 
https://issues.apache.org/jira/browse/KYLIN-5499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17709266#comment-17709266
 ] 

longfeiJiang commented on KYLIN-5499:
-------------------------------------

*Fix Design*
Add check before segment range is converted to RexLiteral.

If it is a DATE or TIMESTAMP type, the segment range is converted to the 
corresponding partition column format.

If the converted format does not match the type, the segment range will be 
converted twice (other types and formats remain as they are), and the format 
conversion rules are as follows

* date type -> yyyy-MM-dd
* timestamp type -> yyyy-MM-dd HH:mm:ss

> 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)

Reply via email to