You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Ayush Anubhava (JIRA)" <ji...@apache.org> on 2018/09/18 12:40:00 UTC
[jira] [Comment Edited] (SPARK-25452) Query with clause is giving
unexpected result in case of float coloumn
[ https://issues.apache.org/jira/browse/SPARK-25452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16619060#comment-16619060 ]
Ayush Anubhava edited comment on SPARK-25452 at 9/18/18 12:39 PM:
------------------------------------------------------------------
Hi HyukjiKwon ,
Thank you so much for the update.
Will cherry pick the PR and check .
My issue is related with filter where in filter datatype is float .
Ideally if datatype is float then it should internally cast the value as well to the corresponding datatype.
Oracle also behaves the same .i.e we need not give cast explicitly.
was (Author: ayush007):
Hi HyukjiKwon ,
Thank you so much for the update.
Will cherry pick the PR and check .
My issue is related with filter where in filter datatype is float .
Ideally if datatype is float then it should internally cast the value as well to the corresponding datatype.
> 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
> Priority: Major
>
> *Description* : Query with clause is giving unexpected result in case of float column
>
> {color:#d04437}*Query with filter less than equal to is giving inappropriate result{code}*{color}
> {code}
> 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org