You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Lefty Leverenz (JIRA)" <ji...@apache.org> on 2014/12/10 10:39:12 UTC

[jira] [Commented] (HIVE-3187) support ISO-2012 timestamp literals

    [ 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)