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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Component/s: Execution - Data Types
• Assignee: Vova Vysotskyi
• Reporter: Rahul Kumar Challapalli
• Created: 28/Mar/17 00:55
• Updated: 07/May/18 06:51
• Resolved: 07/May/18 06:51

Description

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

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  |
+---------+

Issue Links

• relates to: DRILL-6094 Decimal data type enhancements