[jira] [Commented] (HIVE-1478) Non-boolean expression in WHERE should be rejected

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

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

Zoltan Haindrich commented on HIVE-1478:
----------------------------------------

I'm afraid not...
{code}
select 1 where 1
{code}
fails on the current master

I've opened HIVE-15408 to fix mr / others to support this.

> Non-boolean expression in WHERE should be rejected
> --------------------------------------------------
>
>                 Key: HIVE-1478
>                 URL: https://issues.apache.org/jira/browse/HIVE-1478
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.7.0
>            Reporter: Paul Yang
>            Assignee: Zoltan Haindrich
>            Priority: Minor
>         Attachments: HIVE-1478.1.patch, HIVE-1478.2.patch
>
>
> Automatically casting strings or other types into boolean may confuse even the user - and somehow it doesn't always work (HIVE-15089)
> sql2011 states that "where expression" should accept a boolean expression.
> Original reported problem:
> If the expression in the where clause does not evaluate to a boolean, the job will fail with the following exception in the task logs:
> Query:
> SELECT key FROM src WHERE 1;
> Exception in mapper:
> 2010-07-21 17:00:31,460 FATAL ExecMapper: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row {"key":"238","value":"val_238"}
> 	at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:417)
> 	at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:180)
> 	at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
> 	at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:358)
> 	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:307)
> 	at org.apache.hadoop.mapred.Child.main(Child.java:159)
> Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Boolean
> 	at org.apache.hadoop.hive.ql.exec.FilterOperator.processOp(FilterOperator.java:84)
> 	at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:457)
> 	at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:697)
> 	at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:45)
> 	at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:457)
> 	at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:697)
> 	at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:400)
> 	... 5 more



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