[
https://issues.apache.org/jira/browse/IMPALA-8703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16969985#comment-16969985
]
ASF subversion and git services commented on IMPALA-8703:
---------------------------------------------------------
Commit 443ca2e8b7f77f70011e351a87207037871b9a74 in impala's branch
refs/heads/master from Gabor Kaszab
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=443ca2e ]
IMPALA-8704: ISO:SQL:2016 datetime patterns - Milestone 2
This patch adds additional datetime format tokens on top of what was
introduced with Milestone 1 (IMPALA-8703).
The tokens introduced:
- Free text token: Surrounded by double quotes, a free text section
can be given in the format where the same text is expected in the
input without the surrounding double quotes.
- FX modifier: This modifier has to be given at the beginning of the
format and is valid for the whole format.
In a string to datetime conversion this forces strict separator
matching and expects all the tokens in the input to have the same
length as their maximum length. E.g. A month has to be of length 2
prefixed by zero if needed.
This is the default in a datetime to string conversion.
- FM modifier: This modifier affects only the following token and
overrides the FX modifier.
In a string to datetime conversion when using this modifier the
length of the token in the input can be shorter than the max length
of that token type if followed by a separator. E.g. 1-digit month,
less than 4-digit year, etc. This is the default behaviour in a
string to datetime conversion.
In a datetime to string conversion tokens with this modifier aren't
padded to the maximum length. Example output: "2010-1-9".
Change-Id: I30d2f6656054371476aaa8bd0d51f572b9369855
Reviewed-on: http://gerrit.cloudera.org:8080/14291
Tested-by: Impala Public Jenkins <[email protected]>
Reviewed-by: Attila Jeges <[email protected]>
> SQL:2016 datetime patterns - Milestone 1
> ----------------------------------------
>
> Key: IMPALA-8703
> URL: https://issues.apache.org/jira/browse/IMPALA-8703
> Project: IMPALA
> Issue Type: Sub-task
> Components: Backend, Frontend
> Affects Versions: Impala 2.2.4
> Reporter: Gabor Kaszab
> Assignee: Gabor Kaszab
> Priority: Critical
> Fix For: Impala 3.4.0
>
>
> Design doc for SQL:2016 datetime patterns:
> https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/
> Milestone 1 content:
> - Introduce FORMAT clause for CAST()
> - Implement basic SQL:2016 datetime patterns to comply with the standard. For
> more details check the document above.
> - Use the new SQL:2016 pattern handling for CAST(.. FORMAT..)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
