[ https://issues.apache.org/jira/browse/HIVE-19618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stamatis Zampetakis updated HIVE-19618: --------------------------------------- Fix Version/s: (was: 2.3.2) I cleared the fixVersion field since this ticket is still open. Please review this ticket and if the fix is already committed to a specific version please set the version accordingly and mark the ticket as RESOLVED. According to the [JIRA guidelines|https://cwiki.apache.org/confluence/display/Hive/HowToContribute] the fixVersion should be set only when the issue is resolved/closed. > Hive integer data type conversion issures > ----------------------------------------- > > Key: HIVE-19618 > URL: https://issues.apache.org/jira/browse/HIVE-19618 > Project: Hive > Issue Type: Bug > Components: Vectorization > Affects Versions: 2.3.2 > Environment: hive version: 2.3.3 > hadoop version: 2.7.5 > Reporter: songgang1986 > Assignee: songgang1986 > Priority: Critical > Original Estimate: 672h > Remaining Estimate: 672h > > Hi, experts: > Recently, i came across some problems in my hive application, i wondered > if it is a bug in hive or did some else has the same experience. the problem > is as follows: > drop table if exists tb_int; > create table tb_int(val int); > insert into tb_int values(1); > drop table if exists tb_bigint; > create table tb_bigint(val bigint); > insert into tb_bigint values(11); > insert into tb_int select abs(val) from tb_bigint; > select * from tb_int; > i expected the result is : > 1 > 11 > bu , what i actually got is: > 1 > 0 > I think the result is not reasonable, is it a bug in hive? my hive > version is 2.3.3, and i tested the 2.3.0 version, the result is the same. > Could someone give some help, thanks! > > > -- This message was sent by Atlassian Jira (v8.20.10#820010)