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

["Hive QA (JIRA)" <ji...@apache.org>]

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

Hive QA commented on HIVE-15939:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12854877/HIVE-15939.1.patch

{color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 10267 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_empty_where] (batchId=22)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_casts] (batchId=75)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_casts] (batchId=154)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3811/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3811/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3811/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 4 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12854877 - PreCommit-HIVE-Build

> 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: Teddy Choi
>         Attachments: HIVE-15939.1.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.3.15#6346)