[ https://issues.apache.org/jira/browse/DRILL-6472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Volodymyr Vysotskyi reassigned DRILL-6472: ------------------------------------------ Assignee: Volodymyr Vysotskyi > 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 > > 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)