hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Yang (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-1478) Non-boolean expression in WHERE clause throws exception
Date Thu, 22 Jul 2010 00:14:51 GMT
Non-boolean expression in WHERE clause throws exception
-------------------------------------------------------

                 Key: HIVE-1478
                 URL: https://issues.apache.org/jira/browse/HIVE-1478
             Project: Hadoop Hive
          Issue Type: Bug
    Affects Versions: 0.7.0
            Reporter: Paul Yang
            Priority: Minor


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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message