You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Denys Ordynskiy (JIRA)" <ji...@apache.org> on 2019/07/08 16:00:00 UTC
[jira] [Closed] (DRILL-6472) Drill allows to use decimal zero
precision in CAST function for CTAS
[ https://issues.apache.org/jira/browse/DRILL-6472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Denys Ordynskiy closed DRILL-6472.
----------------------------------
> Drill allows to use decimal zero precision in CAST function for CTAS
> --------------------------------------------------------------------
>
> Key: DRILL-6472
> URL: https://issues.apache.org/jira/browse/DRILL-6472
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.14.0
> Reporter: Denys Ordynskiy
> Assignee: Volodymyr Vysotskyi
> Priority: Major
> Labels: ready-to-commit
> Fix For: 1.14.0
>
>
> I can run query with casting data for decimal with zero precision in SELECT statement
> {code:java}
> select cast(1111.05 as decimal(0,5));
> {code}
> {code:java}
> +-------------+
> | EXPR$0 |
> +-------------+
> | 1111.05000 |
> +-------------+
> {code}
> Also I can use this query for CTAS
> {code:java}
> create table dfs.tmp.`zero_pr` as select cast(1111.05 as decimal(0,5));
> {code}
> {code:java}
> +----------+---------------------------+
> | Fragment | Number of records written |
> +----------+---------------------------+
> | 0_0 | 1 |
> +----------+---------------------------+
> {code}
> But when I try to select data from this table, I get an error:
> {code:java}
> create table dfs.tmp.`zero_pr` as select cast(1111.05 as decimal(0,5));
> {code}
> {code:java}
> Error: SYSTEM ERROR: IllegalArgumentException: Invalid DECIMAL precision: 0 [Error Id: 2e320f55-aa65-4127-82be-6256e0744bdc on maprhost:31010] (state=,code=0){code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)