Ravi Shetye created HIVE-21062:
----------------------------------
Summary: Hive 3.0 auto converts a round decimal to integer
Key: HIVE-21062
URL: https://issues.apache.org/jira/browse/HIVE-21062
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 2.3.4
Reporter: Ravi Shetye
{noformat}
0: jdbc:hive2://localhost:10000> select 1.0 ;
+------+
| _c0 |
+------+
| 1 |
+------+
{noformat}
It happens with parameters to functions as well
{code:java}
0: jdbc:hive2://localhost:10000> select CONCAT("hi",1.0) ;
+------+
| _c0 |
+------+
| hi1 |
+------+
{code}
Hive reads 1.0 as decimal(1,0), and then may be is converting it to int ?
{code:java}
0: jdbc:hive2://localhost:10000> EXPLAIN EXTENDED select 1.0;
+--------------------------------------------------+
| Explain |
+--------------------------------------------------+
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| GatherStats: false |
| Select Operator |
| expressions: 1 (type: decimal(1,0)) |
| outputColumnNames: _col0 |
| ListSink |
| |
+--------------------------------------------------+
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
