[jira] [Commented] (HIVE-15939) Make cast expressions comply more to sql2011

["Zoltan Haindrich (JIRA)" <ji...@apache.org>]

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

Zoltan Haindrich commented on HIVE-15939:
-----------------------------------------

Teddy; this is blocking me by evaluating the following the expression: {{ExprNodeEvaluator\[GenericUDFBridge ==> UDFToBoolean (Const string false)\]}} to true.
I'll take it over if you don't mind.

> Make cast expressions comply more to sql2011
> --------------------------------------------
>
>                 Key: HIVE-15939
>                 URL: https://issues.apache.org/jira/browse/HIVE-15939
>             Project: Hive
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Zoltan Haindrich
>            Assignee: Zoltan Haindrich
>         Attachments: HIVE-15939.1.patch, HIVE-15939.2.patch, HIVE-15939.3.patch, HIVE-15939.4.patch, HIVE-15939.5.patch
>
>
> in HIVE-6590 Jason have uncovered the fact that UDFToBoolean treats all non-empty strings as true.
> It would be great to have the cast expressions closer to the standard...at least when there is an expected behaviour from the user;
> like {{cast('false' as boolean)}} should be true.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)