Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 16 Sep 2013 08:51:53 +0000 (UTC)
From: "Phabricator (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12668526.1379097488439.138974.1379321513073@arcas>
In-Reply-To: <JIRA.12668526.1379097488439@arcas>
References: <JIRA.12668526.1379097488439@arcas>
Subject: [jira] [Updated] (HIVE-5292) Join on decimal columns fails to
 return rows
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-5292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Phabricator updated HIVE-5292:
------------------------------

    Attachment: D12969.1.patch

navis requested code review of "HIVE-5292 [jira] Join on decimal columns fails to return rows".

Reviewers: JIRA

HIVE-5292 Join on decimal columns fails to return rows

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 ;

TEST PLAN
  EMPTY

REVISION DETAIL
  https://reviews.facebook.net/D12969

AFFECTED FILES
  common/src/java/org/apache/hadoop/hive/common/type/HiveDecimal.java
  ql/src/test/queries/clientpositive/decimal_join.q
  ql/src/test/results/clientpositive/decimal_join.q.out

MANAGE HERALD RULES
  https://reviews.facebook.net/herald/view/differential/

WHY DID I GET THIS EMAIL?
  https://reviews.facebook.net/herald/transcript/30981/

To: JIRA, navis

                
> Join on decimal columns fails to return rows
> --------------------------------------------
>
>                 Key: HIVE-5292
>                 URL: https://issues.apache.org/jira/browse/HIVE-5292
>             Project: Hive
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 0.11.0
>         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
>            Reporter: Sergio Lob
>            Assignee: Navis
>         Attachments: D12969.1.patch
>
>
> 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 ;

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira