Yuming Wang created SPARK-21646:
-----------------------------------
Summary: BinaryComparison shouldn't auto cast string to int/long
Key: SPARK-21646
URL: https://issues.apache.org/jira/browse/SPARK-21646
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 2.2.0
Reporter: Yuming Wang
Hive:
{code:sql}
$ hive -S
hive> create table tmp.wym_spark_123(c1 string, c2 string);
hive> insert into tmp.wym_spark_123 values('92233720368547758071', 'a');
hive> insert into tmp.wym_spark_123 values('21474836471', 'b');
hive> insert into tmp.wym_spark_123 values('10', 'c');
hive> select * from tmp.wym_spark_123 where c1 > 0;
92233720368547758071 a
10 c
21474836471 b
hive>
{code}
{code:sql}
$ spark-sql -S
spark-sql> select * from tmp.wym_spark_123 where c1 > 0;
10 c
spark-sql> select * from tmp.wym_spark_123 where c1 > 0L;
21474836471 b
10 c
spark-sql> explain select * from tmp.wym_spark_123 where c1 > 0;
== Physical Plan ==
*Project [c1#14, c2#15]
+- *Filter (isnotnull(c1#14) && (cast(c1#14 as int) > 0))
+- *FileScan parquet tmp.wym_spark_123[c1#14,c2#15] Batched: true, Format:
Parquet, Location:
InMemoryFileIndex[viewfs://cluster4/user/hive/warehouse/tmp.db/wym_spark_123],
PartitionFilters: [], PushedFilters: [IsNotNull(c1)], ReadSchema:
struct<c1:string,c2:string>
spark-sql>
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
