[
https://issues.apache.org/jira/browse/SPARK-57554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18091239#comment-18091239
]
Max Gekk commented on SPARK-57554:
----------------------------------
Closing as a duplicate of SPARK-57660, which implements bidirectional casts
between TIME(p) and the corresponding TIMESTAMP type for q in [6, 9] in a
single change — covering both the microsecond member (q=6) and the nanosecond
members (q in [7, 9]) that this ticket scoped separately.
> Support cast between TIME and TIMESTAMP_LTZ(p) for p in [7, 9]
> --------------------------------------------------------------
>
> Key: SPARK-57554
> URL: https://issues.apache.org/jira/browse/SPARK-57554
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 4.3.0
> Reporter: Max Gekk
> Priority: Major
>
> h2. What
> Support {{CAST}} in both directions between {{TIME}} and the nanosecond
> timestamp type
> {{TIMESTAMP_LTZ(p)}} ({{TimestampLTZNanos}}, p in 7..9).
> h2. Why
> Completes the ANSI TIME <-> TIMESTAMP cast matrix for the nanosecond,
> time-zone-aware
> timestamp type. Depends on the TIME precision-9 extension and mirrors the
> NTZ-nanos ticket
> with session-time-zone handling.
> h2. Semantics (ANSI / session time zone)
> * {{CAST(time AS TIMESTAMP_LTZ(p))}}: combine the time-of-day with
> {{CURRENT_DATE}} in the
> session time zone, store as an absolute instant at target precision p.
> * {{CAST(ts_ltz_nanos AS TIME(q))}}: convert to the session time zone, take
> the time-of-day,
> truncate fractional seconds to q.
> h2. Scope
> * {{canCast}}/{{canAnsiCast}} + runtime + codegen in {{Cast.scala}},
> threading session
> {{zoneId}}.
> * Reuse the nanos cross-precision floor helpers in {{SparkDateTimeUtils}};
> preserve full
> nanosecond precision in both directions for p,q in 7..9.
> h2. Acceptance criteria
> * Both directions correct for all precision combinations of TIME(0..9) and
> TIMESTAMP_LTZ(7..9), across time zones/DST.
> * ANSI and non-ANSI modes; tests in {{CastSuiteBase}} and SQL golden files.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
