[TianJialong]

What changes are proposed in this pull request?

Fixes #13471

Maps the temporal string/number conversion expressions to their velox flinksql implementations (companion velox PR bigo-sg/velox#94, velox4j PR bigo-sg/velox4j#75):

• RexCallConverterFactory: TO_DATE / TO_TIMESTAMP / TO_TIMESTAMP_LTZ entries — plain name mappings; both arities of the first two are covered by the flinksql signatures, TO_TIMESTAMP_LTZ's numeric argument types bind through the same registration.
• RexNodeConverter: DATE literals convert to the epoch-day IntegerValue — Flink folds constant TO_DATE calls in the planner, and the plan used to die at conversion with the DATE literal unsupported. TIMESTAMP_WITH_LOCAL_TIME_ZONE literals share the TIMESTAMP conversion body (TimestampString.getMillisSinceEpoch → boxed-Long millis, with a null guard), so folded TO_TIMESTAMP / TO_TIMESTAMP_LTZ literals reach velox. NULL literal branches emit a null variant (a velox4j serialization limitation currently drops typed NULL literals at the bridge; NULL rows arrive from data inputs instead).
• RexNodeConverter: identity-cast elimination — the planner emits CAST(literal AS T) around every folded literal whose nullability differs from the sink's, and velox rejects same-type casts, so isSameTypeIgnoringNullability (recursive type equality ignoring nullability only; ANY never elided; composite component types must match) passes the operand through unchanged.
• RexNodeConverterTest: covers the two literal channels, the identity-cast behavior across scalar and composite types, and the NULL literal branches.

How was this patch tested?

• Planner-level: RexNodeConverterTest — DATE literal converts to the epoch-day IntegerValue, LTZ literal to epoch millis; identity CAST elided on nullability-only casts for scalar and composite types (ARRAY/ROW/MAP casts with different component types stay real casts); NULL literal branches.
• Execution-level (embedded gluten stack): DateTimeFunctionsTest in org.apache.gluten.table.runtime.stream.custom — both arities of to_date (incl. constant-format folding through the DATE literal channel), to_timestamp (SMART clamping, 24:00 rollover, fraction flooring, column/constant formats), to_timestamp_ltz (precision 0/3 unit semantics, epoch-domain bounds, double/decimal inputs), NULL propagation on all forms, and CASE/WHERE combinations.
• End-to-end dual-run on Flink 1.19.2: 32 SQL scenarios across the family — both arities, constant vs column formats, NULL propagation, literal folding for DATE and LTZ, invalid-input and out-of-range classes — with 29 exact matches and 3 shared job-failure classes (illegal format, year overflow, unsupported LTZ precision: identical failures on both stacks), zero mismatches.

[TianJialong]

@KevinyhZou @lgbo-ustc @philo-he @ggjh-159 Would you mind reviewing this PR?

[lgbo-ustc]

This PR depends on bigo-sg/velox#94, but the Flink build still pins a Velox4j revision whose Velox dependency predates those functions. Please update the Velox and Velox4j references so the new offload mappings are built and tested against a version that contains the required implementations.

[philo-he]

@TianJialong, thanks for the PR. Could you rebase the code and fix conflicts?

The latest Gluten Flink uses the following file to maintain the referenced velox4j version.
https://github.com/apache/gluten/blob/main/gluten-flink/velox4j-ref.txt

[philo-he]

Do we need to revert this before merging?

[TianJialong]

@philo-he Yes, we need. But PRs in velox and velox4j haven't merged yet. I'll revert it after they merge.

[philo-he]

I see. Let's mark this PR as a draft to indicate it is not ready to merge. Thanks!

[ggjh-159]

@TianJialong please update velox4j version

[TianJialong]

@TianJialong please update velox4j version

@philo-he @ggjh-159 All references are updated.

[philo-he]

Looks good. Thanks! Pending @lgbo-ustc's review.