[
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: [email protected]
For additional commands, e-mail: [email protected]
