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

Join on decimal columns fails to return rows

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.11.0
    • Fix Version/s: 0.12.0
    • Component/s: SQL
    • Labels:
      None
    • Environment:

      Linux lnxx64r5 2.6.18-128.el5 #1 SMP Wed Dec 17 11:41:38 EST 2008 x86_64 x86_64 x86_64 GNU/Linux

      Description

      Join on matching decimal columns returns 0 rows

      To reproduce (I used beeline):
      1. create 2 simple identical tables with 2 identical rows:

      CREATE TABLE SERGDEC(I INT, D DECIMAL) ROW FORMAT DELIMITED FIELDS
      TERMINATED BY '|';
      CREATE TABLE SERGDEC2(I INT, D DECIMAL) ROW FORMAT DELIMITED FIELDS
      TERMINATED BY '|';

      2. populate tables with identical data:

      LOAD DATA LOCAL INPATH './decdata' OVERWRITE INTO TABLE SERGDEC ;
      LOAD DATA LOCAL INPATH './decdata' OVERWRITE INTO TABLE SERGDEC2 ;

      3. data file decdata contains:

      10|1111.98
      20|1234567890.1234

      4. Perform join (returns 0 rows instead of 2):

      SELECT T1.I, T1.D, T2.D FROM SERGDEC T1 JOIN SERGDEC2 T2 ON
      T1.D = T2.D ;

        Attachments

        1. D12969.1.patch
          3 kB
          Phabricator

          Activity

            People

            • Assignee:
              navis Navis Ryu
              Reporter:
              sergiolob Sergio Lob
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: