You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Will Noble (Jira)" <ji...@apache.org> on 2022/10/05 02:18:00 UTC
[jira] [Updated] (CALCITE-5308) Add support to Avatica for microsecond-precision timestamps (with timezone)
[ https://issues.apache.org/jira/browse/CALCITE-5308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Will Noble updated CALCITE-5308:
--------------------------------
Description: Avatica [serializes timestamps|https://github.com/apache/calcite-avatica/blob/9dfc5cad3efe72e9b14513b15a988ba86ab5a4ea/core/src/main/java/org/apache/calcite/avatica/remote/TypedValue.java#L447] as the integer number of milliseconds since epoch. We would like support for microsecond precision, although we only need it for {{TIMESTAMP_WITH_LOCAL_TIME_ZONE}}, which is currently lacking proper support (The recommended corresponding Java type as per [the spec|https://download.oracle.com/otn-pub/jcp/jdbc-4_2-mrel2-spec/jdbc4.2-fr-spec.pdf?AuthParam=1664936014_d36468601dd3a115d7d95c975043ff3a] is {{java.time.OffsetDateTime}} (was: Avatica [serializes timestamps|https://github.com/apache/calcite-avatica/blob/9dfc5cad3efe72e9b14513b15a988ba86ab5a4ea/core/src/main/java/org/apache/calcite/avatica/remote/TypedValue.java#L447] as the integer number of milliseconds since epoch. We would like support for microsecond precision.)
Summary: Add support to Avatica for microsecond-precision timestamps (with timezone) (was: Add support to Avatica for microsecond-precision timestamps)
> Add support to Avatica for microsecond-precision timestamps (with timezone)
> ---------------------------------------------------------------------------
>
> Key: CALCITE-5308
> URL: https://issues.apache.org/jira/browse/CALCITE-5308
> Project: Calcite
> Issue Type: Improvement
> Reporter: Will Noble
> Priority: Minor
>
> Avatica [serializes timestamps|https://github.com/apache/calcite-avatica/blob/9dfc5cad3efe72e9b14513b15a988ba86ab5a4ea/core/src/main/java/org/apache/calcite/avatica/remote/TypedValue.java#L447] as the integer number of milliseconds since epoch. We would like support for microsecond precision, although we only need it for {{TIMESTAMP_WITH_LOCAL_TIME_ZONE}}, which is currently lacking proper support (The recommended corresponding Java type as per [the spec|https://download.oracle.com/otn-pub/jcp/jdbc-4_2-mrel2-spec/jdbc4.2-fr-spec.pdf?AuthParam=1664936014_d36468601dd3a115d7d95c975043ff3a] is {{java.time.OffsetDateTime}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)