drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Volodymyr Vysotskyi (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-5390) Casting as decimal does not make drill use the decimal value vector
Date Mon, 07 May 2018 06:52:00 GMT

     [ https://issues.apache.org/jira/browse/DRILL-5390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Volodymyr Vysotskyi resolved DRILL-5390.
----------------------------------------
    Resolution: Fixed

Fixed in the scope of DRILL-6094

> 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
>          Components: Execution - Data Types
>    Affects Versions: 1.11.0
>            Reporter: Rahul Challapalli
>            Assignee: Volodymyr Vysotskyi
>            Priority: Major
>
> 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
(v7.6.3#76005)

Mime
View raw message