Details
Major 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 ;