[jira] [Created] (DRILL-5390) Casting as decimal does not make drill use the decimal value vector

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

Rahul Challapalli created DRILL-5390:
----------------------------------------

             Summary: Casting as decimal does not make drill use the decimal value vector
                 Key: DRILL-5390
                 URL: https://issues.apache.org/jira/browse/DRILL-5390
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.11.0
            Reporter: Rahul Challapalli



The below query should be using the decimal value vector. However it looks like it is using the float vector. If we feed the output of the below query to a CTAS statement then the parquet file created has a double type instead of a decimal type

{code}
alter session set `planner.enable_decimal_data_type` = true;
+-------+--------------------------------------------+
|  ok   |                  summary                   |
+-------+--------------------------------------------+
| true  | planner.enable_decimal_data_type updated.  |
+-------+--------------------------------------------+
1 row selected (0.39 seconds)
0: jdbc:drill:zk=10.10.100.190:5181> select typeof(col2) from (select 1 as col1, cast(2.0 as decimal(9,2)) as col2, cast(3.0 as decimal(9,2)) as col3 from cp.`tpch/lineitem.parquet` limit 1) d;
+---------+
| EXPR$0  |
+---------+
| FLOAT8  |
+---------+
{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)