[jira] [Created] (SPARK-21646) BinaryComparison shouldn't auto cast string to int/long

["Yuming Wang (JIRA)" <ji...@apache.org>]

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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org