[ https://issues.apache.org/jira/browse/IMPALA-8704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16969984#comment-16969984 ]
ASF subversion and git services commented on IMPALA-8704: --------------------------------------------------------- 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 <impala-public-jenk...@cloudera.com> Reviewed-by: Attila Jeges <atti...@cloudera.com> > SQL:2016 datetime patterns - Milestone 2 > ---------------------------------------- > > Key: IMPALA-8704 > URL: https://issues.apache.org/jira/browse/IMPALA-8704 > Project: IMPALA > Issue Type: Sub-task > Components: Backend > Affects Versions: Impala 2.2.4 > Reporter: Gabor Kaszab > Assignee: Gabor Kaszab > Priority: Major > Labels: ramp-up > Fix For: Impala 3.4.0 > > > Design doc for SQL:2016 datetime patterns: > https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/ > Milestone 2 content: > - Nested strings > - FM/FX modifiers -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org