[
https://issues.apache.org/jira/browse/KUDU-2632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16951250#comment-16951250
]
Adar Dembo commented on KUDU-2632:
----------------------------------
bq. Per the ANSI SQL spec, the valid date range is 0001-01-01 to 9999-12-31
(so no year 0).
Thanks for the correction. Indeed, Impala began with a minimum year of
0000-01-01 but eventually changed to 0001-01-01. See IMPALA-7368 for details.
> Add DATE data type
> ------------------
>
> Key: KUDU-2632
> URL: https://issues.apache.org/jira/browse/KUDU-2632
> Project: Kudu
> Issue Type: New Feature
> Components: tablet
> Affects Versions: 1.8.0
> Reporter: Adar Dembo
> Assignee: Vladimir Verjovkin
> Priority: Major
> Labels: roadmap-candidate
> Attachments: Screenshot 2019-10-14 11.18.12.png
>
>
> {{DATE}} is a timezone-agnostic measure of the current date (without time of
> day) in YYYY-MM-DD form. The range of values typically supported is
> 0000-01-01 to 9999-12-31. [Parquet has
> implemented|https://github.com/apache/parquet-format/blob/master/LogicalTypes.md#date]
> {{DATE}} as a logical type mapped to int32, represented as the number of
> days since the start of the UNIX epoch (i.e. January 1, 1970).
> Support for {{DATE}} is currently being added to Impala; we should also add
> support for it to Kudu.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
