[
https://issues.apache.org/jira/browse/CALCITE-1650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15878789#comment-15878789
]
Remus Rusanu commented on CALCITE-1650:
---------------------------------------
In any case, CALCITE-1653 makes this a moot point because suing the Hive
executor for constant simplification circumvents the problem entirely and
yields results that are consistent with Hive.
> Difference in BOOLEAN cast between Hive and Calcite
> ---------------------------------------------------
>
> Key: CALCITE-1650
> URL: https://issues.apache.org/jira/browse/CALCITE-1650
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Remus Rusanu
> Assignee: Julian Hyde
>
> Hive {{CAST( ... AS BOOLEAN)}} gives true for anything 'not zero' (eg.
> {{CAST(1 as BOOLEAN)}} is {{true}}) while Calcite uses strict Java
> {{Boolean.valueOf(...)}} which yields true only for the string 'true'.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
