[
https://issues.apache.org/jira/browse/HIVE-5292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13770416#comment-13770416
]
Hudson commented on HIVE-5292:
------------------------------
FAILURE: Integrated in Hive-trunk-hadoop2 #436 (See
[https://builds.apache.org/job/Hive-trunk-hadoop2/436/])
HIVE-5292 : Join on decimal columns fails to return rows (Navis via Ashutosh
Chauhan) (hashutosh:
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1524062)
*
/hive/trunk/common/src/java/org/apache/hadoop/hive/common/type/HiveDecimal.java
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_join.q
* /hive/trunk/ql/src/test/results/clientpositive/decimal_join.q.out
> 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
> Fix For: 0.12.0
>
> 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
