[HIVE-20879] Using null in a projection expression leads to CastException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: David Lavati
• Reporter: Zoltan Haindrich
• Created: 07/Nov/18 15:30
• Updated: 17/Nov/22 08:54
• Resolved: 21/Jan/19 13:55

Description

repro:

create table cx1(bool0 boolean);
select NULL or bool0 from cx1;

workaround(correct type of null):

select cast(NULL as boolean) or bool0 from cx1;

exception:

2018-11-07T07:28:39,628 ERROR [3533166f-7174-45cd-9d9e-d487038cb6e0 main] ql.Driver: FAILED: ClassCastEx
ception org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableVoidObjectInspector cannot be ca
st to org.apache.hadoop.hive.serde2.objectinspector.primitive.BooleanObjectInspector
java.lang.ClassCastException: org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableVoidObject
Inspector cannot be cast to org.apache.hadoop.hive.serde2.objectinspector.primitive.BooleanObjectInspect
or
        at org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPAnd.initialize(GenericUDFOPAnd.java:56)
        at org.apache.hadoop.hive.ql.udf.generic.GenericUDF.initializeAndFoldConstants(GenericUDF.java:1
48)
        at org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc.newInstance(ExprNodeGenericFuncDesc.ja
va:260)
        at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprN
odeDesc(TypeCheckProcFactory.java:1251)
        at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckPr
ocFactory.java:1660)
        at org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90)
        at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:10
5)