[jira] [Created] (HIVE-26424) When decimal type has overflowed the specified precision it must throw an error/warning instead of succeeding with NULL entries

["Simhadri G (Jira)" <ji...@apache.org>]

Simhadri G created HIVE-26424:
---------------------------------

             Summary: When decimal type has overflowed the specified precision it must throw an error/warning instead of succeeding with NULL entries
                 Key: HIVE-26424
                 URL: https://issues.apache.org/jira/browse/HIVE-26424
             Project: Hive
          Issue Type: Bug
            Reporter: Simhadri G


When the decimal type has overflowed the specified precision, it results in null entries as seen below:
{code:java}
0: jdbc:hive2://localhost:10001/> select cast(48932.19 AS DECIMAL(6,6));
+-------+
|  _c0  |
+-------+
| NULL  |
+-------+
1 row selected (0.178 seconds){code}
 

This can be a significant issue when inserting a large amount of data from one table to another. This can result in entire columns having NULL entries, as seen below

 
{code:java}


0: jdbc:hive2://localhost:10001/> select * from t2;

+-------------------+
|      t2.num       |
+-------------------+
| 28367.8100000000  |
| 49632.1900000000  |
| NULL              |
| 28367.8100000000  |
| 49632.1900000000  |
| NULL              |
+-------------------+
6 rows selected (0.202 seconds) 

0: jdbc:hive2://localhost:10001/> create table t3(num decimal(20,10));

0: jdbc:hive2://localhost:10001/> insert into t3 select cast(t2.num as decimal(5,2)) from t2;
12 rows affected (40.97 seconds)


0: jdbc:hive2://localhost:10001/> select * from t3;
+---------+
| t3.num  |
+---------+
| NULL    |
| NULL    |
| NULL    |
| NULL    |
| NULL    |
| NULL    |
+---------+
6 rows selected (0.205 seconds){code}
I think it would be better to throw an error as below instead of succeeding. Similar to Mysql.
{code:java}
ERROR : Out of range value for column 'cast(num as decimal(5,2))' {code}
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)