hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Dere (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-12502) to_date UDF cannot accept NULLs of VOID type
Date Sat, 12 Dec 2015 00:33:46 GMT

    [ https://issues.apache.org/jira/browse/HIVE-12502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15053849#comment-15053849
] 

Jason Dere commented on HIVE-12502:
-----------------------------------

Looks good, do you mind adding a .q file test with to_date(null)? might be the best way to
verify it is fixed, if this is your use case.

> to_date UDF cannot accept NULLs of VOID type
> --------------------------------------------
>
>                 Key: HIVE-12502
>                 URL: https://issues.apache.org/jira/browse/HIVE-12502
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>    Affects Versions: 1.0.0
>            Reporter: Aaron Tokhy
>            Assignee: Jason Dere
>            Priority: Trivial
>         Attachments: HIVE-12502-branch-1.patch, HIVE-12502.patch
>
>
> The to_date method behaves differently based off the 'data type' of null passed in.
> hive> select to_date(null);                   
> FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments 'TOK_NULL': TO_DATE()
only takes STRING/TIMESTAMP/DATEWRITABLE types, got VOID
> hive> select to_date(cast(null as timestamp));
> OK
> NULL
> Time taken: 0.031 seconds, Fetched: 1 row(s)
> This appears to be a regression introduced in HIVE-5731.  The previous version of to_date
would not check the type:
> https://github.com/apache/hive/commit/09b6553214d6db5ec7049b88bbe8ff640a7fef72#diff-204f5588c0767cf372a5ca7e3fb964afL56



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message