[jira] [Created] (HIVE-20879) Using null in a projection expression leads to CastException

[Zoltan Haindrich (JIRA)]

Zoltan Haindrich created HIVE-20879:
---------------------------------------

             Summary: Using null in a projection expression leads to 
CastException
                 Key: HIVE-20879
                 URL: https://issues.apache.org/jira/browse/HIVE-20879
             Project: Hive
          Issue Type: Bug
            Reporter: Zoltan Haindrich
            Assignee: Zoltan Haindrich


repro:
{code}
create table cx1(bool0 boolean);
select NULL or bool0 from cx1;
{code}

workaround(correct type of null):
{code}
select cast(NULL as boolean) or bool0 from cx1;
{code}

exception:
{code}
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)

{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)