You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kudu.apache.org by "Greg Rahn (Jira)" <ji...@apache.org> on 2019/10/14 18:19:00 UTC
[jira] [Commented] (KUDU-2632) Add DATE data type
[ https://issues.apache.org/jira/browse/KUDU-2632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16951219#comment-16951219 ]
Greg Rahn commented on KUDU-2632:
---------------------------------
Per the ANSI SQL spec, the valid date range is 0001-01-01 to 9999-12-31 (so no year 0). !Screenshot 2019-10-14 11.18.12.png!
> 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)