[jira] [Created] (HIVE-19618) Hive integer data type conversion issures

["songgang1986 (JIRA)" <ji...@apache.org>]

songgang1986 created HIVE-19618:
-----------------------------------

             Summary: 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
             Fix For: 2.3.2


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
(v7.6.3#76005)