[jira] [Created] (HIVE-27416) ClassCastException for string to decimal64 conversion

[Denys Kuzmenko (Jira)]

Denys Kuzmenko created HIVE-27416:
-------------------------------------

             Summary: ClassCastException for string to decimal64 conversion
                 Key: HIVE-27416
                 URL: https://issues.apache.org/jira/browse/HIVE-27416
             Project: Hive
          Issue Type: Task
            Reporter: Denys Kuzmenko


PROBLEM STATEMENT

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

STEPS TO REPRODUCE
{code}
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;
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)