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

Vectorization: ClassCastException for string to decimal64 conversion

    XMLWordPrintableJSON

Details

    Description

      PROBLEM STATEMENT

      Caused by: java.lang.ClassCastException: org.apache.hadoop.hive.ql.exec.vector.DecimalColumnVector cannot be cast to org.apache.hadoop.hive.ql.exec.vector.LongColumnVector
      at org.apache.hadoop.hive.ql.exec.vector.expressions.gen.FilterLongColumnBetween.evaluate(FilterLongColumnBetween.java:71)
      at org.apache.hadoop.hive.ql.exec.vector.expressions.FilterExprAndExpr.evaluate(FilterExprAndExpr.java:42)
      at org.apache.hadoop.hive.ql.exec.vector.VectorFilterOperator.process(VectorFilterOperator.java:125)
      at org.apache.hadoop.hive.ql.exec.Operator.vectorForward(Operator.java:968)
      at org.apache.hadoop.hive.ql.exec.TableScanOperator.process(TableScanOperator.java:126)
      at org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.deliverVectorizedRowBatch(VectorMapOperator.java:809)
      at org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.process(VectorMapOperator.java:842)
      

      STEPS TO REPRODUCE

      create external table tbl_parquet(s1_8 string) stored as parquet;      
      insert into tbl_parquet values (43), (44), (45);
            
      select * from tbl_parquet
         where cast(s1_8 as decimal(12, 2)) <= 100 and cast(s1_8 as decimal(12, 2)) >= 0.0;
      

      Attachments

        Issue Links

          Activity

            People

              dkuzmenko Denys Kuzmenko
              dkuzmenko Denys Kuzmenko
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: