Jesus Camacho Rodriguez created CALCITE-1947:
------------------------------------------------
Summary: Add time/timestamp with time zone types to optimizer
Key: CALCITE-1947
URL: https://issues.apache.org/jira/browse/CALCITE-1947
Project: Calcite
Issue Type: New Feature
Components: core
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
Fix For: 1.14.0
Implementation would be similar to PostgreSQL (the {{time/timestamp with
timezone}} types do not store the timezone) and conversion from/to
timezone-less types follows similar semantics.
https://www.postgresql.org/docs/9.6/static/functions-datetime.html
This would also allow us to integrate easily with Hive and Druid, which follow
similar storage models/semantics for timestamp with timezone.
Follow-up work will be needed to introduce these new types in Avatica and
extend Calcite SQL parser.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
