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