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

Stamatis Zampetakis commented on HIVE-28920:
--------------------------------------------

This becomes an issue after HIVE-27291 where unixtimestamp is constant folded 
during compilation. The PR in HIVE-27291 opted to avoid the flakiness using 
pattern masking but as it appears this mechanism can easily break.

> plan changes in test due to unix_timestamp
> ------------------------------------------
>
>                 Key: HIVE-28920
>                 URL: https://issues.apache.org/jira/browse/HIVE-28920
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 4.1.0
>            Reporter: Soumyakanti Das
>            Priority: Major
>
> After Calcite is upgraded to 1.33 through 
> [PR#5196|https://github.com/apache/hive/pull/5196], 
> cbo_join_transitive_pred_loop_1.q.out will fail every month as it relies on 
> {{unix_timestamp()}} and {{add_months()}} functions to compute month. 
> We should either use {{hive.test.currenttimestamp}} or mask the month to fix 
> this.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to