[
https://issues.apache.org/jira/browse/SPARK-57454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Max Gekk updated SPARK-57454:
-----------------------------
Affects Version/s: 4.3.0
(was: 5.0.0)
> Add type coercion and widening rules for nanosecond-precision timestamp types
> -----------------------------------------------------------------------------
>
> Key: SPARK-57454
> URL: https://issues.apache.org/jira/browse/SPARK-57454
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 4.3.0
> Reporter: Max Gekk
> Priority: Major
>
> Umbrella: SPARK-56822 (Timestamps with nanosecond precision).
> Add implicit type coercion and widening support for the nanosecond-capable
> timestamp types TIMESTAMP_NTZ(p) and TIMESTAMP_LTZ(p) (p in 7-9), to reach
> parity with the microsecond TimestampType / TimestampNTZType.
> Today findWiderDateTimeType in TypeCoercionHelper is microsecond-only and has
> no default case, so any pair involving a nanosecond type (including
> micro+nanos and nanos(p1)+nanos(p2)) is unhandled and can fail analysis.
> There are currently no references to the nanosecond timestamp types anywhere
> under sql/catalyst/.../analysis/.
> Scope:
> - Extend findWiderDateTimeType: nanos<->micro widen to the nanosecond type;
> nanos(p1)<->nanos(p2) widen to max precision; nanos<->date.
> - Wire TypeCoercion and AnsiTypeCoercion (findTightestCommonType,
> findWiderTypeForTwo) and StringPromotionTypeCoercion.
> - Tests: UNION ALL, IN, CASE, coalesce, and binary comparisons mixing
> micro/nanos.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
