hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "r7raul1984@163.com" <r7raul1...@163.com>
Subject join on different data type
Date Mon, 04 May 2015 05:07:24 GMT
SELECT ....
FROM A LEFT SEMI JOIN B
ON (A.col1 = B.col2)
WHERE ...
"
If A.col1 is of DOUBLE type, but B.col2 is of BIGINT,  will print WARNING: Comparing a bigint
and a double may result in a loss of precision.   Why can't cast col2 to double automatically?



r7raul1984@163.com
Mime
View raw message