drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denys Ordynskiy (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-6472) Drill allows to use decimal zero precision in CAST function for CTAS
Date Wed, 06 Jun 2018 13:08:00 GMT
Denys Ordynskiy created DRILL-6472:
--------------------------------------

             Summary: 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


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)

Mime
View raw message