Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-20879

Using null in a projection expression leads to CastException

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.0
    • Component/s: None
    • Labels:
      None

      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)
      
      

        Attachments

        1. HIVE-20879.patch
          4 kB
          David Lavati
        2. HIVE-20879.7.patch
          4 kB
          David Lavati
        3. HIVE-20879.6.patch
          4 kB
          David Lavati
        4. HIVE-20879.5.patch
          4 kB
          David Lavati
        5. HIVE-20879.4.patch
          4 kB
          David Lavati
        6. HIVE-20879.3.patch
          4 kB
          David Lavati
        7. HIVE-20879.2.patch
          4 kB
          David Lavati

          Activity

            People

            • Assignee:
              dlavati-hw David Lavati
              Reporter:
              kgyrtkirk Zoltan Haindrich
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: