hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5473) sqrt of -ve value returns null instead of throwing an error
Date Mon, 07 Oct 2013 22:13:42 GMT

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

N Campbell commented on HIVE-5473:
----------------------------------

other cases are

select 0 / 0 from tversion
select sqrt ( -4 ) from tversion
select power( 0, -1) from tversion

note, in ISO these should be exceptions
in the first case you get a garbage value lack and infinity in the others
so even if design intent in hive the docs make no statement etc.

> sqrt of -ve value returns null instead of throwing an error
> -----------------------------------------------------------
>
>                 Key: HIVE-5473
>                 URL: https://issues.apache.org/jira/browse/HIVE-5473
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.11.0
>            Reporter: N Campbell
>            Priority: Minor
>
> select sqrt( -4 ) from t
> will return a null instead of throwing an  exception. 
> no discussion on web page that this would be by design to not throw an error.
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message