Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-19618

Hive integer data type conversion issures

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 2.3.2
    • Fix Version/s: 2.3.2
    • Component/s: Vectorization
    • Labels:
      None
    • Environment:

      hive version: 2.3.3

      hadoop version: 2.7.5

    • Target Version/s:
    • Hadoop Flags:
      Reviewed
    • Flags:
      Important

      Description

      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!

       

       

       

        Attachments

          Activity

            People

            • Assignee:
              songgang1986 songgang1986
              Reporter:
              songgang1986 songgang1986
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - 672h
                672h
                Remaining:
                Remaining Estimate - 672h
                672h
                Logged:
                Time Spent - Not Specified
                Not Specified