[jira] [Commented] (HIVE-12328) Join On clause needs a semantic check to verify expression is boolean

["Thejas M Nair (JIRA)" <ji...@apache.org>]

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

Thejas M Nair commented on HIVE-12328:
--------------------------------------

select * from sample_07 a join sample_07 b on (code);
gives -

{code}
Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Boolean
        at org.apache.hadoop.hive.ql.exec.FilterOperator.process(FilterOperator.java:119)
        at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:837)
        at org.apache.hadoop.hive.ql.exec.TableScanOperator.process(TableScanOperator.java:97)
        at org.apache.hadoop.hive.ql.exec.MapOperator$MapOpCtx.forward(MapOperator.java:162)
        at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:508)

{code}

> Join On clause needs  a semantic check to verify expression is boolean
> ----------------------------------------------------------------------
>
>                 Key: HIVE-12328
>                 URL: https://issues.apache.org/jira/browse/HIVE-12328
>             Project: Hive
>          Issue Type: Bug
>          Components: Parser
>    Affects Versions: 1.0.0, 1.2.1
>            Reporter: Thejas M Nair
>            Assignee: Pengcheng Xiong
>
> SQL join query fails at query runtime with a poor error message if the expression in the on clause of join is not a boolean.
> Hive should give a proper error message at runtime.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)