[ https://issues.apache.org/jira/browse/HIVE-3604?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14485688#comment-14485688 ]
Alexander Pivovarov commented on HIVE-3604: ------------------------------------------- Added "If cast(exp as boolean) hive returns true for non-empty string." to LanguageManual UDF https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-TypeConversionFunctions > Casting strings to booleans gives unexpected result > --------------------------------------------------- > > Key: HIVE-3604 > URL: https://issues.apache.org/jira/browse/HIVE-3604 > Project: Hive > Issue Type: Bug > Components: UDF > Affects Versions: 0.8.1 > Environment: Amazon EMR > Reporter: Ariel M > > I would expect the following query to return false in both columns: > select 'false', cast('false' as boolean) from example_table limit 1; > but here are the actual results: > Total MapReduce CPU Time Spent: X seconds X msec > OK > false true -- This message was sent by Atlassian JIRA (v6.3.4#6332)