Max Gekk created SPARK-57814:
--------------------------------
Summary: Support NTZ and nanosecond-precision timestamps in
unix_seconds, unix_millis and unix_micros
Key: SPARK-57814
URL: https://issues.apache.org/jira/browse/SPARK-57814
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 4.3.0
Reporter: Max Gekk
This sub-task is part of the umbrella SPARK-56822 (timestamps with nanosecond
precision).
h2. Problem
{{TimestampToLongBase}} (datetimeExpressions.scala ~L854-947) types input as
{{TimestampType}} only; {{UnixSeconds}} / {{UnixMillis}} / {{UnixMicros}}
extend it, so NTZ and all nanosecond timestamp types raise an analysis error.
{{unix_nanos}} (SPARK-57527) is a separate nanosecond-only expression.
h2. Goal
Accept nanosecond LTZ timestamps (and, for microsecond-parity intent, NTZ) and
return the requested unit computed from {{TimestampNanosVal}} (truncating the
sub-unit remainder).
h2. Scope
Extend {{inputTypes}} to {{AnyTimestampNanoType}}; add a {{TimestampNanosVal}}
eval/codegen path converting epoch micros + nanosecond remainder to
seconds/millis/micros.
h2. Acceptance criteria
* {{unix_micros(ts_nanos)}} equals the value's epoch micros; {{unix_seconds}} /
{{unix_millis}} truncate correctly.
h2. Testing
{{DateExpressionsSuite}}; nanos golden files.
h2. Dependencies
None - independent.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
