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)