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)
