[
https://issues.apache.org/jira/browse/HIVE-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14240858#comment-14240858
]
Lefty Leverenz commented on HIVE-3187:
--------------------------------------
This should be documented in the wiki, with version information:
* [Hive Data Types -- Timestamps |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-Timestamps]
> support ISO-2012 timestamp literals
> -----------------------------------
>
> Key: HIVE-3187
> URL: https://issues.apache.org/jira/browse/HIVE-3187
> Project: Hive
> Issue Type: Improvement
> Affects Versions: 0.9.0
> Reporter: N Campbell
> Assignee: Navis
> Labels: TODOC15
> Fix For: 0.15.0
>
> Attachments: HIVE-3187.1.patch.txt, HIVE-3187.2.patch.txt,
> HIVE-3187.3.patch.txt
>
>
> Enable the JDBC driver/Hive SQL engine to accept JDBC canonical or ISO-SQL
> 20xx Timestamp literals
> ie.
> select 1 from cert.tversion tversion where timestamp '1989-01-01
> 10:20:30.000000000' <> timestamp '2000-12-31 12:15:30.123000000'
> instead of
> unix_timestamp('.....)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
