zabetak commented on code in PR #5757: URL: https://github.com/apache/hive/pull/5757#discussion_r2038947469
########## ql/src/test/queries/clientpositive/cbo_join_transitive_pred_loop_1.q: ########## @@ -1,5 +1,8 @@ set hive.optimize.join.disjunctive.transitive.predicates.pushdown=false; +-- HiveProject(month=[CAST(202503):INTEGER]) +--! qt:replace:/(.*month=\[CAST\()\d+(\).*)/$1#Masked#$2/ Review Comment: Instead of regex replace I think it will be safer and more robust to new plan changes to use `hive.test.currenttimestamp`. ########## ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnixTimestampSqlOperator.java: ########## @@ -29,13 +29,9 @@ */ public class HiveUnixTimestampSqlOperator { public static final SqlFunction INSTANCE = - new SqlFunction("UNIX_TIMESTAMP", SqlKind.OTHER_FUNCTION, ReturnTypes.BIGINT, null, + new HiveSqlFunction("UNIX_TIMESTAMP", SqlKind.OTHER_FUNCTION, ReturnTypes.BIGINT, null, OperandTypes.or(OperandTypes.NILADIC, OperandTypes.or(OperandTypes.STRING, OperandTypes.TIMESTAMP, OperandTypes.DATE), - OperandTypes.STRING_STRING), SqlFunctionCategory.NUMERIC) { - @Override - public boolean isDynamicFunction() { - return true; - } Review Comment: Not sure how much we rely on the notion of dynamic function but this PR changes the current behavior. Before the changes we were returning true and after this change we will return false. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For additional commands, e-mail: gitbox-h...@hive.apache.org