Ayush Anubhava created SPARK-25452:
--------------------------------------
Summary: Query with clause is giving unexpected result in case of
float coloumn
Key: SPARK-25452
URL: https://issues.apache.org/jira/browse/SPARK-25452
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 2.3.1
Environment: *Spark 2.3.1*
*Hadoop 2.7.2*
Reporter: Ayush Anubhava
*Description* : Query with clause is giving unexpected result in case of float
column
{code:java}
0: jdbc:hive2://10.18.18.214:23040/default> create table k2 ( a int, b float);
+---------+--+
| Result |
+---------+--+
+---------+--+
0: jdbc:hive2://10.18.18.214:23040/default> insert into table k2 values (0,0.0);
+---------+--+
| Result |
+---------+--+
+---------+--+
0: jdbc:hive2://10.18.18.214:23040/default> insert into table k2 values (1,1.1);
+---------+--+
| Result |
+---------+--+
+---------+--+
0: jdbc:hive2://10.18.18.214:23040/default> select * from k2 where b >=0.0;
+----+--------------------+--+
| a | b |
+----+--------------------+--+
| 0 | 0.0 |
| 1 | 1.100000023841858 |
+----+--------------------+--+
Query with filter less than equal to is giving in appropriate result
0: jdbc:hive2://10.18.18.214:23040/default> select * from k2 where b <=1.1;
+----+------+--+
| a | b |
+----+------+--+
| 0 | 0.0 |
+----+------+--+
1 row selected (0.299 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
