[ https://issues.apache.org/jira/browse/HIVE-21062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ravi Shetye updated HIVE-21062: ------------------------------- Summary: Hive 2.X auto converts a round decimal to integer (was: Hive 3.0 auto converts a round decimal to integer) > Hive 2.X 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 > Priority: Major > > {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)