You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/11/03 15:33:27 UTC
[jira] [Commented] (FLINK-2961) Add support for basic type Date in
Table API
[ https://issues.apache.org/jira/browse/FLINK-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14987359#comment-14987359 ]
ASF GitHub Bot commented on FLINK-2961:
---------------------------------------
GitHub user twalthr opened a pull request:
https://github.com/apache/flink/pull/1322
[FLINK-2961] [table] Add support for basic type Date in Table API
Currently, the basic type Date is not implemented in the Table API. In order to have a mapping of the most important ANSI SQL types for FLINK-2099. It makes sense to add support for Date to represent date, time and timestamps of milliseconds precision. This PR implements FLINK-2961.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/twalthr/flink TableApiDate
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/flink/pull/1322.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1322
----
commit 78d74b2fc03344f9f6798895e32f743d47da6c1d
Author: twalthr <tw...@apache.org>
Date: 2015-11-03T14:18:19Z
[FLINK-2961] [table] Add support for basic type Date in Table API
----
> Add support for basic type Date in Table API
> --------------------------------------------
>
> Key: FLINK-2961
> URL: https://issues.apache.org/jira/browse/FLINK-2961
> Project: Flink
> Issue Type: Improvement
> Components: Table API
> Reporter: Timo Walther
> Assignee: Timo Walther
> Priority: Minor
>
> Currently, the basic type {{Date}} is not implemented in the Table API. In order to have a mapping of the most important ANSI SQL types for FLINK-2099. It makes sense to add support for {{Date}} to represent date, time and timestamps of milliseconds precision.
> Only the types `LONG` and `STRING` can be casted to `DATE` and vice versa. A `LONG` casted to `DATE` must be a milliseconds timestamp. A `STRING` casted to `DATE` must have the format "`yyyy-MM-dd HH:mm:ss.SSS`", "`yyyy-MM-dd`", "`HH:mm:ss`", or a milliseconds timestamp. All timestamps refer to the UTC timezone beginning from January 1, 1970, 00:00:00 in milliseconds.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)